https://issues.apache.org/bugzilla/show_bug.cgi?id=50868
Summary: Performance of sheet.setDefaultColumnStyle(col, style)
degrades as more columns are added
Product: POI
Version: 3.7
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Created an attachment (id=26729)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26729)
Java program to test performance of sheet.setDefaultColumnStyle(col, style) for
different no. of columns
When creating an Excel sheet with thousands of columns, the performance of
sheet.setDefaultColumnStyle(col, style) keeps degrading as more and more
columns are added. For every call to this method with a new column, the time
taken by the method keeps on increasing.
Please execute the attached test program with 1000 columns or more, and notice
the time taken by the method for every 100th column. The CPU consumption also
reaches 100% during execution of the program.
Please note: Though the test program sets only one default style for all the
columns, in practice, I need to create an Excel sheet with different default
styles for different columns.
Because of the performance issue, creating large Excel sheets with thousands of
columns is time-consuming and it is also consuming a lot of CPU for the entire
duration.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
