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
60
UltraWinGrid: Export to Excel
posted

Hi,

We are using a UltraGrid to display some records, of which, one of the column's data type is Decimal(28) very similar to Guid.

When we do export to excel feature, this decimal columns appears as exponential value.

Please do let me know if there is any fix for this issue.

Thanks and Regards,

Vikarm

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    Hi Vikarm,

        The grid doesn't export the data with any formatting, it simply exports the cell value. So it must be Excel that is formatting the data. The default numeric format for a cell in Excel probably shows the number in scientific notation if it exceeds a certain length. You can use the InitializeColumn event of the ExcelExporter to set e.ExcelFormatStr to a format that you want. You will need to check Excel's documentation to see if there is a format that will do what you want.

Children