Searchflag useWildCards

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

  • 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
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels