org.apache.poi.hssf.record.formula.functions
Class Errortype
java.lang.Object
org.apache.poi.hssf.record.formula.functions.Fixed1ArgFunction
org.apache.poi.hssf.record.formula.functions.Errortype
- All Implemented Interfaces:
- Function, Function1Arg
public final class Errortype
- extends Fixed1ArgFunction
Implementation for the ERROR.TYPE() Excel function.
Syntax:
ERROR.TYPE(errorValue)
Returns a number corresponding to the error type of the supplied argument.
| errorValue | Return Value |
| #NULL! | 1 |
| #DIV/0! | 2 |
| #VALUE! | 3 |
| #REF! | 4 |
| #NAME? | 5 |
| #NUM! | 6 |
| #N/A! | 7 |
| everything else | #N/A! |
Note - the results of ERROR.TYPE() are different to the constants defined in
HSSFErrorConstants.
- Author:
- Josh Micich
| Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Errortype
public Errortype()
evaluate
public ValueEval evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0)
- Description copied from interface:
Function1Arg
- see
Function.evaluate(ValueEval[], int, int)