My Oracle Support Banner

OBIEE 11g - Timeformat '00:00:00' Is Lost When Exporting To Excel 2007 In OBIEE 11.1.1.4.141014 (Doc ID 1965236.1)

Last updated on AUGUST 09, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.141014 to 11.1.1.7.141014 [Release 11g]
Information in this document applies to any platform.

Symptoms

When a BI Report displaying numbers in the custom format of '00:00:00' is exported to Excel 2007+, the formatting is lost in the Excel file and only shows as a Number

e.g. '00:01:15' displays in a BI Report, but in Excel 2007 it shows as '75'

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.