[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

tableColumn3.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>