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.htmlSSSearchRow function:
https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct458.htmlSSShowCol function:
https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct58.htmlSSShowRow function:
https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct59.htmlUsing 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!