SAP Knowledge Base Article - Preview

3644634 - SAP OData $format=xlsx : Excel pivot table function not working

Symptom

  • Pivot table grouping on date columns fails when using Excel export functionality from a custom UI5 application.
  • Excel does not automatically group date columns by year or quarter.
  • Excel is downloaded via OData call: $format=xlsx


Read more...

Environment

SAP Gateway (OData)

Keywords

excel export, pivot table, date column, grouping issue, UI5 application, ODATA `$format=xlsx`, empty cells, SAP Note 3640311, SAP Gateway, Lean Export, Excel functionality, custom UI5. , KBA , OPU-GW-COR , Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.