You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Mirko Freisleben <mi...@polizei.bayern.de> on 2005/03/31 11:40:49 UTC
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
Re: Problems to generate Date format in Excel
Posted by Mirko Freisleben <mi...@polizei.bayern.de>.
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" <mi...@polizei.bayern.de>
> > To: <us...@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
Re: Problems to generate Date format in Excel
Posted by Mirko Freisleben <mi...@polizei.bayern.de>.
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" <mi...@polizei.bayern.de>
> To: <us...@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
<ma...@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
Re: Problems to generate Date format in Excel
Posted by Miha Setina <mi...@miga.si>.
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" <mi...@polizei.bayern.de>
To: <us...@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
Re: Problems to generate Date format in Excel
Posted by Joerg Heinicke <jo...@gmx.de>.
On 31.03.2005 11:40, Mirko Freisleben wrote:
> 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?
Have you tried the simple-date-test in the POI samples delivered with
Cocoon?
$COCOON_HOME/src/blocks/poi/samples/content/simple-date-test.xml
Joerg
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org