Re: Problems to generate Date format in Excel

[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