[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
totalsRowFormula (Totals Row Formula)
This element contains a custom formula for aggregating values from the column.
Each tableColumn has a totalsRowFunction that can be used for simple aggregations such as average, standard deviation, min, max, count, and others. If a more custom calculation is desired, then this element should be used, and the totalsRowFunction shall be set to "custom".
Parent Elements |
tableColumn (§3.5.1.3) |
Attributes |
Description |
array (Array) |
A Boolean value that indicates whether this formula is an array style formula.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_TableFormula">
<simpleContent>
<extension base="ST_Formula">
<attribute name="array" type="xsd:boolean" default="false"/>
</extension>
</simpleContent>
</complexType>