|
||||||||||
| 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.Match
public final class Match
Implementation for the MATCH() Excel function.
Syntax:| Value | Matching Behaviour |
|---|---|
| 1 | (default) find the largest value that is less than or equal to lookup_value. The lookup_array must be in ascending order*. |
| 0 | find the first value that is exactly equal to lookup_value. The lookup_array can be in any order. |
| -1 | find the smallest value that is greater than or equal to lookup_value. The lookup_array must be in descending order*. |
| Constructor Summary | |
|---|---|
Match()
|
|
| 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 Match()
| 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 | |||||||||