SAP Knowledge Base Article - Public

3492428 - Column headers misaligned when drilling-down on a Table and exporting it to MS Excel in SAP Analytics Cloud (SAC)

Symptom

  • Columns misaligned with the data in MS Excel.
  • Columns shift to the left, when exporting a Table to XLSX in SAP Analytics Cloud.
  • When drilling down on a Table and exporting it to MS Excel without formatting, column headers are misaligned in the generated MS Excel spreadsheet.

Environment

  • SAP Analytics Cloud 2024.8.16 

Reproducing the Issue

  1. In SAP Analytics Cloud, open a Story containing a Table.
  2. Drill-down on the Table.
  3. Export the Table to MS Excel (XLSX) using the following options:
  4. When opening the generated MS Excel spreadsheet, notice the columns are misaligned.

Cause

  • This issue is currently under investigation by development.

Resolution

  • This issue is currently under investigation by development.

  • Workaround:
    • For the columns to be correctly aligned with the data in the generated MS Excel spreadsheet,  check the option "Include Formatting" when exporting the Table to MS Excel.

Keywords

SAC, xls, xcel, , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0