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
- select and copy one cell from Excel
- paste the cell into SAC table grid
- 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