You have downloaded a report to Excel (xlsx) however the fields come in a wrong format. They are text fields in Excel, even though in the report, it is for example a Calendar Month.
- SAP Business ByDesign
- SAP Cloud for Customer
Reproducing the Issue
- Go to the work center Business Analytics.
- Select the Design Reports view.
- Run your report.
- Download it as a xlsx file.
- Mark a field and see that it has a General or Text formatting.
The field has a type for which no formatting can be downloaded.
Since 1911, the formatting will be kept correctly for certain field types: Date, Amount and Quantity fields.
Please note about date fields that only pure dates will retain their formatting. Fields like Calendar Month, Calendar Week etc are not formatted in a xlsx download.
If you download a report in the XML format date fields will show the format as General. This is the expected system behaviour at the moment. If you want to change this behaviour this would be a new requirement. Please post this request on our SAP Cloud for Customer Continuous Influence forum or SAP Business by Design Continuous Influence forum.
Further details are also available in the Knowledge Base Article 2584678 - Excel Sum Function Does Not Work on Reports Downloaded in xlsx Format.
excel, report, analytics, download, xlsx, format, formatting, text, custom, 1911 , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement