IWorkSheet..FindFirst does not work

[Emperor]

I am using a template.

row = sheet.FindFirst("[[tag]]", ExcelFindType.Text).Row;

This returns null although the the worksheet has a cell of type text containing "[[tag]]".

Please help. Thanks

[Melba Winshia]

Hi Emperor,

I am afraid. I was not able to reproduce the issue. Here is the test sample that I used to test this issue.

Find.zip

Could you please take a look at the sample above and kindly let me know if you still find any problem, if not could you please modify this sample so that I can reproduce the issue. This would help me in investigating this issue further.

Thanks,
Melba

[Administrator]

Hi Melba,
Thanks for the sample code. I have used the exact code you have in there. The only difference is that I am using a template, which I open, and then try to search for the tag.
The case you used - You are inserting the tag in a new worksheet through the code, then search for the tag, which works fine.

I hope I made my scenario a bit more clear. If you can please look into this, that will be great.
Thanks.

>Hi Emperor,

I am afraid. I was not able to reproduce the issue. Here is the test sample that I used to test this issue.

Find.zip

Could you please take a look at the sample above and kindly let me know if you still find any problem, if not could you please modify this sample so that I can reproduce the issue. This would help me in investigating this issue further.

Thanks,
Melba

[Melba Winshia]

Hi Emperor,

I created a template and then I opened that template to search for the tag. But I was not able to reproduce the issue. Here is the test sample that I used to test this issue.

Find.zip

Could you please take a look at the sample above and kindly let me know if you still find any problem, if not could you please modify this sample so that I can reproduce the issue and also could you please provide me the version of Essential studio you are using? This would help me in investigating this issue further.

Thanks,
Melba