2599530 - Report Excel Formatting

SAP Knowledge Base Article - Public

2599530 - Report Excel Formatting

Symptom

A cell within a CSV report splits into more lines due to a carriage return, line break CR or LF character.

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions.

Reproducing the Issue

  1. Login as an admin.
  2. Navigate to Reports.
  3. Download a report in CSV format.
  4. Open with Excel.
  5. Note that a cell contains multiple lines due to special character.

Cause

  • This issue is caused by Excel foramtting.
  • LMS application is unable to alter this.

Resolution

As a workaround:

  1. In the filter section of the report interface, choose semicolon as the delimiter.

Alternative:

  1. Download the report with the special character.
  2. Manually remove the special characters from the report in Excel.
  3. Use the command =CLEAN(A1).
  4. This will remove the extra lines.

Alternative:

  1. Change LMS application to English - there are no carriage returns.
  2. Download the report.
  3. Revert the LMS application language to the user's preference.

Alternative:

  • Download the report in HTML format.

Keywords

Excel, Report, LMS, Formatting, Carriage Return, CSV, language, LF, Line BReak , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-DB , DB Data & Services , How To

Product

SAP SuccessFactors Learning all versions