2594182 - SAP Hybris Cloud for Customer Excel Add-in Distorting Results After Refresh

You are working with SAP Hybris Cloud for Customer Excel Add-in, and when you apply some filters and then refresh the report you note wrong results, like values showing up in the wrong columns and cells.

SAP Cloud for Customer

1. Open Microsoft Excel
2. Log into SAP HYBRIS CLOUD FOR CUSTOMER add-in
3. Make sure you are in Personal Workbook mode, under SAP HYBRIS CLOUD FOR CUSTOMER tab
4. Click on Insert Report button
5. Select the desired report and click on Insert Report again
6. Once the report is displayed, apply some filters to the results using excel specific filters (e.g. under Data tab)
7. Save the report
8. Refresh the report
9. Notice that report results get distorted, like values displayed in wrong cells and columns

This issue is observed while keeping some excel specific filter or sorting and refreshing the report.

Make sure to clear the excel specific filters, as the refresh action needs to clear the currently populated report content from the excel and new content will be populated in the report region.
So clearing the excel specific filters/sort will help for the proper refreshing of the data.

KBA , AP-RC-ANA-UI-XLS , C4C, ByD, Travel: Excel AddIn , How To

SAP Cloud for Customer add-ins 1802 ; SAP Hybris Cloud for Customer add-ins 1708 ; SAP Hybris Cloud for Customer add-ins 1711