Export (0) Print
Expand All

CalculatedMember class

Defines the CalculatedMember Class.This class is only available in Office2013. When the object is serialized out as xml, its qualified name is x15:calculatedMember.

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Office2013.Excel.CalculatedMember

Namespace:  DocumentFormat.OpenXml.Office2013.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[OfficeAvailabilityAttribute(FileFormatVersions.Office2013)]
public class CalculatedMember : OpenXmlLeafElement

2.4.44 calculatedMember

Target namespace: http://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.<21>

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.93 CT_CalculatedMember

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_CalculatedMemberExt, calculatedMember

This element adds new properties for supporting calculated members.<69>

Attributes:

measureGroup: An 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: An ST_CalcMemNumberFormat (see section 2.7.25) 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).

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

Community Additions

Show:
© 2014 Microsoft