|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.apache.poi.hssf.record.formula.functions.Errortype
public final class Errortype
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! |
| Constructor Summary | |
|---|---|
Errortype()
|
|
| Method Summary | |
|---|---|
Eval |
evaluate(Eval[] args,
int srcCellRow,
short srcCellCol)
|
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public Errortype()
| Method Detail |
|---|
public Eval evaluate(Eval[] args,
int srcCellRow,
short srcCellCol)
evaluate in interface Functionargs - the evaluated function arguments. Elements of this array typically implement
ValueEval. Empty values are represented with BlankEval or MissingArgEval, never null.srcCellRow - row index of the cell containing the formula under evaluationsrcCellCol - column index of the cell containing the formula under evaluation
ErrorEval, never null.
Note - Excel uses the error code #NUM! instead of IEEE NaN, so when
numeric functions evaluate to Double.NaN be sure to translate the result to ErrorEval.NUM_ERROR.
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||