You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Joydeep Bose <jo...@dotech.com> on 2003/06/19 17:12:46 UTC

color in excel spreadsheet not working with HSSFSerialiser

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: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org

Re: color in excel spreadsheet not working with HSSFSerialiser

Posted by David Kavanagh <da...@dotech.com>.
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: cocoon-users-unsubscribe@xml.apache.org
>For additional commands, e-mail: cocoon-users-help@xml.apache.org
>  
>



---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org