[Bug 57880] New: Writing negative cellStyleIndex into sheet1.xml

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

[Bug 57880] New: Writing negative cellStyleIndex into sheet1.xml

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

            Bug ID: 57880
           Summary: Writing negative cellStyleIndex into sheet1.xml
           Product: POI
           Version: 3.11-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]

Created attachment 32710
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32710&action=edit
Java code

When creating large excel file and creating more than 32,767 (MAX VALUE for
short) cellStyles, POI writes into sheet1.xml file negative values for that
index: next after 32,767 comes -32,768, then -32,767, -32,766, etc...
This creates corrupted xlsx file.

--
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 57880] Writing negative cellStyleIndex into sheet1.xml

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

--- Comment #1 from Michael <[hidden email]> ---
Created attachment 32711
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32711&action=edit
template xlsx file

--
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 57880] Writing negative cellStyleIndex into sheet1.xml

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=57880

Nick Burch <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #2 from Nick Burch <[hidden email]> ---
In r1677371 I've added fixes for data formats and cell styles > 32,767 in XSSF,
along with a (slightly slow) unit test showing that things work fine

If I've missed some bit of your use case in the unit test, and some part of the
problem still remains, please re-open this bug and attach an updated unit test
showing what remains

--
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 57880] Writing negative cellStyleIndex into sheet1.xml

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=57880

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |58005

--
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 57880] Writing negative cellStyleIndex into sheet1.xml

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=57880

--- Comment #3 from Javen O'Neal <[hidden email]> ---
The xlsx file may be corrupted if you create too many data formats. Excel only
supports between 200-250 data formats. See bug 58775.

--
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 57880] Writing negative cellStyleIndex into sheet1.xml

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=57880

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |57884


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=57884
[Bug 57884] XSSFDataFormat.getFormat is slow with large numbers of formats
--
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]