How to clean filters

How to clean filters

Posted by: tedin_uriburu on 9 December 2020, 1:33 pm EST

• 

  tedin_uriburu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 December 2020, 1:33 pm EST

  Hi,
  
  I want to programatically clean current filters (in all columns) in order to have a “Clean filters” button. How can I clean them?
  
  Thanks.

• 

  tedin_uriburu

  • Post Options:
  • Link
    Copy

  Posted 9 December 2020, 2:11 pm EST

  Well, I just found .reset(), so I am doing
  
  _this.cleanFilters = function () {
  
  var filter = _this.spread.getActiveSheet().rowFilter();
  
  filter.reset();
  
  }

  I suppose this is fine, just in case anyone needs it,

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 10 December 2020, 3:46 am EST

  Hi,

  We are glad to hear that the issue has been solved at your end. Please feel free to revert back if you have any further queries.

  Regards
  
  Avinash