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

Free Support Forum - aspose.com

Find.String Vs Find


Can you please confirm if findOptions.LookInType was LookInType.Values; or ValuesExcludeFormulaCell in “FindString()”. The reason I am asking is that “FindString()” does not find the string which is derived as a Formula output but LookInType.Values find the string which is a formula output. Can you please confirm?

FindOptions findOptions = new FindOptions();

findOptions.CaseSensitive = false;

findOptions.LookInType = LookInType.Values;

findOptions.LookAtType = LookAtType.Contains

Aspose.Cells.Cell chCell = cells.Find(placeHolderName, prevCell, findOptions);

This query is replied here.