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" <[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] -- _________________________________________ Freisleben Mirko BLKA SG 334 IGWEB-Crew Tel. 089 / 1212 - 3490 CNP � 7 �- 207 �- 3490 <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED] _________________________________________ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
