Does your grid control support the loading of data from and excel file (using the importXL method) as well as calculated columns in-between the columns/rows loaded as a result of the importXL data load?
I want to load all the data from an .xlsx file, but also insert new columns inside the loaded grid that has formulas such as "MID(N3,6,19)”.
Is this possible ??
