Hide grid rows based on column value?

Hide grid rows based on column value?

Posted by: pauld on 1 April 2025, 5:39 pm EST

• 

  pauld

  • Post Options:
  • Link
    Copy

  Posted 1 April 2025, 5:39 pm EST

  Using Spread 12 (I know) currently.

  Can rows be hidden based on a cell value.
  
  We want to be able to set a “HideRowInGrid” value in the grid’s datasource and have the grid dynamically update.

  Thanks.
  
  – Paul

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 2 April 2025, 8:10 am EST

  Hi Paul,

  You can implement filtering on your sheet based on the required condition. Here is the documentation link for your reference: https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-filtering.html

  You can also manage the appearance of the filter indicator as shown here: https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-filter-customindicator.html

  Note: V12 is obsolete, and we do not support it anymore. We kindly request you update to the latest version(V18) in order to get the latest features and support.

  Thanks & regards,
  
  Aastha

• 

  pauld

  • Post Options:
  • Link
    Copy

  Posted 2 April 2025, 11:37 am EST

  Aastha,

  Thanks for the reply.
  
  Would this filtering work without showing any filter bar or indicators, etc?
  
  We don’t want the user to see any filter-related UI elements in the grid, we just want to programmatically hide/show any row by changing a value in the datasource.

  Thanks.
  
  – Paul

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 3 April 2025, 6:38 am EST

  Hi Paul,

  You can hide the filter icons by setting RowFilter’s ShowFilterIndicator property to ‘False’. Here is the link for your reference: https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-filter-hideindicators.html

  Hope this helps!

  Thanks & regards,
  
  Aastha