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,
I ran your sample and there is definitely something weird going on. It's hard to tell from your sample since all of the rows have the same values in every cell. But when I played around with it and narrowed it down a bit, I can see that not only is the indentation wrong, but it's wrong for some rows in the same collection and not other.
For example, if I narrow the sample down to only 2 bands and a single root-level row, the first child row in the Excel sheet is not indented, but the other child rows are. So this is clearly a bug.
I have forwarded this thread over to Infragistics Developer Support and asked them to create a case for you so we can get this fixed.
I was finally able to determine the necessary settings to reproduce this issue, please find the repro case attached.
To view the issue, run the program and click the 'export' button at the bottom. Open the exported excel document and drill down into one of the row until you reach the bottom-most band. Notice that all columns are properly aligned to the left except for rows in the bottom-most band, which is indented significantly; seemingly proportionally to the number of bands.
This was most recently run against the very latest 12.1 service release.
There are a whole lot of variables here, so it's really hard for me to see what you are referring to. Can you post a small sample project demonstrating the behavior you are now getting?
Correction, this has NOT been completely fixed under 11.1.20111.2042.
All bands are properly aligned except for the bottom-most level, which seems to be offset to the right by the number of parent bands above it.
EDIT: The same behavior exists with 11.2
This issue was indeed corrected by the latest service release (11.1.20111.2042).