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