My Oracle Support Banner

Reports Download As Excel Are Not Showing In Propoer Format (Doc ID 2871653.1)

Last updated on NOVEMBER 01, 2023

Applies to:

Primavera Analytics Cloud Service - Version 21.10 and later
Information in this document applies to any platform.

Symptoms

When attempting to export a report from Business Intelligence Publisher (BIP) in Excel, the following error occurs:

ERROR
-----------------------
We found a problem with some content in 'X.xlsx'. Do you want us to recover as much as we can? IF you trust the source of this workbook, click Yes.


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

  1.  Go to the BIP
  2.  Go to catalog
  3.  Shared Folders
  4.  UniferReports
  5.  Select the report
  6.  Click on the gear
  7.  Export XLS
  8.  Open
  9.  OK
  10.  The following error is displayed:
  11.  We found a problem with some content in 'X.xlsx'. Do you want us to recover as much as we can? IF you trust the source of this workbook, click Yes.
  12.  Yes
  13.  The report will open and it will be displayed the following:
  14.  Excel was able to open the file by repairing or removing the unreadable content.
  15. Removed Part:/xl/styles.xml part. (Styles)
  16. Repaired Records: Cell information from /xl/worksheets/sheet1.xml part



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.