Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook

Information

 
Article Number000082802
EnvironmentProduct: Rollbase Private Cloud
Version: 4.5.3
Question/Problem Description
Report created from an .xls Doc Template throws IllegalStateException if there are a large number of records / columns in the template.
Steps to Reproduce
Clarifying Information
Error Messagejava.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:1310)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:105)
at com.rb.core.services.template.impl.ApachePOIXLSParser$WorksheetParser.parseCell(ApachePOIXLSParser.java:228)
at com.rb.core.services.template.impl.ApachePOIXLSParser$WorksheetParser.processLoop(ApachePOIXLSParser.java:317)
at com.rb.core.services.template.impl.ApachePOIXLSParser$WorksheetParser.parseSheet(ApachePOIXLSParser.java:204)
at com.rb.core.services.template.impl.ApachePOIXLSParser$WorksheetParser.access$100(ApachePOIXLSParser.java:160)
at com.rb.core.services.template.impl.ApachePOIXLSParser.parseXLS(ApachePOIXLSParser.java:147)
at com.rb.core.services.template.impl.ApachePOIXLSParser.parse(ApachePOIXLSParser.java:58)
at com.rb.core.services.template.a530.process(a530.java:96)
at com.rb.core.logics.servlet.TemplateServlet.doGet(TemplateServlet.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
Defect/Enhancement NumberDefect 75834 / RB-6161
Cause
Report has too many columns / rows. Error stems from the Apache Poi framework.
Resolution
None at this time. Use the workaround below.
Workaround
Use .xlsx or .csv format for the Document Template, and use this template in the Document Template Report.
Notes
Attachment 
Last Modified Date4/15/2019 4:56 AM