How can I clear the table sheet filter?

How can I clear the table sheet filter?

Posted by: minhhieu2032000 on 13 March 2025, 2:39 am EST

• 

  minhhieu2032000

  • Post Options:
  • Link
    Copy

  Posted 13 March 2025, 2:39 am EST

  Its my demo:
  
  https://jscodemine.mescius.io/sample/prsdXl8kfkGe3db8m_JNOw/

  I cannot clear filter when using sheet.rowfilter().Reset()
  
  Must set the new view to clear filter. How to be able to clear filter of table sheet

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 13 March 2025, 7:35 am EST

  Hi,

  You are correct that the sheet.rowFilter().reset() method cannot be used to clear filters in a TableSheet. This behavior is expected because a TableSheet is not a standard sheet object; rather, it is a dynamic view that internally utilizes a sheet but does not function as a standalone sheet object. As a result, it does not have access to the rowFilter() method, which is why calling sheet.rowFilter().reset() has no effect.

  Since TableSheet operates as a view, modifying the view itself effectively resets the filter. For more details, you may refer to the following documentation:

  Introduction to TableSheet: https://developer.mescius.com/spreadjs/docs/features/tablesheet

  Sorting and Filtering in TableSheet: https://developer.mescius.com/spreadjs/docs/features/tablesheet/tablesheet-operations/tablesheet-sort-filter

  Sorting and filtering are core functionalities of TableSheet and are implemented by design. If you could share your specific use case, we would be happy to investigate further and suggest a more suitable solution.

  Best regards,

• 

  minhhieu2032000

  • Post Options:
  • Link
    Copy

  Posted 13 March 2025, 10:06 pm EST

  So, I still have to call sheet.setDataView(view) to reset the filter, right?
  
  I would like to ask if there is any way to know if the Table Sheet is being filtered or not?