My Oracle Support Banner

The Format Is Incorrect When Exporting Portfolios To Excel, Negative Numbers Exported As Text And Not Considered (Doc ID 2949716.1)

Last updated on MAY 22, 2023

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

When the user exports Portfolio data in Excel format, negative numbers are formatted as text and not considered.

EXPECTED BEHAVIOR

All data should be exported in numerical format.

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

  1. Navigate to the impacted Project/Shell and select the Portfolio
  2. Using the printer icon, select the 'Export to Excel' option
  3. Notice the format of the Excel sheet is incorrect and the data is not showing correct where there is a negative number

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.