SAP Knowledge Base Article - Public

3023683 - Copy and Paste from an Excel sheet into any value help selection in a Report

Symptom

You are copying multiple values from an excel sheet and pasting them into any value help selection in a report. All the values do not paste completely, only one value displays.

Or you copy and paste multiple values from any source, into any value help selection in a report, the report does not recognise the values and does not update the report.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Open an Excel sheet where there are multiple values
  2. Copy(Ctrl C) the multiple values all at once, 57692;52535;56783 etc
  3. Go to Business Analytics Work Center
  4. Go to Design Reports view
  5. Search for any report and open
  6. Paste them into any value help selection in the report
  7. All the values do not paste completely/ or the values are not recognised

Cause

The "Show Description" feature is switched on in the selection pane (icon on top of selection pane).

Resolution

You need to switch off the "Show Description" feature and then paste the values and run.

Keywords

Copy, Paste, Show Description, Multiple Values, Paste into Value Help, Copy from Excel, Excel Sheet, Value Help, Selection, Excel, Copy from any Source , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions