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]
This behavior was broken further with the aforementioned service release.
1. Every child band is now indented, throwing all column alignment off. Previously it was only the bottom-most band that was shifted out of place.
2. When the export is opened in Excel 2007, the "band" expansion indicators indicate the collapsed state (shows a 'plus' sign) even after the "band" has been expanded. This makes it impossible to collapse the row again once it is expanded. This regression has been fixed in the upcoming service release.
It should also be noted that I was told by support that the behavior of #1 is the now the "fixed" behavior; there will now by default be an alignment discrepency between the grid and the export. The component will no longer try to align the columns correctly and if you want to have the columns aligned properly you will have to force it explicitly in code during the export process.
Hello,
The fix for "Cell placement in multiband Excel Export" has been resolved in NetAdvantage 2011 Volume 2 and newer. To take advantage of this fix, please download the latest service release using the instructions found here: http://community.infragistics.com/forums/t/29398.aspx
Please let me know if you have any questions.
Hi rastedt,
As requested, I have created a case to update you via the "my support activity" section of your account. Please note that I will be updating this forum with the information needed to resolve this issue once our developers have completed their review of Development ID 113828.
Please letme know if you have any questions regarding this matter.
Is a case number available for this issue yet and should I anticipate seeing it added to the 'my support activity' section of my account?
I have investigated your issue regarding incorrect row indentations when exporting Grid to Excel. I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 113828. The next step will be for a developer to review my investigation and confirm my findings or to offer a fix, or other resolution.
I will update you with any new information after the review. You can also update this forum post with any questions you may have.
Please let me know if you need more information.