MUX - Pasting into Grid from Excel Empties Row Below
search cancel

MUX - Pasting into Grid from Excel Empties Row Below

book

Article ID: 215955

calendar_today

Updated On:

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

Environment

Release : Any Clarity release

Component : CA PPM APPLICATION

Cause

DE66472

Resolution

This is a limitation of the External Vendor Software for the generic grid component. 

Additional Information

Some threads on the same:

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

When you copy-paste multiple lines from Excel to Notepad++ you will notice that an additional line is added with the carriage return. This causing the following line to blank out.