I'm noticing that when I export to Excel, what gets exported is the display and not the value. For example, if I have a cell with the value 751.82 in it, but I'm formatting it rounded to the nearest dollar, it'll appear as 752 in the cell, and when I export, I'll have 752 in the corresponding cell in Excel, rather than 751.82 formatted to 752. Is there a setting in the exporter that will have it export the actual values?
Hello Lisa,
I believe that a similar issue has been discussed in the following forum thread. It suggests that he UltraGridExcelExporter converts the grid formula into an Excel Formula, however there is a property that can disable this functionality. This can be done by setting the ExportFormulas of the UltraGridExcelExporter to false.
Additionally, if this is not the case that I recommend you handling the CellExporting event and set the value there.
Please let me know if you need any further assistance.
Regards, Ivan Kitanov