Joy, try shade=2. It should work.
-----Original Message----- From: David Kavanagh [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:24 AM To: [EMAIL PROTECTED] Subject: Re: color in excel spreadsheet not working with HSSFSerialiser Joy, Have you tried looking at the HSSFSerializer code? See how they handle the shade and color attributes you are trying to set. If they are passed to the POI code, perhaps it is a POI problem. I sometimes find the source code a little faster than the user-list. David Joydeep Bose wrote: >Hi, > >I am using this style info in gnumeric format : >I know that the colors don't work with shade=0 , so I made shade=1. >Is there some problem with the color format ? >Did anyone see this before ? > > ><gmr:StyleRegion startCol="1" startRow="7" endCol="10" endRow="7"> > <gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="1" > Indent="0" Fore="0:0:0" Back="00:FF:FF" PatternColor="0000:0000:0000" >Format="General"> > <gmr:Font Unit="8" Bold="1" Italic="0" Underline="0" >StrikeThrough="0"></gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="1"/> > <gmr:Bottom Style="1"/> > <gmr:Left Style="1"/> > <gmr:Right Style="1"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > > </gmr:Style> > </gmr:StyleRegion> > > > >Thanks >Joydeep > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
