MUX - Pasting into Grid from Excel Empties Row Below

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When you copy multiple lines in Excel and paste them into Clarity, the row below gets blanked out.

Steps to Reproduce: 

1. Start with an Excel Spreadsheet with text in a cell.
2. In Excel select a cell, press Ctrl-c (or right click and Copy the cell)
3. Log into the Clarity Modern UX. Access the Project Grid View.
4. Select a text field cell in the grid (Text 1 for example) and press Ctrl-v to paste into the cell

Expected Results: The text should only paste into the cell

Actual Results: The text will paste into the cell, but the cell below will also be blanked out

Note: Additional Steps to Reproduce

• The steps as stated under Steps to Reproduce have been used for the following scenario

• The same happens when copying/pasting numbers across Per-Period fields.

• If you paste the Excel content on a Notepad++ you will notice an additional return carriage and this is what blanks the value of the cell.
• If you get the content in Excel and select a single cell in Clarity, the values are spread over the cells at the same position as Excel and the next cell underneath is blanked out.
• If you erase the return carriage in Notepad++, and copy it once again without the return carriage, then there is no issue.
• If you copy X amount of values in Excel, you go to Clarity and select the same number of cells you want to paste the values on, then the value erase does not occur.

Environment

Clarity Release: 16.x, 16.1.x, 16.2.x 

Cause

DE61112, DE66472, DE153657

Resolution

DE153657 is targeted to be fixed in 16.3.1 (Targeted to be GA by February 2025) 

 

Additional Information

• Pasting multi-line cells from Excel inserts a carriage return and spaces