[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@totalsRowFunction3.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>