cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Merenidis, Grigorios" <Grigorios.Mereni...@Dresdner-Bank.com>
Subject Cell Formating in Excel with Cocoon
Date Thu, 03 Apr 2003 06:53:12 GMT
Hi!
I' m developing with Cocoon and I try to build a excel spredsheet with the
gnumeric format. but
it doesn't work.

I set the format of the style for the specific cell:



<gmr:Styles>
<gmr:StyleRegion startCol="0" startRow="0" endCol="0" endRow="0">

<gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFF:FFF:FFF"
PatternColor="9999:9999:FFFF" Format="#,##0.00000">    <!-- that's my
desired value-->

            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0"
StrikeThrough="0">Arial</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="0" />
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0" />
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
</gmr:Styles>

I now that I have to format the ValueType of the cell content:


 <gmr:Cell Col="0" Row="0" ValueType="40" >   <!-- 40 = for numeric values
-->
   <gmr:Content>
        <xsl:value-of select="xy"/>
   </gmr:Content>
  </gmr:Cell>

But the format in the excel spredsheet is not the same as the format I
defined.

If I delete the Attribute ValueType="40"   I receive my main aim but without
any content.

Do someone know how I get the style format and the content into the cell of
the excel spredsheet?

Thank you in advance


gregori

---------------------------------------------------------------------
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