public abstract class RelationalOperationEval extends Fixed2ArgFunction implements ArrayFunction
Modifier and Type | Field and Description |
---|---|
static Function |
EqualEval |
static Function |
GreaterEqualEval |
static Function |
GreaterThanEval |
static Function |
LessEqualEval |
static Function |
LessThanEval |
static Function |
NotEqualEval |
Constructor and Description |
---|
RelationalOperationEval() |
Modifier and Type | Method and Description |
---|---|
protected abstract boolean |
convertComparisonResult(int cmpResult)
Converts a standard compare result (-1, 0, 1) to
true or
false according to subclass' comparison type.
(根据子类的比较类型将标准比较结果 (-1, 0, 1) 转换为真或假。)
|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
This is a description of how the relational operators apply in MS Excel.
(这是对关系运算符如何在 MS Excel 中应用的描述。)
|
ValueEval |
evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex) |
evaluate
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
evaluateOneArrayArg, evaluateTwoArrayArgs
public static final Function EqualEval
public static final Function GreaterEqualEval
public static final Function GreaterThanEval
public static final Function LessEqualEval
public static final Function LessThanEval
public static final Function NotEqualEval
protected abstract boolean convertComparisonResult(int cmpResult)
true
or
false
according to subclass' comparison type.
(根据子类的比较类型将标准比较结果 (-1, 0, 1) 转换为真或假。)
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
Bool.TRUE > any number. Bool > any string. ALWAYS Bool.TRUE > Bool.FALSE Bool.FALSE == Blank Strings are never converted to numbers or booleans String > any number. ALWAYS Non-empty String > Blank Empty String == Blank String are sorted dictionary wise Blank > Negative numbers Blank == 0 Blank < Positive numbers(这是对关系运算符如何在 MS Excel 中应用的描述。在测试/实现关系运算符 Eval 的评估方法时,将此作为指南。 Bool.TRUE > 任何数字。布尔 > 任何字符串。 ALWAYS Bool.TRUE > Bool.FALSE Bool.FALSE == 空白字符串永远不会转换为数字或布尔字符串 > 任何数字。 ALWAYS 非空字符串 > 空白空字符串 == 空白字符串按字典排序 空白 > 负数 空白 == 0 空白 < 正数)
evaluate
in interface
Function2Arg
(在接口 Function2Arg 中求值)
public ValueEval evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
evaluateArray
in interface
ArrayFunction
(接口 ArrayFunction 中的 evaluateArray)
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 - 包含正在评估的公式的单元格的列索引)
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。)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.