cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yan, Charlene" <Charlene....@thomsonlearning.com>
Subject RE: color in excel spreadsheet not working with HSSFSerialiser
Date Thu, 19 Jun 2003 21:14:12 GMT
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: 'cocoon-users@xml.apache.org'
Subject: RE: color in excel spreadsheet not working with HSSFSerialiser


Joy,

try shade=2.  It should work.

-----Original Message-----
From: David Kavanagh [mailto:dak@dotech.com]
Sent: Thursday, June 19, 2003 11:24 AM
To: cocoon-users@xml.apache.org
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: 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

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


Mime
View raw message