Is there any restriction on the total of cells in a styleregion?
| Joerg Heinicke <[EMAIL PROTECTED]>
2004-05-27 05:14
|
To: [EMAIL PROTECTED] cc: Subject: Re: Please give me a hand |
On 26.05.2004 12:12, [EMAIL PROTECTED] wrote:
> In my sample output, It can show variable styles within one sheet,
> Please see attached xml & output Excel file.
>
> But I found the styles can't be effective if I set the region's endRow >
> = "10".
>
> ? <gmr:Styles>
> ? <gmr:StyleRegion startCol="0" startRow="0" ?endCol="255" endRow="2">
> ----> endRow="15" is not OK
> ? <gmr:Style HAlign="1" VAlign="2" WrapText="1" Orient="1"
> ? ? ? ? ? ? ?Shade="1" Indent="0" ?Locked="0" Hidden="0"
> ? ? ? ? ? ? ?Fore="F800:9800:0" Back="3000:6400:F800"
> ? ? ? ? ? ? ?PatternColor="F800:CC00:9800"
> ? ? ? ? ? ? ?Format="General">
>
>
> I had try to set the MaxRow as 1000,65535,65536
> <gmr:MaxRow>1000</gmr:MaxRow>
> But it is no use.
>
> An other problem, the back & fore colors seems unrecognized even I set
> shade="1".
>
> Do you have any idea about it? (I'm using Cocoon 2.1.2 to transfer XML to
> Excel.)
> Is any other factors effecting the max endrow in styleregions?
It was a year ago when I played around with poi heavily as I needed it
in project. In the meantime I probably forgot the half, but the above
does not look bad. Have you played with the samples in the poi block
[1]? At least the date sample goes beyond 10 rows.
Joerg
[1]
http://cvs.apache.org/viewcvs.cgi/cocoon-2.1/src/blocks/poi/samples/content/
or http://localhost:8888/samples/blocks/poi/ in your local installation
when running with default Jetty.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
