Searching & selection of column data using wildcards

Searching & selection of column data using wildcards

Posted by: vikasbhutani on 14 January 2020, 2:23 am EST

• 

  vikasbhutani

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 January 2020, 2:23 am 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.

• 

  sean.lawyer

  

  • Post Options:
  • Link
    Copy

  Posted 16 January 2020, 11: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