SAP Knowledge Base Article - Public

3170343 - Pivot excel export cell format is text

Symptom

When exporting a pivot table to excel, the cell format is always text.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Create a Pivot table in Canvas report
  2. Export in Excel
  3. Fields are in text format

Cause

This is working as designed.

Resolution

It is expected that the cell format in the exported excel file from a pivot table is text. So, e.g., if you export a pivot table where you used a date field, it will in text format by default:

Keywords

Pivot, export, text, format, date field, field, cell, cell format, excel, xls, xlsx, canvas , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM suite all versions