cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Miha Setina <miha.set...@miga.si>
Subject Re: Problems to generate Date format in Excel
Date Thu, 31 Mar 2005 11:59:08 GMT
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" <mirko.freisleben@polizei.bayern.de>
To: <users@cocoon.apache.org>
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org




-- 
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message