public final class Sumproduct extends java.lang.Object implements Function
Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])
array1, ... arrayN | typically area references, possibly cell references or scalar values |
---|
Constructor and Description |
---|
Sumproduct() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(ValueEval[] args, int srcCellRow, int srcCellCol) |
public ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
evaluate
in interface
Function
(在接口函数中求值)
args
- the evaluated function arguments. Empty values are represented with
BlankEval
or
MissingArgEval
, never
null
.
(args - 评估的函数参数。空值用 BlankEval 或 MissingArgEval 表示,绝不为 null。)
srcCellRow
- row index of the cell containing the formula under evaluation
(srcCellRow - 包含计算公式的单元格的行索引)
srcCellCol
- column index of the cell containing the formula under evaluation
(srcCellCol - 包含正在评估的公式的单元格的列索引)
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.