TotalsRowFormula Class
Totals Row Formula.When the object is serialized out as xml, its qualified name is x:totalsRowFormula.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.OpenXmlLeafTextElement
DocumentFormat.OpenXml.Spreadsheet.TableFormulaType
DocumentFormat.OpenXml.Spreadsheet.TotalsRowFormula
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
Public Class TotalsRowFormula _
Inherits TableFormulaType
'Usage
Dim instance As TotalsRowFormula
public class TotalsRowFormula : TableFormulaType
Remarks
[ISO/IEC 29500-1 1st Edition]
18.5.1.6 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.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.