Posted 23 April 2018, 10:30 am EST
Im 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.
Forums Home / Spread / DevChannel
Posted by: Lmqr9011 on 23 April 2018, 10:30 am EST
Posted 23 April 2018, 10:30 am EST
Im 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.
Posted 24 April 2018, 10:31 pm EST
Hello,
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: http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.Filter.HideRowFilter.html
Thanks, Deepak Sharma
Posted 24 April 2018, 11:11 pm EST
Thanks, 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?
Posted 27 April 2018, 12:21 am EST
Hello,
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.
Thanks, Deepak Sharmaexport20180427184752.zip