https://bz.apache.org/bugzilla/show_bug.cgi?id=66687
Bug ID: 66687
Summary: Combination of XSSF and SXSSF may result in invalid
files
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 38600
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38600&action=edit
Test case to produce a file that Excel will have trouble with
When mixing XSSF and SXSSF and not creating XSSF cells in the correct order,
the resulting file will contain the broken cell order, leading Excel to display
a repair option and losing data.
This is achieved by adding XSSF cells and then adding new rows with SXSSF, thus
bypassing both mechanisms that would have sorted the cells.
I assume calling XSSFRow.onDocumentWrite for the sorting even when
dimensionOverride is set would fix the issue.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
