Summary

Decimal separator in Oracle BI Publisher 12.2.1.0.0

Content

Hi all,

I need to change the decimal separator character "dot" (.) with "comma" (,)

In Italy we use the comma as decimal separator.

All the query that return number fileds in Excel are shown as strings because in Italian version the "dot" isn't a decimal separator.

Performing a REPLACE in the SQL statement will result that Excel shows correctly the string but still in string format not in number, so sorting and filtering are not number but string option.

I think that a the decimal character separator must be changed globally in the Oracle BI Publisher 12.2.1.0.0 installation.

Anyone has the same or a similar request ?

Thank you

Mirko