Copy/Paste UX lookup values to Excel gives odd characters

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce:

1. Create some rows in a Roadmap Grid
2. Have the default columns which includes the IN PLAN and some Lookup fields
3. Highlight rows and columns --- > Control-C to copy
4. Go to a blank Excel Worksheet --- > Control -V to paste

Expected Result: To see values as they are displayed in the Clarity Roadmap Grid
Actual Result: odd characters for the lookup and In Plan fields

Strings copied to Excel look like:

%7B%22colId%22%3A%22blueprintId%22%2C%22value%22%3A%7B%22displayValue%22%3A%22Standard%20Project%22%2C%22_type%22%3A%22lookup%22%2C%22id%22%3A%221%22%7D%7D

Environment

Any Clarity release

Cause

This was analyzed by Engineering as DE47633

Resolution

A User Story has been raised to implement this feature in a future release:

S171490: Copy-n-paste just the lookup labels from a grid in order to paste to a spreadsheet