cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mirko Freisleben <mirko.freisle...@polizei.bayern.de>
Subject Re: Problems to generate Date format in Excel
Date Thu, 31 Mar 2005 12:27:58 GMT
Hi Miha,

thx for your reply, we tried it with the list spearators ',' but it didn´t 
work


Am Donnerstag, 31. März 2005 13:59 schrieb Miha Setina:
> 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

-- 
_________________________________________
Freisleben Mirko
BLKA SG 334 IGWEB-Crew
Tel. 089 / 1212 - 3490
CNP   7  - 207  - 3490
<mailto:mirko.freisleben@polizei.bayern.de>
mailto:mirko.freisleben@polizei.bayern.de
_________________________________________

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message