public final class Count extends java.lang.Object implements Function
Constructor and Description |
---|
Count() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(ValueEval[] args, int srcCellRow, int srcCellCol) |
static Count |
subtotalInstance(boolean includeHiddenRows)
Create an instance of Count to use in
Subtotal
(创建要在小计中使用的 Count 实例)
|
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。)
public static Count subtotalInstance(boolean includeHiddenRows)
Subtotal
If there are other subtotals within argument refs (or nested subtotals), these nested subtotals are ignored to avoid double counting.
(创建要在小计中使用的 Count 实例 如果参数引用(或嵌套小计)中有其他小计,则忽略这些嵌套小计以避免重复计算。)includeHiddenRows
- true to include hidden rows in the aggregate, false to skip them
(includeHiddenRows - true 表示在聚合中包含隐藏行,false 表示跳过它们)
Subtotal
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.