Acces to the table's filter

Posted by: Lmqr9011 on 23 April 2018, 10:30 am EST

    • Post Options:
    • Link

    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


    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:

    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 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


    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

Need extra support?

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

Learn More

Forum Channels