Look into list separators. Try replacing ; with , in the formula.
Kind regards, Miha Setina MiGA d.o.o. SI-1000 Ljubljana tel: 01/5819242 fax: 01/5819241
----- Original Message ----- From: "Mirko Freisleben" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, March 31, 2005 11:40 AM
Subject: Problems to generate Date format in Excel
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]
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 30.3.2005
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
