I’ve attached two simple Excel files and example code to illustrate the problem.
When creating a pivot table, adding a filter, and then adding a slicer with a single selection, Aspose loads the file and correctly notes that only 1 slicer item is selected. After calling RefreshAll() however, all 5 slicer options become selected, which is incorrect.
This behavior works normally when we do the same exact thing, but NOT adding a filter on the pivot table. It opens it, sees that 1 slicer option is selected, after RefreshAll() it correctly shows that only 1 slicer option is selected, not 5 like in the example above.
Using Aspose.Cells .NET 24.8.0
PivotFilterSlicerBug.zip (25.1 KB)
@MattPNuq
By testing with sample files and code on the latest version v24.8, we can reproduce the issue. Found that all Slicer items are selected after calling RefreshAll() method.
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-56535
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.
@MattPNuq
We are pleased to inform you that your issue (Ticket ID: “CELLSNET-56535”) 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.
The issues you have found earlier (filed as CELLSNET-56535) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi