SAP Knowledge Base Article - Public

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


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


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


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



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.


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


SAP Analytics Cloud 1.0