2 Replies Latest reply on Apr 19, 2010 3:45 PM by Michel Thai

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

    Michel Thai Newbie

      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.

        • 1. Re: xls-force-type null values then java.lang.Float
          Michel Thai Newbie

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

          • 2. Re: xls-force-type null values then java.lang.Float
            Michel Thai Newbie

            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>