Share via

2.6.212 CT_NsvFilter

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2019/namedsheetviews

Referenced by: CT_NamedSheetView

This complex type specifies the sort and/or filter criteria to be applied to a single AutoFilter.

Child Elements:

columnFilter: A CT_ColumnFilter element that specifies filter criteria to apply to a specific column in the AutoFilter.

sortRules: A CT_SortRules element that specifies the sort criteria to apply to the AutoFilter.

extLst: A CT_ExtensionList ([ISO/IEC29500-1:2016] section A.2) that specifies future extensibility for this element.

Attributes:

filterId: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies the unique id of the AutoFilter object this element applies to.  The value of this attribute SHOULD match a uid (section 2.5.10) attribute stored on the CT_AutoFilter ([ISO/IEC29500-1:2016] section A.2) that describes the AutoFilter associated with this element. 

Use of this attribute during load is described in section 2.3.8.2.

ref: An ST_Ref ([ISO/IEC29500-1:2016] section 18.18.62) attribute that specifies the location of the AutoFilter object that this element applies to.  The value of this attribute SHOULD match the ref attribute on the CT_AutoFilter ([ISO/IEC29500-1:2016] section A.2) that describes the AutoFilter associated with this element. 

This attribute is currently unused.

tableId: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the id of the table that contains the AutoFilter associated with this element.

If the AutoFilter is table owned (as explained in section 2.3.8.1) then this value SHOULD match the id attribute on the CT_Table ([ISO/IEC29500-1:2016] section A.2) element that describes the owning table. 

If the AutoFilter is worksheet owned (as explained in section 2.3.8.1) then this value SHOULD be 0.

Use of this attribute during load is described in section 2.3.8.2

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

 <xsd:complexType name="CT_NsvFilter">
   <xsd:sequence>
     <xsd:element name="columnFilter" minOccurs="0" maxOccurs="unbounded" type="CT_ColumnFilter"/>
     <xsd:element name="sortRules" minOccurs="0" maxOccurs="1" type="CT_SortRules"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="filterId" type="x:ST_Guid" use="required"/>
   <xsd:attribute name="ref" type="x:ST_Ref" use="optional"/>
   <xsd:attribute name="tableId" type="xsd:unsignedInt" use="optional"/>
 </xsd:complexType>

See section 5.26 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).