[Bug 63613] New: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook Issue

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

[Bug 63613] New: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook Issue

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

            Bug ID: 63613
           Summary: The maximum number of Cell Styles was exceeded. You
                    can define up to 64000 style in a .xlsx Workbook Issue
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

I have tried to export large number of data . I am using 3.15 Version applying
style to cells like Text, Date, Number.

Throwing below error

java.lang.IllegalStateException: The maximum number of Cell Styles was
exceeded. You can define up to 64000 style in a .xlsx Workbook
        at
org.apache.poi.xssf.model.StylesTable.createCellStyle(StylesTable.java:789)
        at
org.apache.poi.xssf.usermodel.XSSFWorkbook.createCellStyle(XSSFWorkbook.java:715)
        at
org.apache.poi.xssf.streaming.SXSSFWorkbook.createCellStyle(SXSSFWorkbook.java:868)

--
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 63613] The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook Issue

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

Ashok Mahendran <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
                   |                            |om
                 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 63613] The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook Issue

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

--- Comment #1 from PJ Fanning <[hidden email]> ---
POI 3.15 is no longer maintained. Could you try POI 4.1.0?

Could you provide a test case if this issue appears in POI 4.1.0 too?

--
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 63613] The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook Issue

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

Dominik Stadler <[hidden email]> changed:

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

--- Comment #2 from Dominik Stadler <[hidden email]> ---
I think this is "as expected". Microsoft Excel limits the number of styles in
Excel files and thus POI also limits them. The Exception tells you that you try
to create more styles than possible.

Usually this indicates incorrect usage of the API. You need to re-use styles
and not create fresh ones for each and every cell, then also performance in
both Apache POI and Excel itself may be better as much less styles need to be
handled when opening/saving the 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]