On 31.03.2005 11:40, Mirko Freisleben wrote:
Hi all,
I´m trying to generate an Excel-Sheet from an xml-File
here is what I´m doing
<xsl:when test="position()=40">
<gmr:Cell ValueType="-1">
<xsl:attribute name="Row">
<xsl:number value="$rownumber"/>
</xsl:attribute>
<xsl:attribute name="Col">
<xsl:number value="$aktcol"/>
</xsl:attribute><gmr:Content>=DATE(2003;11;20)</gmr:Content>
the ValueType -1 is for CELL-TYPE FORMULA
(http://issues.apache.org/bugzilla/show_bug.cgi?id=22574)
In Excel it is displayed as String 37495. When I´m activating the Cell I see
the function and can execute it. Then I get the right result (20.11.2003)
Is it possible to show the date immediately after opening the sheet without
any user actions?
Have you tried the simple-date-test in the POI samples delivered with
Cocoon?
$COCOON_HOME/src/blocks/poi/samples/content/simple-date-test.xml
Joerg
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
