Showing posts with label avoid scientific values when exported to excel. Show all posts
Showing posts with label avoid scientific values when exported to excel. 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/