xls-force-type null values then java.lang.Float

[mthai]

Hi,

I would like to export a dataTable which contain null values then java.lang.Float values. whith xls-force-type number my Excel export does not contains numbers but numbers stored as text.

How can i forced the Float values stored as numbers even if the excel export contains null values?

Michel.

[mthai]

I would like to add a comment:
I have this bug when my column in excel export contains null values at the beginning.

[mthai]

Hi,

I would like to inform that i fixed this problem, i have update seam to 2.2.0.GA and move my style position.

Before:

<rich:dataTable id="idTable" value="#{myBean}" var="item">
    <rich:column style="xls-force-type:number;">
           <f:facet name="header">
                <h:outputText styleClass="headerText" value="Price" />
           </f:facet>
           <h:outputText value="#{item.price}" />
    </rich:column>
</rich:dataTable> 

Now:

<rich:dataTable id="idTable" value="#{myBean}" var="item">
    <rich:column>
           <f:facet name="header">
                <h:outputText styleClass="headerText" value="Price" />
           </f:facet>
           <h:outputText style="xls-force-type:number;" value="#{item.price}" />
    </rich:column>
</rich:dataTable>