SAP Knowledge Base Article - Public

2734420 - Excel File Showing Empty Line Even when Report Has no Empty Line on System

Symptom

You are downloading a report to CSV and when oppening it on Excel you have noticed some few lines are empty.

Environment

  • Excel Add-in on Business ByDesign
  • Excel Add-in on Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics work center and open any report.
  2. After running this report, select the option Download CSV File.
  3. Open the CSV file and check the lines, some are empty.

Cause

This issue happens due the " symbol which is present in the data. Remember that these symbols are used in coding and also to create data sources. However, we considered this behavior a temporary limitation that development already addressed to be corrected in future releases.

Resolution

Alternatively you can use ' symbol or twice the ' symbol for double quotation. It would avoid the error of empty lines.

Keywords

Excel empty lines, excell missing lines, , KBA , AP-RC-ANA-UI-XLS , C4C, ByD, Travel: Excel AddIn , Problem

Product

SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Cloud for Customer add-ins 1811 ; SAP Cloud for Customer add-ins 1902 ; SAP Cloud for Customer add-ins 1905