Filtering of column data based on conditions

Filtering of column data based on conditions

Posted by: vikasbhutani on 13 January 2020, 5:20 pm EST

• 

  vikasbhutani

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 January 2020, 5:20 pm EST

  Hi Experts,

  I am using spreadcom in c++ application and would like to know the methods/ functions available for filtering the column data based on some conditions

• 

  sean.lawyer

  

  • Post Options:
  • Link
    Copy

  Posted 16 January 2020, 2:23 am EST

  Hi,

  There are is no built-in API for filtering data based on conditions. You can implement code to perform filtering using the functions available for search (SSSearchCol and SSSearchRow) together with the functions for hiding and showing rows and columns (SSShowCol and SSShowRow):
  
  SSSearchCol function: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct457.html
  
  SSSearchRow function: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct458.html
  
  SSShowCol function: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct58.html
  
  SSShowRow function: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct59.html

  Using those functions, you can implement code to filter out the rows (or columns) by hiding and showing the rows (or columns) based on the search result.

  Again, there are OCX equivalents for those functions if you are using the ActiveX control instead of the DLL control, but I recommend using the DLL control for the platforms it can support – x86, x64, and Itanium.

  Hope that helps!