| 
 | |||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectorg.apache.poi.ss.formula.functions.Fixed1ArgFunction
org.apache.poi.ss.formula.functions.LogicalFunction
public abstract class LogicalFunction
Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
| Field Summary | |
|---|---|
| static Function | ISBLANK | 
| static Function | ISERRImplementation of Excel ISERR() function. | 
| static Function | ISERROR | 
| static Function | ISLOGICAL | 
| static Function | ISNAImplementation for Excel ISNA() function. | 
| static Function | ISNONTEXT | 
| static Function | ISNUMBER | 
| static Function | ISREF | 
| static Function | ISTEXT | 
| Constructor Summary | |
|---|---|
| LogicalFunction() | |
| Method Summary | |
|---|---|
|  ValueEval | evaluate(int srcRowIndex,
         int srcColumnIndex,
         ValueEval arg0)see Function.evaluate(ValueEval[], int, int) | 
| protected abstract  boolean | evaluate(ValueEval arg) | 
| Methods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction | 
|---|
| evaluate | 
| Methods inherited from class java.lang.Object | 
|---|
| clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait | 
| Field Detail | 
|---|
public static final Function ISLOGICAL
public static final Function ISNONTEXT
public static final Function ISNUMBER
public static final Function ISTEXT
public static final Function ISBLANK
public static final Function ISERROR
public static final Function ISERR
 Syntax:
 ISERR(value)
value The value to be tested
Returns the logical value TRUE if value refers to any error value except '#N/A'; otherwise, it returns FALSE.
public static final Function ISNA
 Syntax:
 ISNA(value)
 value  The value to be tested
 
 Returns TRUE if the specified value is '#N/A', FALSE otherwise.
public static final Function ISREF
| Constructor Detail | 
|---|
public LogicalFunction()
| Method Detail | 
|---|
public ValueEval evaluate(int srcRowIndex,
                          int srcColumnIndex,
                          ValueEval arg0)
Function1ArgFunction.evaluate(ValueEval[], int, int)
protected abstract boolean evaluate(ValueEval arg)
arg - any ValueEval, potentially BlankEval or ErrorEval.| 
 | |||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||