search cancel

Copy and paste in New UI with multiple paragraphs in a string field pastes over multiple rows

book

Article ID: 215623

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When copying and pasting in a Modern User Experience (UX) Common Grid, the first row's string field's first paragraph is pasted into the first row's string field. The subsequent blank lines and paragraphs are attempted to be pasted in the first column's fields down multiple rows.

This can generate the following error: “You can only copy and paste lookup values for the same column” as the system is trying to paste blank lines and characters into lookup fields. If the first column is a string field (Example: Report Name) – these can get overwritten by blank rows and data from the pasted string field.

Steps to Reproduce:

  1. In a Common Grid (example is Status Reports object module), add multiple editable lookup fields and at least one field that is a String with 1,000 - 2,000 character length.
  2. Create or have multiple rows showing with data in the fields, at least 9 rows. In the String field, populate with multiple paragraphs with blank lines between them, entered by double clicking and entering the data to avoid the problem during setup.

You can edit multiple records on the Grid layout. 

When you select multiple records and click the Edit button, a bulk edit window will be displayed. 

The window includes all the fields that were displayed in the grid. 

You can update the relevant fields and click Save to commit your changes. 

In case, certain fields cannot be updated due to internal business rules, those changes would be ignored.

      3. Create a new row.

      4. Copy the previous row's fields below the new row, including the String field, by selecting them and pressing CTRL-C.

      5. Paste into the new row's fields by selecting them and pressing CTRL-V.

Expected Results: All lookup values and the string field are updated, with all paragraphs and blank lines are pasted into a single String field in the current row.

Actual Results:  The first row's lookup values are pasted into the first rows lookup values and the string field's first paragraph pasted into the first row's string field. The subsequent blank lines and paragraphs are attempted to be pasted in the first column's fields down multiple rows. If the first column is a string field, the values get overwritten with the first row’s string data.

Cause

This is caused by: DE61031

Environment

Release : 15.9.2

Resolution

This issue is fixed in 15.9.3 and 15.9.2 patch 1 as DE61031

Workaround: Manually copy and paste each string field individually, making sure to double click into the field being pasted into so the entire string gets pasted into that cell. The one other option would be to remove the string fields from the grid column when copying and pasting.

Additional Information

One known limitation where you would still see the issue after upgrading to a version where the issue is fixed is if using quotes (") around the entire text being copied. Make sure to delete any outside quotes prior to copying and pasting. You can use single quotes (') instead in that scenario.

Example highlighted in yellow where quotes would cause the issue:

"You can edit multiple records on the Grid layout. 

When you select multiple records and click the Edit button, a bulk edit window will be displayed. 

The window includes all the fields that were displayed in the grid. 

You can update the relevant fields and click Save to commit your changes. 

In case, certain fields cannot be updated due to internal business rules, those changes would be ignored."