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" <[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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
