Hi, See : http://www.jfree.org/jworkbook/gnumeric-xml.pdf
Cheers, Carlos Ch�vez. [EMAIL PROTECTED] Escribio :-) > Is there any restriction on the total of cells in a styleregion? > > > > > > Joerg Heinicke <[EMAIL PROTECTED]> > 2004-05-27 05:14 > Please respond to users > > > 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] > > > > -- Carlos Ch�vez --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
