I created a application that takes a bean out of request and generate a xls (using gnumeric intermediate format) and a pdf (using xml:fo).
The generation of xls is very slow. If I drop all <gmr:StyleRegion startCol="0" startRow=.... from my xml, the generation is about 9 time faster.
I have a waning into core log :
DEBUG (2003-11-05) 12:14.17:502 [core.manager] (/eptos/jsp/excel_pipe.jsp) T
hread-18/EPStyle: going out of the format kludger General
very many times
I tried to change Format="General" to other formats like : "0", "@", .... but no result.
If I change this to 0, the message changed to :
DEBUG (2003-11-05) 12:14.17:502 [core.manager] (/eptos/jsp/excel_pipe.jsp) T
hread-18/EPStyle: going out of the format kludger 0
My styleRegions look like :<gmr:StyleRegion startCol="0" startRow="{count(descendant::propertyBean) + 1}" endCol="10" endRow="{count(descendant::propertyBean) + 1}"><gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="@"><gmr:StyleBorder><gmr:Top Style="1" Color="0:0:0"/><gmr:Bottom Style="0"/><gmr:Left Style="0"/><gmr:Right Style="0"/><gmr:Diagonal Style="0"/><gmr:Rev-Diagonal Style="0"/></gmr:StyleBorder></gmr:Style></gmr:StyleRegion>
I have a lot of such regions because the client wants to have different borders / fonts for every row in the sheet. (And I have a lot of rows). Performance results: 1. without StyleRegions: 122 rows => 0.210 seconds 1417 rows => 11.97 seconds 2712 rows => 42.63 seconds 2. with StyleRegions: 122 rows => 2.544 seconds 1417 rows => 19.468 seconds 2712 rows => 4.26 minutes and excel said "Too many different cell formats" and then "Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please recheck your formatiing carefully." If I do the same tests by generating pdfs (with styles and formatting): 122 rows => 1.722 seconds 1417 rows => 6.34 seconds (10 pages) 2712 rows => 25.2 seconds (38 pages) I tuned up the cocoon as much as I could. Any ideea how to improove the performance? Is there any other way to replace the Styles with other concepts (I need borders and fonts / every cell). Thanx Marius -- "Why program by hand in five days what you can spend five years of your life automating." - Terence Parr
