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
James
230
Matching excel cell format to grid cell format
posted

 Hello,

I have inherited an app that exports the rows of a grid to an excel spreadsheet.  How can I set the properties of an Excel column to the grid's column?

 Simply, I want to set the excel column to currency like the corresponding grid's column.

 

Thanks

  • 469350
    Offline posted

    Hi James,

    DotNet formats aren't neccessarily the same as Excel formats. So the grid can't translate them for you automatically. What you should do is handle the InitializeColumn event of the exporter. This event wil pass you the format applied to the grid column and allow you to set the corresponding Excel format. A lot of times they are the same and you can just set one to the other.