Discoverer Export to CSV Opened in Excel, Numbers are Split Into Two Columns When Logged on with a Locale that Uses the Comma as a Decimal Separator
Last updated on SEPTEMBER 27, 2016
Applies to:Oracle Discoverer - Version 10.1.2.1 to 22.214.171.124.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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms