Searchflag useWildCards

Searchflag useWildCards

Posted by: m.holland-moritz on 21 April 2021, 5:59 pm EST

• 

  m.holland-moritz

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 April 2021, 5:59 pm EST

  Hello Team.

  Today i ran into a problem with the searchflag useWildCards. When i set the flag in the searchconditions it just doesn’t work.

  My searchcondition looks like that:

  
  var sheets = GC.Spread.Sheets;
  var searchCondition = new sheets.Search.SearchCondition();
  
  searchCondition.searchString = "T?st";
  searchCondition.rowStart = 0;
  searchCondition.columnStart = 0;
  
  searchCondition.startSheetIndex = spread.getActiveSheetIndex();
  searchCondition.endSheetIndex = spread.getActiveSheetIndex();
  
  searchCondition.searchOrder = sheets.Search.SearchOrder.nOrder;
  searchCondition.searchTarget = sheets.Search.SearchFoundFlags.cellText;
  
  if (test.exactMatch) { 
  searchCondition.searchFlags |= sheets.Search.SearchFlags.exactMatch; 
  }
  if (test.ignoreCase) { 
  searchCondition.searchFlags |= sheets.Search.SearchFlags.ignoreCase; 
  }
  if (test.useWildcard) { 
  searchCondition.searchFlags |= sheets.Search.SearchFlags.useWildCards; 
  }
  
  var searchresult = spread.search(searchCondition);
  
  

  After all that it just doesn’t found anything, while obviously having a filled sheet with cells like: Test, Tsst, Tast, etc.

  I hope u can help me.

  Regards
  
  Maik

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 22 April 2021, 9:26 pm EST

  Hi Maik,

  We are sorry but we are unable to replicate the issue at our end. Could you please provide small sample that replicates the issue so that we could investigate it further and assist you accordignly. You may also check the sample that we use for testing and modify it to replicate the issue.

  Sample: https://codesandbox.io/s/affectionate-tharp-l1hhn?file=/src/index.js:761-901

  useWildCards:https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Search.SearchFlags.html

  Regards
  
  Avinash