Edit

Share via

Excel.Subtotals interface

  • Reference
Package:
excel

Subtotals for the Pivot Field.

Remarks

[ API set: ExcelApi 1.8 ]

Properties

automatic

If Automatic is set to true, then all other values will be ignored when setting the Subtotals.
average
count
countNumbers
max
min
product
standardDeviation
standardDeviationP
sum
variance
varianceP

Property Details

automatic

If Automatic is set to true, then all other values will be ignored when setting the Subtotals.

automatic?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

average 

average?: boolean;

Property Value

boolean

count 

count?: boolean;

Property Value

boolean

countNumbers 

countNumbers?: boolean;

Property Value

boolean

max 

max?: boolean;

Property Value

boolean

min 

min?: boolean;

Property Value

boolean

product 

product?: boolean;

Property Value

boolean

standardDeviation 

standardDeviation?: boolean;

Property Value

boolean

standardDeviationP 

standardDeviationP?: boolean;

Property Value

boolean

sum 

sum?: boolean;

Property Value

boolean

variance 

variance?: boolean;

Property Value

boolean

varianceP 

varianceP?: boolean;

Property Value

boolean