Problem with ValueFormat using POI to generate XLS file.....

[Antonio Gallardo]

Hi:

Recently we are trying to format a float number to 4 fixed decimals. For
example a number 1.23456 will be formated to 1.2345

We are using in a XML doc:

<gmr:Cell Col="5" Row="{$row+4}" format="#,##0.0000">

  <xsl:attribute name="ValueType">40</xsl:attribute>
    <xsl:if test="@format">
     <xsl:attribute name="ValueFormat">
      <xsl:value-of select="@format"/>
     </xsl:attribute>
    </xsl:if>

    <gmr:Content>
      <xsl:value-of select="numbers/@raw"/>
    </gmr:Content>
</gmr:Cell>

 what is wrong?
 i get only the valuetype 40 without the special format....

Best Regards,

Antonio Gallardo