Class LogicalFunction
- java.lang.Object
-
- org.apache.poi.ss.formula.functions.Fixed1ArgFunction
-
- org.apache.poi.ss.formula.functions.LogicalFunction
-
- All Implemented Interfaces:
Function,Function1Arg
public abstract class LogicalFunction extends Fixed1ArgFunction
Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
-
-
Field Summary
Fields Modifier and Type Field Description static FunctionISBLANKstatic FunctionISERRImplementation of Excel ISERR() function.static FunctionISERRORstatic FunctionISLOGICALstatic FunctionISNAImplementation for Excel ISNA() function.static FunctionISNONTEXTstatic FunctionISNUMBERstatic FunctionISREFstatic FunctionISTEXT
-
Constructor Summary
Constructors Constructor Description LogicalFunction()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description ValueEvalevaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)-
Methods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction
evaluate
-
-
-
-
Field Detail
-
ISLOGICAL
public static final Function ISLOGICAL
-
ISNONTEXT
public static final Function ISNONTEXT
-
ISNUMBER
public static final Function ISNUMBER
-
ISTEXT
public static final Function ISTEXT
-
ISBLANK
public static final Function ISBLANK
-
ISERROR
public static final Function ISERROR
-
ISERR
public static final Function ISERR
Implementation of Excel ISERR() function.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.
-
ISNA
public static final Function ISNA
Implementation for Excel ISNA() function.Syntax:
ISNA(value)value The value to be tested
Returns TRUE if the specified value is '#N/A', FALSE otherwise.
-
ISREF
public static final Function ISREF
-
-
Method Detail
-
evaluate
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
Description copied from interface:Function1Arg
-
-