CalculatedMember class
Defines the CalculatedMember Class.This class is only available in O15. When the object is serialized out as xml, its qualified name is x15:calculatedMember.
Inheritance hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office15.Excel.CalculatedMember
Namespace: DocumentFormat.OpenXml.Office15.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office15)> _
Public Class CalculatedMember _
Inherits OpenXmlLeafElement
'Usage
Dim instance As CalculatedMember
[OfficeAvailabilityAttribute(FileFormatVersions.Office15)]
public class CalculatedMember : OpenXmlLeafElement
Remarks
2.4.48 calculatedMember
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/11/main
Referenced by: CT_CalculatedMemberExt
A CT_CalculatedMember (see section 2.6.15) element that specifies a definition for a custom member or measure that is applied to a pivot table.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="calculatedMember" type="CT_CalculatedMember"/>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.101 CT_CalculatedMember
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/11/main
Referenced by: CT_CalculatedMemberExt, calculatedMember
This element adds new properties for supporting calculated members.
Attributes:
measureGroup: A ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the name of the measure group that this calculated member is associated with if measure is TRUE.
numberFormat: A ST_CalcMemNumberFormat (see section 2.7.26) attribute that specifies the formatting type of the calculated member.
measure: A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this calculated member is also a calculated measure.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_CalculatedMember">
<xsd:attribute name="measureGroup" type="x:ST_Xstring" use="optional"/>
<xsd:attribute name="numberFormat" type="ST_CalcMemNumberFormat" use="optional" default="default"/>
<xsd:attribute name="measure" type="xsd:boolean" use="optional" default="false"/>
</xsd:complexType>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
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.