OBIEE 12c: When Exporting To Excel, Number Columns Change To Text Format In The Export

(Doc ID 2346279.1)

Last updated on APRIL 16, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When exporting to Microsoft Excel, the number format of the column changed to text format in the resulting exported spreadsheet.

Changes

Upgraded fromĀ OBIEE 11.1.1.9 to OBIEE 12.2.1.3. while exporting the reports to excel in the 12c instance, the numbers get formatted as text in the excel sheet.

Cause

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