I tried to use the built-in-function TEXT(number, pattern) to format a given number with the given format pattern:
e.g. TEXT(new BigDecimal("1234.56"), "#,###.##")
We also have our own FormatFactory in our reports, that format the thousand separator as space instead of a comma (e.g. "1 234.56" instead of "1,234.56")
When I use the built-in-function, the FormatFactory we specified is not used!
The result is : "1,234.56"
I would expect the built-in-function to call something like:
(number ==null)? null : $P{REPORT_FORMAT_FACTORY}.createNumberFormat("#,###.##", $P{REPORT_LOCALE}).format()
Recommended Comments
There are no comments to display.