Programmatic filter doesn't reflect context filter box

Programmatic filter doesn't reflect context filter box

Posted by: davide.vago on 27 July 2020, 8:01 am EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 July 2020, 8:01 am EST - Updated 3 October 2022, 10:15 am EST

  Hi there,

  I’m writing to you as for a while the implementation of SJS in our app suffered of the title’s issue.

  Given the sandbox sample code:
  
  https://codesandbox.io/s/spreadjs-workbook-statusbar-programmatic-filter-wggp5?file=/src/components/WorkBookInstance.vue

  Observe this behaviour:
  
  

  Expected behaviour:
  
  The context filter which comes out from the small icon next to the column title should reflect the rowFilter applied.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 28 July 2020, 5:42 am EST

  Hi Davide,

  This is because you are applying a condition filter. As the default behavior, when a condition filter is applied, it is not reflected in the values shown in the filter. This is the same behavior as MS Excel.
  
  To be able to reflect the applied filter into the filter values we need to apply filter by exact values. I’ve updated the sample to demonstrate the same, please refer to the following updated sample:
  
  https://codesandbox.io/s/spreadjs-workbook-statusbar-programmatic-filter-vwc3v?file=/src/components/WorkBookInstance.vue

  Regards
  
  Sharad

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 29 July 2020, 4:55 am EST

  Got it, thanks for the explanation and the source sample.