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 13:20:52 GMT
once again...
Seems to be an Excel specific problem
If I´m opening the file under Linux with OO 1.1 or gnumeric the format is all 
right...



Am Donnerstag, 31. März 2005 14:27 schrieb Mirko Freisleben:
> 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

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


Mime
View raw message