SAP Knowledge Base Article - Public

3239980 - Extra Characters in Report Downloaded in CSV Format

Symptom

When you download a report in CSV format there are added characters for negative values.

Environment

  • SAP ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Go to Business Analytics.
  2. Go to Design reports and find your report.
  3. Open your report and run it.
  4. Download the report in CSV format.
  5. Open the report in excel.
  6. Notice there is an extra character in cells that have a negative value.

Example:

Instead of -20 you see '-20

Cause

The reason you are seeing the extra character for minus values in your excel reports is due to a potential csv injection/security issue.

Please see the below article that explains what a csv injection is --> https://owasp.org/www-community/attacks/CSV_Injection

Note this happens only for report characteristics, not key figures. Negative numerical values in characteristics should be a rare use case.

Resolution

You can manually remove the extra character from the excel report.

However if you work with reports where you frequently have negative values in characteristics, we can activate a backend switch for your system to change the escaping of quotes. This will remove the character.

If you would like to request this, please open an incident and refer to this KBA.

See Also

https://owasp.org/www-community/attacks/CSV_Injection

Keywords

extra character, inverted comma, CSV, download, report, excel, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

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