Posted 23 April 2018, 10:30 am ESTIm using spread 11, and I have a table in a column with a filter. I wanna do a copy of that filter, but I can't find the object that contains the filter properties from that table.
Acces to the table's filter
Posted by: Lmqr9011 on 23 April 2018, 10:30 am EST
Replied 24 April 2018, 10:31 pm ESTHello,
This is correct behavior, when you copy a cell with Filter, it only copies the text in cell and not the filter list.
After paste, you would need to apply filter to the range again following the instructions here:
Replied 24 April 2018, 11:11 pm ESTThanks,
So I can't do have acces to the filteritemsvalues from that tableview?. I wanna save those and load them later, im using the sheetview.save option with the data only parameter, but im losing those tableview's filter items when open again the sheet, thats why I wanna save them. Is anyway to do that to a tableview?
Marked as Answer
Replied 27 April 2018, 12:21 am ESTHello,
Filteritems list is the values in cells for the column in that table. After applying filter to a Table column and saving it to JSON saves the filter state too. Please have a look at the attached JSON data which is saved for Table column filter. You can open this with our online demo
and observe in the "Table" sheet the last table is filtered.