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: dev@poi.apache.org Reporter: martin.schloe...@x-map.de 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: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org