Acces to the table's filter

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.
  • Replied 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
  • Replied 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?
  • Marked as Answer

    Replied 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

    https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

    and observe in the "Table" sheet the last table is filtered.

    Thanks,
    Deepak Sharmaexport20180427184752.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels