You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In certain cases XSSFSheet.GroupColumn() produces a overly large columns array in the xml output.
LibreOffice seems to interpret it properly (not sure if always) while Office 365 will either group the wrong number of columns or display no outline at all.
I've found out that it seems to work when it's applied to an empty sheet, when columns aren't present yet. When it's applied after some columns have been created then it seems to multiply them internally and produce wrong results.
The multiplication seems to happen in columnHelper.AddCleanColIntoCols(colsArray, newCol). In a debug session I did the following:
created a sheet with 34 columns filled with some data and attributes
grouped columns from 4 to 31
after AddCleanColIntoCols() the column array contained 93 entries (!) and these were reflected in the produced xlsx file.
If I swap steps 1 and 2 then the resulting column array seems to be correct.
The text was updated successfully, but these errors were encountered:
In certain cases XSSFSheet.GroupColumn() produces a overly large columns array in the xml output.
LibreOffice seems to interpret it properly (not sure if always) while Office 365 will either group the wrong number of columns or display no outline at all.
I've found out that it seems to work when it's applied to an empty sheet, when columns aren't present yet. When it's applied after some columns have been created then it seems to multiply them internally and produce wrong results.
The multiplication seems to happen in columnHelper.AddCleanColIntoCols(colsArray, newCol). In a debug session I did the following:
If I swap steps 1 and 2 then the resulting column array seems to be correct.
The text was updated successfully, but these errors were encountered: