Showing posts with label keep leading zeros. Show all posts
Showing posts with label keep leading zeros. Show all posts

Friday, June 2, 2017

How to keep leading zeros in excel ; Export to Excel ADF

Add 2 outputtexts to the table column

  <af:column width="10%" sortProperty="#{bindings.ExampleVO11.hints.Attribute1.name}"
                                   filterable="true" sortable="true" headerText="InterCompany" id="c33">
                                         <af:outputText value='=" ' inlineStyle="display:none" id="ot14"/>
                            <af:outputFormatted value="#{row.bindings.Attribute1.inputValue}"
                                                shortDesc="#{bindings.ExampleVO11.hints.Attribute1.tooltip}"
                                                id="it32"/>
                            <af:outputText value='"' inlineStyle="display:none" id="ot15"/>
                        </af:column>

Reference : https://flexagon.com/2015/08/adf-export-excel-tweakingchanging-output-for-exported-excel-to-avoid-scientific-formats/