Bug 24490 - StyleRegion bug ?
Summary: StyleRegion bug ?
Status: RESOLVED LATER
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: All All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-07 12:09 UTC by Ricardo Caniceiro Pavoni
Modified: 2008-08-05 15:56 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ricardo Caniceiro Pavoni 2003-11-07 12:09:26 UTC 
Hi. 

  I am using a stylesheet to generate excel reports with HSSF (Cocoon 2.1.1 and 
POI 1.10.o-dev). 
  In the stylesheet , I have a piece of code that is used to format data:

   ...

            <gmr:StyleRegion endCol="0" startCol="0" endRow="318" startRow="6">
               <gmr:Style Format="#,##0.00#" PatternColor="0000:0000:0000" 
Back="0000:0000:0000" Fore="0:0:0" Hidden="0" Locked="0" Indent="0" Shade="1" 
Orient="1" WrapText="1" VAlign="1" HAlign="2">
                  <gmr:Font StrikeThrough="0" Underline="0" Italic="0" Bold="0" 
Unit="10">Arial</gmr:Font>
                  <gmr:StyleBorder>
                     <gmr:Top Color="3333:3333:3333" Style="1" />
                     <gmr:Bottom Color="3333:3333:3333" Style="1" />
                     <gmr:Left Color="3333:3333:3333" Style="1" />
                     <gmr:Right Color="3333:3333:3333" Style="1" />
                     <gmr:Diagonal Style="0" />
                     <gmr:Rev-Diagonal Style="0" />
                  </gmr:StyleBorder>
               </gmr:Style>
            </gmr:StyleRegion>
            <gmr:StyleRegion endCol="8" startCol="1" endRow="318" startRow="6">
               <gmr:Style Format="#,##0.00#" PatternColor="0000:0000:0000" 
Back="0000:0000:0000" Fore="0:0:0" Hidden="0" Locked="0" Indent="0" Shade="1" 
Orient="1" WrapText="1" VAlign="1" HAlign="8">
                  <gmr:Font StrikeThrough="0" Underline="0" Italic="0" Bold="0" 
Unit="10">Arial</gmr:Font>
                  <gmr:StyleBorder>
                     <gmr:Top Color="3333:3333:3333" Style="1" />
                     <gmr:Bottom Color="3333:3333:3333" Style="1" />
                     <gmr:Left Color="3333:3333:3333" Style="1" />
                     <gmr:Right Color="3333:3333:3333" Style="1" />
                     <gmr:Diagonal Style="0" />
                     <gmr:Rev-Diagonal Style="0" />
                  </gmr:StyleBorder>
               </gmr:Style>
            </gmr:StyleRegion>

   ...


   The first StyleRegion, that begins and ends at column 0 works fine, but the 
second don´t.
   The second StyleRegion worked fine just when I decreased the endRow to 255. 
   Is this a limitation?

Thanks

Ricardo
Comment 1 Marc Portier 2006-05-31 11:33:28 UTC 
Being in a similar spot I traced this down to a hard-coded limit in the cocoon
classes.

If the range of cells in the styleregion exceeds 2000 then the styleregion
element is ignored. According to the comments in the code surrounding this hack
it seems to be introduced for getting round some gnumeric behaviour.

Anyway, it's not directly something the poi people are likely to solve I guess...
Comment 2 Yegor Kozlov 2008-05-17 04:06:13 UTC 
We fixed tons of bugs since POI 1.10.o-dev. Could you please try poi-3.1-beta1 and report if the problem still persists? 

Yegor
Comment 3 Nick Burch 2008-08-05 15:56:50 UTC 
Guessing this is now fixed. Please re-open the bug if it still occurs on re-testing with a recent version (eg 3.1)