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]
