Table vs TableSheet Filter Multiple Columns

Table vs TableSheet Filter Multiple Columns

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

• 

  michael.thrift2

  • Post Options:
  • Link
    Copy

  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.

  Table
  
  

  TableSheet
  
  

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 14 September 2022, 9:35 pm EST

  Hi,

  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

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 2 May 2023, 8:11 pm EST

  Hi,

  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:
  
  http://cdn.grapecity.com/spreadjs/16.1.0/Files/SpreadJS.Release.16.1.0.zip

  Regards,

  Ankit