You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2017/10/23 08:38:00 UTC

[Bug 61648] New: setArrayFormula does not work when creating a SXSSFWorkbook

https://bz.apache.org/bugzilla/show_bug.cgi?id=61648

            Bug ID: 61648
           Summary: setArrayFormula does not work when creating a
                    SXSSFWorkbook
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SXSSF
          Assignee: dev@poi.apache.org
          Reporter: gent.ju00@gmx.net
  Target Milestone: ---

Created attachment 35448
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35448&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 61648] setArrayFormula does not work when creating a SXSSFWorkbook

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61648

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 61648] setArrayFormula does not work when creating a SXSSFWorkbook

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61648

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 61648] setArrayFormula does not work when creating a SXSSFWorkbook

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61648

--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
With r1819770 we throw an "Unimplemented" Exception when you try to set an
array formula for SXSSF to make this more visible instead of creating corrupt
files.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org