2158316 - Why data in the generated CSV report are not separated by columns in Microsoft 2013 Office?

SAP Knowledge Base Article - Public

2158316 - Why data in the generated CSV report are not separated by columns in Microsoft 2013 Office?

Symptom

Employees are getting unreadable reports that are generated by the LMS if they upgrade their Microsof Office Version from 2010 to 2013.

The data is not not separated by the columns.

 masked-lms%20report%20in%202013.png

Environment

PCs which have Microsoft 2013 installed and use 2013 Microsoft Office  Excel.

Especially for European Users who have decimal separator as comma.

Reproducing the Issue

In LMS system, run any report in CSV format and open the report right after it's generated.

Cause

This seems an issue with the new version Excel in Microsoft Office  2013 especially for European users.

Resolution

 We could have 2 workaround:

1. The decimal separator in win 7 for european countries is coma . You have to open Control Panel -> Regional and Language Options -> Aditional Settings -> Decimal Separator : click to enter a dot (.) and to List Separator enter a coma (,).

 

2. If the do not double click and open the csv files in excel, they could

 

  1. Open Blank Workbook.
  1. Go to DATA tab.
  1. Click button From Text in the General External Data section.
  1. Select your CSV file.
  1. Follow the Text Import Wizard. (in step 2, select the delimiter of your text)

 

Either solution should resolve the issue.  You could find more details at http://stackoverflow.com/questions/17953679/how-to-correctly-display-csv-files-within-excel-2013

If the workarounds not acceptable by the customers, we might need to reach Product Engineering Team to see whether a permanent solution possible.

See Also

2352120 - Issue with formatting of Excel report

Keywords

LMS report, Excel, format, formatting, CSV viewer , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning all versions