Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Ram
40
UltraGridExcelExporter not export large numbers as numbers
posted

Hi,

I am trying to export an UltraWinGrid. The grid has currencies. Some are smaller and some are larger in with the format of  ("#,##0;(#,##0)";) When I export to excel some values are not exported as numbers which are larger like (2407390997). Excel is treating them as string instead of numbers. I have done the formatting also in the CellExported method but even that doesn't help.

Any help is much appreciated.

Regards,

Ram

  • 44743
    posted

    Try setting the value type of the column to double. Its possible the numbers are too large for the column's data type and the grid, not the export process, is automatically converting the numbers to strings. Also, numbers are stored in the workbook file as doubles anyway, so they will eventually be converted to this format before exporting.