org.apache.poi.ss.formula.functions

Class LogicalFunction

java.lang.Object

org.apache.poi.ss.formula.functions.Fixed1ArgFunction

org.apache.poi.ss.formula.functions.LogicalFunction

All Implemented Interfaces:

ArrayFunction, Function, Function1Arg

public abstract class LogicalFunction
extends Fixed1ArgFunction
implements ArrayFunction

Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False. (各种 ISxxx 逻辑函数的实现，它们采用单个表达式参数，并返回 True 或 False。)

Field Summary

Fields

Modifier and Type	Field and Description
static Function	ISBLANK
static Function	ISERR Implementation of Excel ISERR() function. (Excel ISERR() 函数的实现。)
static Function	ISERROR
static Function	ISLOGICAL
static Function	ISNA Implementation for Excel ISNA() function. (Excel ISNA() 函数的实现。)
static Function	ISNONTEXT
static Function	ISNUMBER
static Function	ISREF
static Function	ISTEXT

Constructor Summary

Constructors

Constructor and Description
LogicalFunction()

Method Summary

Modifier and Type	Method and Description
ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) see Function.evaluate(ValueEval[], int, int) (见 Function.evaluate(ValueEval[], int, int))
protected abstract boolean	evaluate(ValueEval arg)
ValueEval	evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)

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

Methods inherited from interface org.apache.poi.ss.formula.functions.ArrayFunction

evaluateOneArrayArg, evaluateTwoArrayArgs

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.

(Excel ISERR() 函数的实现。语法：ISERR(value) value 要测试的值 如果 value 引用除 '#N/A' 之外的任何错误值，则返回逻辑值 TRUE；否则，它返回 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.

(Excel ISNA() 函数的实现。语法：ISNA(value) value 要测试的值 如果指定的值为'#N/A'，则返回 TRUE，否则返回 FALSE。)

ISREF

public static final Function ISREF

Constructor Detail

LogicalFunction

public LogicalFunction()

Method Detail

evaluate

public ValueEval evaluate(int srcRowIndex,
                          int srcColumnIndex,
                          ValueEval arg0)

Description copied from interface: Function1Arg

see Function.evaluate(ValueEval[], int, int) (见 Function.evaluate(ValueEval[], int, int))

Specified by:

evaluate in interface Function1Arg (在接口 Function1Arg 中评估)

evaluateArray

public ValueEval evaluateArray(ValueEval[] args,
                               int srcRowIndex,
                               int srcColumnIndex)

Specified by:

evaluateArray in interface ArrayFunction (接口 ArrayFunction 中的 evaluateArray)

Parameters:

args - the evaluated function arguments. Empty values are represented with BlankEval or MissingArgEval, never null. (args - 评估的函数参数。空值用 BlankEval 或 MissingArgEval 表示，绝不为 null。)

srcRowIndex - row index of the cell containing the formula under evaluation (srcRowIndex - 包含计算公式的单元格的行索引)

srcColumnIndex - column index of the cell containing the formula under evaluation (srcColumnIndex - 包含正在评估的公式的单元格的列索引)

Returns:

The evaluated result, possibly an 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. (评估结果，可能是 ErrorEval，绝不为空。注意 - Excel 使用错误代码 #NUM！而不是 IEEE NaN，因此当数值函数计算为 Double.NaN 时，请务必将结果转换为 ErrorEval.NUM_ERROR。)

evaluate

protected abstract boolean evaluate(ValueEval arg)

Parameters:

arg - any ValueEval, potentially BlankEval or ErrorEval. (arg - 任何 ValueEval，可能是 BlankEval 或 ErrorEval。)