How to how to find exactly string match in a cell

[thao.le]

Hello.

Let's say, cell D40 contain "Limited" and when i use function "sheet.FindString("Limit", false, false);" and result returned D40, but i want is null because content is not match. So how i can do it

Regards

[Anna.Zhang]

Hi,

Thanks for your inquiry.
The method in the below code could achieve your requirement, but there is a problem in it at present. I have posted it to our Dev team for investigation. If there is any update, we will let you know. Apologize for the inconvenience caused.

Code: Select all

CellRange[] cell = workbook.Worksheets.FindAll("Limit", FindType.Text, ExcelFindOptions.MatchEntireCellContent);

Sincerely,
Anna
E-iceblue support team

[Anna.Zhang]

Hi,

Thanks for your patient waiting.
Glad to inform you that your issue is solved in Spire.XLS Pack(Hotfix) Version:9.2.8. Please download it from the following link.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/

Sincerely,
Anna
E-iceblue support team

[Anna.Zhang]

Hi,

Greetings from E-iceblue.
Have you tried the hotfix?
Your feedback would be greatly appreciated!

Sincerely,
Anna
E-iceblue support team