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

  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

• Marked as Answer

  

  sean.lawyer

  

  • Post Options:
  • Link
    Copy

  Replied 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!