RE: color in excel spreadsheet not working with HSSFSerialiser

[Yan, Charlene]

Joy,

I have a question for you since you are using gnumeric.  Does your PrintInformation 
section?  I am trying to change Header, Footer and Orientation of the Excel.  Somehow 
it's not taking it at all.  See below:

<gmr:Geometry Width="734" Height="422"/>
    <gmr:Sheets>
      <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false"
HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
        <gmr:Name><xsl:value-of select="name"/></gmr:Name>
        <gmr:MaxCol>-1</gmr:MaxCol>
        <gmr:MaxRow>-1</gmr:MaxRow>
        <gmr:Zoom>1.000000</gmr:Zoom>
        <gmr:Names/>
        <gmr:PrintInformation>
          <gmr:Margins>
            <gmr:top Points="28.3" PrefUnit="cm"/>
            <gmr:bottom Points="28.3" PrefUnit="cm"/>
            <gmr:left Points="0" PrefUnit="cm"/>
            <gmr:right Points="0" PrefUnit="cm"/>
            <gmr:header Points="0" PrefUnit="cm"/>
            <gmr:footer Points="0" PrefUnit="cm"/>
          </gmr:Margins>
          <gmr:vcenter value="0"/>
          <gmr:hcenter value="0"/>
          <gmr:grid value="0"/>
          <gmr:even_if_only_styles value="0"/>
          <gmr:monochrome value="0"/>
          <gmr:draft value="0"/>
          <gmr:titles value="0"/>
          <gmr:repeat_top value=""/>
          <gmr:repeat_left value=""/>
          <gmr:order>r_then_d</gmr:order>
          <gmr:orientation>landscape</gmr:orientation>
          <gmr:Header Left="" Middle="Page &amp;[PAGE]"  Right=""/>
          <gmr:Footer Left="" Middle="Page &amp;[PAGE]" Right=""/>
          <gmr:paper>A4</gmr:paper>
        </gmr:PrintInformation>    

Thanks!!

Charlene

-----Original Message-----
From: Yan, Charlene 
Sent: Thursday, June 19, 2003 3:43 PM
To: '[EMAIL PROTECTED]'
Subject: RE: color in excel spreadsheet not working with HSSFSerialiser


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]