Copy And Paste From P6 To Excel Populates Column With Invalid Values.

(Doc ID 2387433.1)

Last updated on MAY 01, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR:

When copying data from the P6 Client to Excel, if the first column in the Layout is blank / nulls, the values in Excel are populated with data from another column.

EXPECTED BEHAVIOR

The data in Excel should have the same values (in this case, blanks / nulls) after the copy as is displayed in P6.

STEPS

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

  1. Launch P6.
  2. Open a Project and go to the Activities screen.
  3. Add a User Defined Field (UDF) (or any Global column) that has not been populated yet as the first column.
  4. Select Edit from the menu / Select All.
  5. Select <ctrl> c to copy.
  6. Launch blank spreadsheet in Excel.
  7. Go to the first row / first column.
  8. Select <ctrl> v to paste.
  9. Observe the first column is populated with values from another column.
  10. Repeat the above with the blank column moved to the second position in the Layout.
  11. Observe the column in Excel is blank, as expected, after the copy.

 

 

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