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.

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

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.

Keywords

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

Product

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