SAP Knowledge Base Article - Public

2864058 - Wrong Format in Excel Report Field After XLSX Download

Symptom

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.

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Go to the work center Business Analytics.
  2. Select the Design Reports view.
  3. Run your report.
  4. Download it as a xlsx file.
  5. Mark a field and see that it has a General or Text formatting.

Cause

The field has a type for which no formatting can be downloaded.

Resolution

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.

See Also

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.

Keywords

excel, report, analytics, download, xlsx, format, formatting, text, custom, 1911 , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP Business ByDesign 1911 ; SAP Business ByDesign 2002 ; SAP Business ByDesign 2005 ; SAP Business ByDesign 2008 ; SAP Business ByDesign 2011 ; SAP Business ByDesign 2102 ; SAP Cloud for Customer add-ins 1911 ; SAP Cloud for Customer add-ins 2020 ; SAP Cloud for Customer core applications 1911 ; SAP Cloud for Customer core applications 2002 ; SAP Cloud for Customer core applications 2005 ; SAP Cloud for Customer core applications 2008 ; SAP Cloud for Customer core applications 2011 ; SAP Cloud for Customer core applications 2102