OBIEE 11g - Timeformat '00:00:00' Is Lost When Exporting To Excel 2007 In OBIEE 220.127.116.11.141014
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.141014 to 22.214.171.124.141014 [Release 11g]
Information in this document applies to any platform.
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'
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