Posted 13 January 2020, 5:23 pm EST
Hi Experts,
I am using spread-com in my c++ application and looking for the methods for searching & selection of column data using wildcard.
Forums Home / Spread / Spread COM
Posted by: vikasbhutani on 13 January 2020, 5:23 pm EST
Posted 13 January 2020, 5:23 pm EST
Hi Experts,
I am using spread-com in my c++ application and looking for the methods for searching & selection of column data using wildcard.
Posted 16 January 2020, 2:03 am EST
Hi,
If you are using C++, I recommend using the DLL control – then your application can be built for x86, x64, or Itanium targets using the ANSI or Unicode DLL libraries for the respective platform. In that case, the functions for searching are SSSearchCol and SSSearchRow, and the functions for setting the selection are SSSetSelectBlock and SSSetMultiSelBlocks:
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
SSSetSelectBlock function: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct34d.html
SSSetMultiSelBlocks function: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct37c.html#797808
The search functions do not support wildcard search; you can, however, use the search flags to specify partial-match. Multiple block selections are not enabled by default, and the control must be initialized with SSSetBool specifying SSB_ALLOWMULTIBLOCKS to enable multiple block selections:
SSSetBool function: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct69a.html
The OCX control can also work in C++ and has equivalent functions, but is limited to x86 platform and requires using the COM control interfaces.
Hope that helps!
Regards,
-Sean