Acces to the table's filter

Acces to the table's filter

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

• 

  Lmqr9011

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 April 2018, 10:30 am EST - Updated 11 January 2024, 5:42 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.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  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

• 

  Lmqr9011

  • Post Options:
  • Link
    Copy

  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?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  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

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

  and observe in the “Table” sheet the last table is filtered.

  Thanks,
  
  Deepak Sharmaexport20180427184752.zip