Free Support Forum - aspose.com

Finding instances of a formula in cells

FindFormulaContains appears to be case-sensitive.

Does this mean you have to search for every variation of a word to get all hits?

e.g. To get all instances of “sum” and not care about case, you would have to run:
FindFormulaContains(“sum”)
FindFormulaContains(“Sum”)
FindFormulaContains(“sUm”)
FindFormulaContains(“suM”)
FindFormulaContains(“SUm”)
FindFormulaContains(“sUM”)
FindFormulaContains(“SuM”)
FindFormulaContains(“SUM”)

My fault, Excel makes text all-caps when you enter a formula, so this will never be an issue with FindFormulaContains.