Hi Marc,
I got hit by this issue. I found the answer to your questions in the
following thread:
http://markmail.org/message/d4iemconxozxgb2v
I did my own tests in a recent cocoon revision 2.1.12-dev (r662435)
running on 64M of Memory and I found if a StyleRegion is around 2^22
cells it throws out an OOME. Hence it looks that the limit makes sense.
Here is the sample region I tested:
<gmr:StyleRegion startCol="0" startRow="0" endCol="255" endRow="16383">
.....
</gmr:StyleRegion>
On the other side the current limit of 2,000 cells is quite low. I think
we can change it to a higher value up to 2^21 to stay safe in a 64MB
environment. But the problem is that it generates a huge XLS document of
20MB. Another problem I found switching to 2^21 is that I cannot
generated the same document a 2nd time.
Perhaps switching from 2K to 2^16 as suggested by Matt Savino in his
mail makes sense. Quoting:
"I changed the MAX_AREA constant to 65536 so that it could handle one entire
column. I saved the Excel file using both MAX_AREAs and at least for my app
there was no appreciable difference in file size (765k v. 766k)."
WDYT?
Best Regards,
Reynaldo Porras
Marc Portier escribió:
Hi there,
I've ran accross a hard-coded limit in our ms-excel-format serizalizer
(and it looks like I'm the second one :-)
http://issues.apache.org/bugzilla/show_bug.cgi?id=24490 )
$ find -name EPStyleRegion.java |xargs cat -n |head -65|tail
$ find -name EPStyleRegion.java |xargs cat -n |head -102|tail -16
It causes style-formatting-regions to be ignored if they span more then
2000 cells.
Apart from the (to me quite dense) remarks in the code there is little
to be found about what are the actual motives for this, or how we could
assess if the limitations still stand in todays world or not.
In fact, in terms of code-evolution I could only find this limit
appeared to be in the original commit already.
http://marc.theaimsgroup.com/?l=xml-cocoon-dev&m=103825320630080&w=2
Does anybody remember anything about this?
Does anybody have an idea about verifying if the limitation could be
removed?
kind regards,
-marc=
