Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
435
Bug in Excel export: With grouped by column(s), when HeaderVisible = True, Caption-Row is moved to the left in exported Excel
posted

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 

ExampleProject_ExcelExportBug.zip