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
55
Excel: not able to "Format Cells" on exported data
posted

G'day,
I am wondering if there is a programmatic solution to this problem please because my customers are complaining!

When I export data from an ASP.NET UltraGrid to Excel via Infragistics UltraGrid Exporter, I then select an entire column within Excel and choose "Format Cells...", but the usual dialog box does not appear.  Instead nothing happens.

In fact, I can go further than this and merely right-click the column heading and choose "Format Cells..." and nothing happens.

If I select the entire Heading row in Excel and choose "Edit | Clear | Formats" then all is well after that.

Infragistics must be doing something special to the Column Heading when it exports and I am hoping it's possible to stop this.  How is this possible please?

Thank-you,
Mr.Bin