Symptom
When exporting a table from a story to CSV or XLSX file in SAC, the table formatting (color) is lost in the CSV file.
Environment
SAP ANALYTICS CLOUD
Version: 2023.16.14
Reproducing the Issue
- Login to SAC.
- Open any story.
- Go to Files->Export.
- In the dialog box, choose File Types as pdf or .pptx.
- Choose which pages you'd like to export: All; or specify the Range, the specific pages.
- You can specify the following: Orientation: Landscape or Portrait, Paper size: Auto, A2, A3, A4, A5, Letter or Legal, Page number position: Header, Footer or None, Grid Page settings, etc.
- When you've finished making your selections, click OK.
- Select Export to create and download the file to your computer.
Cause
Behavior is by design.
Resolution
- Currently, formatting (such as cell color, font styles, etc.) will not be exported in CSV or XLSX file.
- You can submit an enhancement request using following KBA:
2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?
See Also
- Export Table Data as a CSV or XLSX File | SAP Help Portal
- https://blogs.sap.com/2021/11/18/best-practices-for-sap-analytics-cloud-csv-and-excel-export-performance/
- https://answers.sap.com/questions/13008340/exporting-table-component-in-sac-to-pdf.html
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
Formatting, export, csv, xlsx, SAC, table, chart , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0