After entering a formula or opening an Excel file, an error message may appear:
Error Message |
Possible Error(s) |
##### |
Column is not wide enough to display all text. Increase the column width. |
#DIV/0! |
The formula entered divides by zero. |
#FUNCTION! #FUNC |
The Excel function is not supported by EasySpreadsheet. Use the Excel Viewer to view the spreadsheet. |
#NAME? |
The function entered does not exist in EasySpreadsheet. |
#NUM! |
Invalid numbers were used in a formula. For example, a function may have required nonnegative numbers, but negative numbers were used. |
#VALUE! |
The wrong value type may have been used in a formula. For example, a function may have required a logical value, but a numerical value was used. When using search and replace functions, this message appears when the search text is not found. |
#REF! |
Invalid cell references were used, or a necessary cell reference was not given. |