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?
running:
XP Prof.
Office XP (Excel)
tomcat 5.0.3 (under XP)
j2sdk 1.4.2
cocoon 2.1.6
thx
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
