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.