Slicer/Pivot cache is being reverted despite having been changed in Excel

Aspose.Cells Product Family
1

I’ve attached three files:

  1. Original.xlsx
  2. Changed.xlsx
  3. Program.cs (to demonstrate the issue)

Original.xlsx looks like this:
image.png (109.8 KB)

Changed.xlsx is the same file, except that I opened in in Excel, clicked on Cell G6 and then changed the value from “Food” to “Changed”:
image.png (119.9 KB)

Notice how both the pivot table and slicer both correctly say “Changed”. I can also hit “Refresh All” in excel and save this file, and it seems like both are changed. However, when opening this newly changed file with Aspose, it still shows “Food” in the Slicer Cache, and if I call RefreshAll() both of the values are reset to their original unwanted values.

AsposePivotSlicerBug.zip (25.6 KB)

2

@MattPNuq,

Thanks for the sample files.

After initial testing, I am able to reproduce the issue as you mentioned by using your sample file and code snippet. I found Slicer/Pivot cache is being reverted despite having been changed in Excel file.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-56534

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@MattPNuq,

We are pleased to inform you that your issue (Ticket ID: “CELLSNET-56534”) has been resolved. The fix/enhancement will be included in our upcoming release (Aspose.Cells v24.9) that we plan to release in the first half of September 2024. You will be notified when the next version is released.

4

Thank you!! Much appreciated.

5

@MattPNuq,

You are welcome.

6

The issues you have found earlier (filed as CELLSNET-56534) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi