|
||||||||||
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 Function
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |