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

Reply via email to