|Summary:||setArrayFormula does not work when creating a SXSSFWorkbook|
|Component:||SXSSF||Assignee:||POI Developers List <dev>|
|Attachments:||example to create a valid (XSSFWorkbook) and a invalid (SXSSFWorkbook) workbook|
Description torsten 2017-10-23 08:38:00 UTC
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.
Comment 1 Dominik Stadler 2017-12-28 13:36:23 UTC
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.