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

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

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

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

Dominik Stadler <[hidden email]> changed:

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

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

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

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61648

--- Comment #1 from Dominik Stadler <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

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

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61648

--- Comment #2 from Dominik Stadler <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]