PDA

View Full Version : Number format, MESSAGE() and localization : setting issue or bug ?



fleurdepoireau
02-05-2013, 09:37 AM
Hi,
Localization of my environment/PENTAHO is France.

Number-field : [SeuilRef]
Attributes/format : #,###.0
Result is ok http://forums.pentaho.com/images/icons/icon14.png : 1 234 567,8 for example (french notation).

Message-field : [SeuilRef]
Attributes/value : $(SeuilRef, number, #,###.0)
Result is ok http://forums.pentaho.com/images/icons/icon14.png : 1 234 567,8 (french notation).

Text-field : [SeuilRef]
Attributes/value/formula : =MESSAGE("{0, number, #,###.0}"; [SeuilRef])
Resuld is bad http://forums.pentaho.com/images/icons/icon13.png: 1,234,567.8 (US notation).

The localization is bad. Setting issue or bug ?

Thanks in advance.

Taqua
02-05-2013, 05:44 PM
Bug. Seems that the locale is not passed down to the formula system correctly. Can you file me a JIRA case on http://jira.pentaho.com/browse/PRD ?

fleurdepoireau
02-06-2013, 04:18 AM
PRD-4273 (http://forums.pentaho.com/browse/PRD-4273) created

Thank's