[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ST_TotalsRowFunction (Totals Row Function Types)
An enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row.
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
|
Enumeration Value |
Description |
|
average (Average) |
Represents the arithmetic mean. |
|
count (Non Empty Cell Count) |
Represents a count of the number of non-empty cells. |
|
countNums (Count Numbers) |
Represents the number of cells that contain numbers. |
|
custom (Custom Formula) |
Represents the formula provided in totalsRowFormula. |
|
max (Maximum) |
Represents the largest value. |
|
min (Minimum) |
Represents the smallest value. |
|
none (None) |
No total row. |
|
stdDev (StdDev) |
Represents the estimated standard deviation. |
|
sum (Sum) |
Represents the arithmetic sum. |
|
var (Var) |
Represents the estimated variance. |
|
Referenced By |
|
tableColumn@totalsRowFunction (§3.5.1.3) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_TotalsRowFunction">
<restriction base="xsd:string">
<enumeration value="none"/>
<enumeration value="sum"/>
<enumeration value="min"/>
<enumeration value="max"/>
<enumeration value="average"/>
<enumeration value="count"/>
<enumeration value="countNums"/>
<enumeration value="stdDev"/>
<enumeration value="var"/>
<enumeration value="custom"/>
</restriction>
</simpleType>