SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SAP Cloud for Customer

Reproducing the Issue

  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

Cause

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

Resolution

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.

Keywords

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

Product

SAP Cloud for Customer 1802 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711