I’m hoping to have the slicer filters shown with my pivot table, generated by GemBox:
Hi,
GemBox.Spreadsheet currently doesn’t have API support for slicers.
Please feel free to vote for this feature to increase its priority:
https://support.gemboxsoftware.com/community/view/support-for-excel-slicers
I cannot say when this could be available, currently, there are other feature requests with greater priority (more user requests).
Regards,
Mario
Thank you for the information.
Do you know why i cannot manually add slicers to the document generated through the API?
The slicer buttons are greyed out/disabled. The file is NOT opened in compatabilty mode and saving the file as a new file, and opening the new file still also has the Slicer buttons disabled.
Can you send us your Excel file so that we can investigate it?
Please try again with this NuGet package:
Install-Package GemBox.Spreadsheet -Version 49.0.1824-hotfix
Note that this is a hidden pre-released version, to install it you’ll need to run the above command on the NuGet Package Manager Console (Tools → NuGet Package Manager → Package Manager Console).
Does this solve your issue?
Regards,
Mario
Hi Mario,
Thank you so much for the help!
Unfortunately, i’ll need to pivot to another task and hope to come back to this in a week.
I will keep you posted ASAP…
Hi Mario,
It turns out that the licesne has expired, so even if this fix works, I will not be able to use it.
If I provide the license details, would you be able to confirm what the last version that is eligible for the license?
Yes, I can let you know the last version you’re entitled to.
The license keys have purchase data at the beginning (e.g. “SN-YourPurchaseDate-…”), if the date is before 2023 then you had 18 months of support, if it’s after then you had 12 months of support. The last version you can use is the last one released before your support period ended.
Thank you Mario,
The licence is dated 2022-09-21. So it sounds like v1623 (March 4, 2024) is the last version I am eligible to use. Does this sound accurate to you?
I appreciate you supplying a temporary licence, but my RFP to update the licesnse has been denied. I’ve been instructed to halt development on anything beyond the existing license and may need to abandon the latest branch entirely, as a result of this bug.
Is there anything I can do to the excel file that was generated, to allow the slicers to be used after the file is generated?
The only thing that comes to my mind is to create a dummy PivotTable with Microsoft Excel which you would then use with GemBox.Spreadsheet to create your desired PivotTable by modifying its source data.