Copy Paste Sheet to Excel and Decimal Separator
Posted: 24 Mar 2021, 12:32
I'm trying to use pe:sheet and testing functionalities, but when I copy/paste numeric cells to excel it results that decimal separatore is "." (dot) instead of "," (comma)
And of course I need comma as separator as I'm in Italy...
it shows correctly (eg. 123.456,78) in cells content but not when copying/pasting to excel
The same appens in https://www.primefaces.org/showcase-ext ... cUsage.jsf
I tryed also to set locale "de-DE" in pe:sheet and also "de-DE" in pe:column like this:
Any suggestion?
Using JSF 2.2, Primefaces 6.2.17, Primefaces Extensions 6.2.10
And of course I need comma as separator as I'm in Italy...
it shows correctly (eg. 123.456,78) in cells content but not when copying/pasting to excel
The same appens in https://www.primefaces.org/showcase-ext ... cUsage.jsf
I tryed also to set locale "de-DE" in pe:sheet and also "de-DE" in pe:column like this:
Code: Select all
<pe:sheet id="sheet" widgetVar="sheetWidget" value="#{configuratorePostformatoHome.instance.righeMisureRichieste}" var="row"
height="625" rowKey="#{row.riga}" fixedCols="2" showRowHeaders="true"
resizableCols="true" resizableRows="true" filteredValue="#{configuratorePostformatoHome.righeMisureFiltered}"
sortBy="#{row.riga}" sortOrder="ascending" readOnly="false"
locale="de-DE" >
......
<pe:sheetcolumn headerText="Prof" value="#{row.aNumber}" colWidth="50"
styleClass="htRight"
colType="numeric"
numericLocale="de-DE"
numericPattern="#,##0.0"
required="true"
requiredMessage="Missing Number!">
<f:converter converterId="javax.faces.BigDecimal"/>
</pe:sheetcolumn>
</pe:sheet>
Using JSF 2.2, Primefaces 6.2.17, Primefaces Extensions 6.2.10