Hi,
When the FindOptions.IsCaseSensitive property is set to false, for some reason FindString() does not do a case insensitive comparison. And if the IsCaseSensitive property is set to true, FindString() does a case insensitive comparison!
Here's the code I ran:
-----------------------------------------------------------------------------------------------
var worksheet = new Workbook().Worksheets[0];
var cell = worksheet.Cells[2, 0];
cell.PutValue("Test");
var findOptions = new FindOptions { IsCaseSensitive = true };
var foundCell = worksheet.Cells.FindString("tEsT", null, findOptions);
// ****** foundCell should be null here since we're doing a case sensitive find ****** //
// ****** Instead, found cell is the cell at [2, 0] ****** //
Assert.That(foundCell.Row, Is.EqualTo(2));
Assert.That(foundCell.Column, Is.EqualTo(0));
-----------------------------------------------------------------------------------------------
Is this the intended behavior?
I'm using 4.8.0.5.
-Steve