SAP Knowledge Base Article - Public

3385568 - COD2308 Excel Export of Customer List does not have same sort order

Symptom

When you download a list to MS Excel, the sort order from the UI will not be the same in the downloaded Excel File

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Open WOC Customer
  2. Go To Accounts
  3. Sort the list by any Column
  4. Select More "Export to Microsoft Excel"
  5. Open the Excel

    --> The data shown in the Excel is not sorted by the column which you have selected in the UI for sorting

Resolution

The sort sequence applied in the UI is not persisted in the exported spreadsheet. In excel export, data appears in the Excel in the same order in which the data is returned from the backend. 

See Also

This is currently the expected system behavior in every downloaded list from the UI. 

Keywords

Export to Excel, Download, Sorting, Column , KBA , AP-RC-UIF-RT , UI Framework Runtime , Problem

Product

SAP Cloud for Customer core applications 2308