Check for formula errors

Aspose.Cells Product Family
1

Hi,

Is it possible to scan a workbook to see if there’s any active formula error like #DIV/0!, #N/A, #REF!, #VALUE!, #NUM!, etc…

Thanks!

2

Hi,
You may check cells by code like:

            IEnumerator en = cells.GetEnumerator();
            while (en.MoveNext())
            {
                cell = (Cell)en.Current;
                if (cell.IsFormula && cell.IsErrorValue)
                {
                    //do your business
                }
            }
3

Is there a way to accomplish this without looping through all the cells?

4

@kirederf81,

The shared code segment is fast, so you may set break and add your desired code segment once the if condition is true:

Alternatively, you may try to use Find/Search options to find the error string(s) to check if formula errors found in a worksheet or not.