My Oracle Support Banner

Copy/Paste From Resource Usage Spreadsheet To Excel Copies Only First 14 Columns Of Data (Doc ID 2118280.1)

Last updated on APRIL 06, 2020

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Resource Usage Spread data copied from the Layout and pasted into Excel does not contain all of the data.

EXPECTED BEHAVIOR
-----------------------
All copied spread data is pasted into Excel.

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

  1. Modify the Layout to show View, Show on bottom, Resource Usage Spreadsheet.
  2. In the Resource Usage Spreadsheet (lower left section) Display, Filter by, Current Project's Roles.
  3. Modify the Timescale to Quarter/Month and check "Show All Projects" in the Resource Usage Spreadsheet (bottom right).
  4. Note the end date for the data.
  5. Highlight the 3 Roles shown.
  6. Copy.
  7. Paste into Excel.
  8. The spread data only pastes out a portion of the data, not the full Project data as seen in step 4.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get all of the data out to Excel from a copy/paste of data in the client.

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.