findCell to work on WHOLE cell value only

Suite and Optimus Suite 5
#1

Please can you tell me how I can use ‘grid.findCell’ function to ONLY look at whole cell value.

e.g. I have a column with a cell value of ‘Platinum’. I then do a findCell(‘tin’) on that column and I get the row containing Platinum. However I ONLY want to find cells with WHOLE word ‘tin’.

Please help.

Thanks

Purvez

#2

findCell() method works as designed.
As a workaround you can iterate over each cell in grid manually, use getValue() method and compare it with searched value.