Implementation for the Excel function SUBTOTAL
Syntax :
SUBTOTAL ( functionCode, ref1, ref2 ... )
functionCode |
(1-11) Selects the underlying aggregate function to be used (see table below) |
ref1, ref2 ... |
Arguments to be passed to the underlying aggregate function |
functionCode |
Aggregate Function |
1 |
AVERAGE |
2 |
COUNT |
3 |
COUNTA |
4 |
MAX |
5 |
MIN |
6 |
PRODUCT |
7 |
STDEV |
8 |
STDEVP * |
9 |
SUM |
10 |
VAR * |
11 |
VARP * |
101 |
AVERAGE |
102 |
COUNT |
103 |
COUNTA |
104 |
MAX |
105 |
MIN |
106 |
PRODUCT |
107 |
STDEV |
108 |
STDEVP * |
109 |
SUM |
110 |
VAR * |
111 |
VARP * |
* Not implemented in POI yet. Functions 101-111 are the same as functions 1-11 but with the option 'ignore hidden values'.
(Excel 函数 SUBTOTAL 语法的实现: SUBTOTAL ( functionCode, ref1, ref2 ... ) functionCode (1-11) 选择要使用的底层聚合函数(见下表) ref1, ref2 ... 要传递给底层聚合函数 functionCode 聚合函数 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP * 9 SUM 10 VAR * 11 VARP * 101 AVERAGE 102 COUNT 103 COUNTA 104 MAX 105 MIN 106 PRODUCT 107 STDEV 108 STDEVP * 109 SUM 110 VAR * 111 VARP * * 尚未在 POI 中实现。函数 101-111 与函数 1-11 相同,但带有“忽略隐藏值”选项。)