3549383 - Data misaligned with the column headers, when exporting data from a Pie Chart to CSV, from SAP Analytics Cloud (SAC)

• When exporting data from a Pie Chart to CSV from a Story in SAP Analytics Cloud, the data row starts 1 cell left from the corresponding column header.
• When exporting a Pie Chart data to CSV, the data and columns are misaligned in the generated CSV file.
• Issue occurs with all the delimiters, except: comma.

• SAP Analytics Clouds 2024.21.7

1. In SAP Analytics Cloud, create a Story.
2. Insert a Pie Chart.
3. Export the Pie chart to CSV format, and select any delimiters, except Comma delimiter.
4. When opening the generated CSV file in MS Excel, the data, and column headers are misaligned.

The generated CSV file does have the right delimiters information to display the data, but the headers and data re not aligned in MS Excel, because the CSV text file needs to be converted to Excel format.

In MS Excel, to convert a CSV text file to MS Excel format, select the option "Text to column", and select the same delimiter used when exporting the Pie Chart to CSV format:

1. In SAP Analytics Cloud, open your Story.
2. Select a Pie Chart, and export it to CSV format with the desired delimiter, like: semicolumn ;
3. In MS Excel, open the generated CSV text file.
4. Select column "A"  ( It will highlight the whole column )
5. In MS Excel, under the menu "Data", select: "Text to columns"
6. In Convert Text to Columns Wizard, ensure the option "Delimited" is select, and click "Next"
7. In the next screen, select the Delimiters you used to export the Chart, for example: "Semicolumn", and click "Finish"   
   ( Also, ensure you unselect the default Delimiter: Tab )
8. Back to MS Excel spreadsheet, the data, and the headers will now be aligned.

SAC, graph, export, xport, CSV , KBA , LOD-ANA-UNS-EXP , Unified Story PDF/PPT/Excel/CSV Export , Problem