SAP Knowledge Base Article - Public

3039800 - Pasting cell from Excel Cell generates a blank cell in the next row in SAC

Symptom

Pasting values from Excel to SAC will insert a blank cell or overwrite the cell in the next row

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. select and copy one cell from Excel
  2. paste the cell into SAC table grid
  3. user notices that the cell in the new row is overwritten in SAC or a blank cell is highlighted

Cause

a known Excel behavior: Windows version of Excel a new line break is added when copying a single cell.

Resolution

Workaround:

Instead of copying a cell from Excel, user can double click on the cell (to enter the edit mode) in Excel and then select the content and press CTRL + C.
If you paste it into SAC modeling grid, it will work without overwriting the cell in the next line.

Keywords

excel new line break copy paste , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , Problem

Product

SAP Analytics Cloud 1.0