OBIEE 12c : Report Alignment Is Missing From Excel Sheet When Report Is Exported To Excel - Extra Columns, Extra Blank Spaces, Large Size in Cells are seen

(Doc ID 2317524.1)

Last updated on DECEMBER 04, 2017

Applies to:

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

Goal

Dashboard has few reports and one of the reports has right alignment done as shown in the image A.

When open the Dashboard , Dashboard shows right alignment of the right aligned report very well which has left padding value set ( e.g 1050)  as showns in Image B.  But when exporting dashboard page to excel and opening that excel file, it shows the right alignment missing for that particular report as shown in Image C.

 

 

Dashboard output and excel file output are shown in Image B and C

 

Excel used was excel 2010.

 

Image A:-

 

 

Image B:-

 

 

Image C:-

 

 

 

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