Hello!
I have a column which is in fact a formula, than on top of that formula I have a Value List that displays proper value in the grid. However, when I export the grid to Excel that column doesn't display a Value List value instead it exports formula result.
Does anyone know how I can force ExcelExporter to export what's displayed on the grid instead of underlying value?
Thanks.
Hi,
By default, the UltraGridExcelExporter converts the grid formula into an Excel Formula. So it's probably exporting the formula instead of the cell text and that's why it's not working the way you want.
The good news is that this is very easy to fix. Just set ExportFormulas on the UltraGridExcelExporter to false.
Thanks, that resolved the issue
Hello,
We are glad that your issue is solved.
Please do not hesitate to ask if you have any other questions.