OBIEE 12c: How To Export To Excel Data Values Prior to 1/1/1900 Without Displaying ###### In The Spreadsheet

(Doc ID 2309605.1)

Last updated on FEBRUARY 15, 2018

Applies to:

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

Goal

In OBIEE 12c, when exporting date type data to Excel 2007, the export process completes successfully without any errors but any date values prior to 1/1/1900 are showing as ######## in the spreadsheet and as a negative number in the formula bar. The following message is displayed when you hover over the cell in the spreadsheet:

Dates and times that are negative or too large show as ####### in the cell. Ex: 1/1/1800 exports to ######### in the spreadsheet and -36523 in the formula bar.

In OBIEE 11g, the values export to excel 2003 / 2007 without any issues.

Solution

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