Summary: | setArrayFormula does not work when creating a SXSSFWorkbook | ||
---|---|---|---|
Product: | POI | Reporter: | torsten <gent.ju00> |
Component: | SXSSF | Assignee: | POI Developers List <dev> |
Status: | NEW --- | ||
Severity: | normal | ||
Priority: | P2 | ||
Version: | 3.17-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: | example to create a valid (XSSFWorkbook) and a invalid (SXSSFWorkbook) workbook |
It fails because currently SXSSFSheet tries to use XSSFSheet for storing the array formulas, but this causes rows to be created in the sheet at SXSSFSheet._sh and this way some rows are written twice to the sheetX.xml file. Full support for array formulas is likely some more work as they will need to be kept in the SXSSFSheet and "merged in" whenever normal rows are written to the xml-file instead of being added to the XSSFSheet. |
Created attachment 35448 [details] example to create a valid (XSSFWorkbook) and a invalid (SXSSFWorkbook) workbook If a workbook of type SXSSFWorkbook is created with a array formula, the workbook will contain invalid data.