Before starting a huge job, I’d appreciate comments: is the suggested approach, to get similar functionality in a certain spreadsheet, OK?
Description of the problem: An Excel worksheet has slicers, filtering data for pivot tables.
The slicers are (of course…) not on the page with the pivot tables.
This Excel worksheet has to be adapted for use in Calc.
How to resolve this?
My take would be:
Add Page fields to the pivot tables.
These allows to filter, the work that is done by the Slicers in Excel
Add some nice looking table kind of thing in place of the slicers. Where in some way the values for the page fields can be selected/marked.
Create a update-macro that updates the pivot table page fields accordingly to the settings in the ‘tables’
Add a button by the tables, to start the update-macro
(or use an event-listener (cell-changed), but I’m not a fan of those in Calc basic)
Makes sense, Anything I miss?