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 2015/05/01 17:26:31 UTC

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

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: dev@poi.apache.org
          Reporter: mshlayen@smart-solution.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 57880] Writing negative cellStyleIndex into sheet1.xml

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

Dominik Stadler <do...@gmx.at> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 57880] Writing negative cellStyleIndex into sheet1.xml

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

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

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

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

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

--- Comment #1 from Michael <ms...@smart-solution.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 57880] Writing negative cellStyleIndex into sheet1.xml

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

Nick Burch <ap...@gagravarr.org> changed:

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

--- Comment #2 from Nick Burch <ap...@gagravarr.org> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 57880] Writing negative cellStyleIndex into sheet1.xml

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

--- Comment #3 from Javen O'Neal <on...@apache.org> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org