TotalsRowFormula class

Office 2013 and later

Totals Row Formula. When the object is serialized out as xml, its qualified name is x:totalsRowFormula.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

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 (§18.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 W3C XML Schema boolean datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_TableFormula) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: