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.
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.
This seems an issue with the new version Excel in Microsoft Office 2013 especially for European users.
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
- Open Blank Workbook.
- Go to DATA tab.
- Click button From Text in the General External Data section.
- Select your CSV file.
- 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.
2352120 - Issue with formatting of Excel report
LMS report, Excel, format, formatting, CSV viewer , KBA , LOD-SF-LMS-REP , Reporting Data , Problem