When a column in pinned in a grid and the the grid is exported to Excel2007 format using the UltraGridExporter should the columns be pinned in Excel?
Hi,
No, this isn't really possible, since the columns aren't necessarily mapped one to one. For example, if you have child bands, then the second column in Excel will contain cells from the second Column in Band 0 and the first Column in the child band at the same time.
Thanks for the quick response.
If you have a flat data structure, you can do this on the Worksheet instance being exported, either before or after the export. You can do this by settings Worksheet.DisplayOptions.PanesAreFrozen to True and Worksheet.DisplayOptions.FrozenPaneSettings.FrozenColumns to the number of columns you would like to be pinned.