Share via


CategoryFilterException class

Defines the CategoryFilterException Class.This class is only available in O15. When the object is serialized out as xml, its qualified name is c15:categoryFilterException.

Inheritance hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office15.Drawing.Chart.CategoryFilterException

Namespace:  DocumentFormat.OpenXml.Office15.Drawing.Chart
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(Explosion), FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(SequenceOfReferences), FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(ShapeProperties), FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(InvertIfNegativeBoolean), FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(Bubble3D), FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(Marker), FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(DataLabel), FileFormatVersions.Office15)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office15)> _
Public Class CategoryFilterException _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As CategoryFilterException
[ChildElementInfoAttribute(typeof(Explosion), FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(SequenceOfReferences), FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(ShapeProperties), FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(InvertIfNegativeBoolean), FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(Bubble3D), FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(Marker), FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(DataLabel), FileFormatVersions.Office15)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office15)]
public class CategoryFilterException : OpenXmlCompositeElement

Remarks

2.5.103 CT_CategoryFilterException

Target namespace: https://schemas.microsoft.com/office/drawing/2012/chart

Referenced by: CT_CategoryFilterExceptions

CT_CategoryFilterException is a complex type that contains information about special formatting properties associated with a single data point in a chart series ([ISO/IEC-29500-1] section 21.2). This type is used to save special data point properties of points that are filtered out of the chart series ([ISO/IEC-29500-1] section 21.2). An entry of this type MUST contain exactly one sqref element followed by one or more child elements.

Child Elements:

sqref: A string ([XMLSCHEMA2] section 3.2.1) element that specifies the cell reference of the data corresponding to this data point in the chart series ([ISO/IEC-29500-1] section 21.2). This element is required.

spPr: A CT_ShapeProperties ([ISO/IEC-29500-1] section A.4.1) element that specifies the formatting (like fill or line properties) to be shown on this data point.

explosion: A CT_UnsignedInt ([ISO/IEC-29500-1] section A.5.1) element that specifies the amount this data point shall be moved from the center of the pie in a pie chart series.

invertIfNegative: A CT_Boolean ([MS-ODRAWXML] section 2.5.83) element that specifies if the invert color should be shown when this data point has a negative value.

bubble3D: A CT_Boolean ([MS-ODRAWXML] section 2.5.83) element that specifies if this data point has a 3D bubble.

marker: A CT_Marker ([ISO/IEC-29500-1] section A.5.1) element that specifies the properties of the line marker associated with this data point.

dLbl: A CT_DLbl ([ISO/IEC-29500-1] section A.5.1) element that specifies the properties of the datalabel associated with this data point.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_CategoryFilterException">

<xsd:sequence>

<xsd:element name="sqref" type="xsd:string" minOccurs="1" maxOccurs="1"/>

<xsd:element name="spPr" type="a:CT_ShapeProperties" minOccurs="0" maxOccurs="1"/>

<xsd:element name="explosion" type="c:CT_UnsignedInt" minOccurs="0" maxOccurs="1"/>

<xsd:element name="invertIfNegative" type="c:CT_Boolean" minOccurs="0" maxOccurs="1"/>

<xsd:element name="bubble3D" type="c:CT_Boolean" minOccurs="0" maxOccurs="1"/>

<xsd:element name="marker" type="c:CT_Marker" minOccurs="0" maxOccurs="1"/>

<xsd:element name="dLbl" type="c:CT_DLbl" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

</xsd:complexType>

See section 5.14 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.

See also

Reference

CategoryFilterException members

DocumentFormat.OpenXml.Office15.Drawing.Chart namespace