Last updated on SEPTEMBER 27, 2016
Applies to:Oracle Discoverer - Version 10.1.2.1 to 184.108.40.206.0 [Release 10.1.2 to 11g]
Information in this document applies to any platform.
The issue is seen when using a non English Locale (language) that displays the decimal separator as a comma (,) instead of a period (.) in a Discoverer worksheet.
For example : French (France), Italian (Italy), German (Germany).
When the worksheet is exported to CSV format and opened using Microsoft Excel the decimal separator is taken to be a CSV separator splitting the number into two columns in Excel.
Locale (language) settings that do not alter the decimal separator, such as English or French (Canada) or Italian (Swiss), display and export number as desired.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms