We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

FindString's findOptions doesn't compare case sensitivity correctly


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];

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


Hi Steve,

Thanks for pointing it out.

We checked and yes, we found the IsCaseSensitive attribute has different/opposite behavior as you described.
The issue has been logged into our internal issue tracking system with an issue id: CELLSNET-11605. We will fix it soon.

Thank you.


Please try the attached fix, we have fixed your mentioned issue.

Thank you.

The issues you have found earlier (filed as CELLSNET-11605) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.