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
65
Exporting to Excel via UltraGridExcelExporter...
posted

i am currently using ultraWinGrid v6.3 on XP professional with C# and .NET 1.1

there seems to be an issue with formatting when exporting grid cells to Excel. For example, an amount value of 677,500.00 within the grid will be displayed in Excel as 677500 and a type value of  "INT" will be displayed as "Interest" in Excel.  Is there a way to have the formatting consistent?

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    I'm not sure what you mean about "INT" and "Interest". But regarding the numeric formatting, I assume you are using the Format property of the column in the grid. What this property does is call ToString on the Value of the cell and pass in the format. But the DotNet formats are not the same syntax as formatting in Excel - or at least not always. So what you need to do is handle the InitializeColumn event on the UltraGridExcelExporter. This event will give you the format applied to the grid column and allow you to convert it to an appropriate format in Excel. Very often, you can just set one equal to the other, but that doesn't always work so it's not done automatically. 

Children
No Data