Table vs TableSheet Filter Multiple Columns

Posted by: michael.thrift2 on 14 September 2022, 12:04 am EST

  • Posted 14 September 2022, 12:04 am EST - Updated 3 October 2022, 12:02 am EST

    It seems that the TableSheet columns share the same filter condition for the table filter. You cannot filter on multiple columns. Adding a filter to any 1 column works. But when you add another filter to a 2nd column, it removes the filter from the first column.

    Attached are two GIF’s demonstrating the behavior of the Table component as part of the standard worksheet, and then the TableSheet component.

    Is there a way to filter on multiple columns using the TableSheet? I was expecting to be able to do this as part of a work around for another issue i’m experiencing which I already have a topic for. But this is somewhat critical for my requirements.



  • Posted 14 September 2022, 9:35 pm EST


    We are sorry but this is currently not supported. W have made an enhancement request on your behalf. We will update you regarding this as we get any information from the team. The internal ID for this issue will be SJS-14733.

    Regards, Avinash

  • Posted 2 May 2023, 8:11 pm EST


    The mentioned feature has been added in the latest version of SpreadJS V16.1.0. Kindly upgrade to the latest version of SpreadJS.

    You may download the latest version of SpreadJS using the following link:



Need extra support?

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

Learn More

Forum Channels