Hello,
we just discovered a bug in the Excel export of the UltraGrid (with UltraGridExcelExporter).If you use grouping (group by column(s)) and set HeaderVisible of a band to True, the first exported row in Excel is the band header and starts in a column more to the right. The second row is the row with the column headers, but this one starts always in the first column, which is a bug.(If you don't set HeaderVisible to True, the first row holds the column headers and then starts in the correct column)
I attached a sample project for better understanding. To reproduce the bug, just start the application and click on the "Excel Export" button in the lower left and then have a look at the resulting excel file.You can clearly see that the first 3 columns are used by the GroupByRow "headers" and that the first row holds the band caption text and starts in column 4. The second row however starts in column 1, which isn't the expected behaviour (it should start in column 4 too). Every other row after that (the data rows, to be precise) start in column 4, like expected.
sincerely,NDE
This issue has been resolved in the latest Service Release for Infragistics 2013 Volume 2 for Windows Forms as of the date of this post.
Hello NDE,
Thank you for contacting Infragistics.
I have reproduced the issue you described and I've submitted it to our engineers for further review. I've also created CAS-130083-V7V3R7 to track this. I've provided more details through the support case.