ColorFilter Class
Color Filter Criteria.When the object is serialized out as xml, its qualified name is x:colorFilter.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Spreadsheet.ColorFilter
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'宣言
Public Class ColorFilter _
Inherits OpenXmlLeafElement
'使用
Dim instance As ColorFilter
public class ColorFilter : OpenXmlLeafElement
Remarks
[ISO/IEC 29500-1 初版]
18.3.2.1 colorFilter (Color Filter Criteria)
This element specifies the color to filter by and whether to use the cell's fill or font color in the filter criteria. If the cell's font or fill color does not match the color specified in the criteria, the rows corresponding to those cells are hidden from view.
[Example:
<filterColumn colId="1">
<colorFilter dxfId="0" cellColor="0"/>
</filterColumn>
end example]
Parent Elements |
|---|
filterColumn (§18.3.2.7) |
Attributes |
Description |
|---|---|
cellColor (Filter By Cell Color) |
Flag indicating whether or not to filter by the cell's fill color. '1' indicates to filter by cell fill. '0' indicates to filter by the cell's font color. For rich text in cells, if the color specified appears in the cell at all, it shall be included in the filter. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
dxfId (Differential Format Record Id) |
Id of differential format record (dxf) in the Styles Part which expresses the color value to filter by. The possible values for this attribute are defined by the ST_DxfId simple type (§18.18.25). |
[Note: The W3C XML Schema definition of this element's content model (CT_ColorFilter) is located in §A.2. end note]
© ISO/IEC29500: 2008. 上記の引用はマイクロソフト (またはその代理) によって英語から日本語に翻訳されたものであり、ISO はこうした翻訳に対する責任を一切負いません。
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.