Masking numbers in PrimeFaces datatable

Question

Related to the question Display formatted decimal numbers in Primefaces 4, how can I display - in a PrimeFaces datatable - a number masked like this:

1.987.654,32

The original data, which are read from a float column in SQLServer database table, is (e.g.):

1987654.32

I've tried the code below, but no success:

<p:column sortBy="#{item.value}" filterBy="#{item.value}">
  <f:facet name="header">
    <h:outputText value="#{epoBundle.ListUpbTitle_value}"/>
  </f:facet>
    <h:outputText value="#{item.value}">
      <f:convertNumber pattern="#0.000" locale="pt_BR"/>
    </h:outputText>
</p:column>

Thanks in advance.

score 1 · Accepted Answer · edited May 23 '17 at 10:32

1

The correct pattern for the <f:convertNumber .../> you want is: ###,###.000. You can read more about decimal formatting here: http://docs.oracle.com/javase/tutorial/i18n/format/decimalFormat.html

Bonus: for different masks, you can use other locales: https://stackoverflow.com/a/11836387/1362049

edited May 23 '17 at 10:32

Community

1
1

answered Nov 04 '13 at 13:39

Simon Arsenault

1,777
17
35

Simon, the mask you provided is wrong related to the one I asked for. But no problem, I figured out: it should be: '###.###,00'. Anyway, thanks for your help! – jMarcel Nov 05 '13 at 15:23
Just remember that `.` and `,` are placeholders. – Simon Arsenault Nov 05 '13 at 17:20

Masking numbers in PrimeFaces datatable

1 Answers1