I am using the UltraGridExcelExporter to create an excel worksheet. The grid I am exporting has multiple bands, the column collections in all of the bands are the same and in the same visible order and the column width are aligned. See attached screenshot.jpg.
In the exported file the cells are not aligned properly (the headers are correct). The first band is offset by 6 cells, i.e. what should be in cell A2 is in cell G2. For the remaining bands the cells are offset by a number corresponding to the band index, the first cell of band index 1 is in column B, for band index 2, column C, etc. See attached export.xlsx.
Is there anything I can do to make the exported cells appear in the same column they do in the grid?
[I am using version 10.3.20103.2094]
Hi,
My apologies, the fix for this issue didn't make it into the latest service release, it will be in the next one.
You can see the service release schedule here: Infragistics Service Releases
With the latest service release of v11 (11.1.20111.2030) this issue persists. The exported excel document was identically mis-spaced as with the older version of 10.3.
I'm pretty sure this is a known bug which is fixed. Try getting the latest service release - there was a newer one than the build you are using released in September.
How to get the latest service release - Infragistics Community