P6 BI Publisher Report Excel Output Does Not Auto Fit the Column Size According to the Data (Doc ID 2250465.1)

Last updated on JULY 20, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.4.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
-----------------------

EXPECTED BEHAVIOR
-----------------------
Report in Excel should have column widths that are proportional to the data in the column.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create the data Model with queries as per report requirement:
    1. Design the .rtf (rich text file) as per requirement.
    2. Create the report and upload the .rtf to that report.
    3. Use standard report Excel output properties in BI Publisher application.
    4. Successfully create the data model and report.
    5. Run the report from BI Publisher (BIP) with specific parameters.
    6. Open the report.
    7. Choose output format as Excel (xls).
    8. See the output has all columns the same width as the .rtf that was uploaded with non-expanded columns.
  2. Export to Excel
  3. Issue occurs, Excel report has same-width columns

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view the report data easily.

Changes

 

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