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

Free Support Forum - aspose.com

Check for formula errors


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…


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

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


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.