Posted 29 August 2019, 8:30 pm EST
Good morning/evening
I’m reaching you out as I’ve tried to use the HideRowFilter functionality to setup a filtering system within a sheet
my code is something like this:
const totalRows = window.spreadSheet.activeSheet.getRowCount()
const totalCols = window.spreadSheet.activeSheet.getColumnCount()
const rowFilter = new GC.Spread.Sheets.Filter.HideRowFilter(
new GC.Spread.Sheets.Range(1, 0, totalRows, totalCols),
)
window.spreadSheet.activeSheet.rowFilter(rowFilter)
rowFilter.filterButtonVisible(0, true)
The output displays correctly the small triangle on top of the cells of the first row, the filters are working correctly but whenever I click on Sort Ascending/Descending it doesn’t trigger anything
I’m wondering if I’m missing some configuration, the documentation for the Filters is a bit mixed, there are few methods that are deprecated and I can’t find valuable examples
Thanks in advance for your support