C# 클래스 OfficeOpenXml.ConditionalFormatting.ExcelConditionalFormattingRuleType

Functions related to the ExcelConditionalFormattingRule

공개 메소드들

메소드	설명
GetAttributeByType ( eExcelConditionalFormattingRuleType type ) : string
GetCfvoParentPathByType ( eExcelConditionalFormattingRuleType type ) : string	Return cfvo §18.3.1.11 parent according to the rule type
GetTimePeriodType ( XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType	Get the "timePeriod" rule type according to "TimePeriod" attribute. ///
GetTop10Type ( XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType	Get the "top10" rule type according to the follwoing attributes: "Bottom" and "Percent" @Bottom = "1" and @Percent = "0"/null == Bottom @Bottom = "1" and @Percent = "1" == BottomPercent @Bottom = "0"/null and @Percent = "0"/null == Top @Bottom = "0"/null and @Percent = "1" == TopPercent ///

비공개 메소드들

메소드	설명
GetAboveAverageType ( XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType	Get the "aboveAverage" rule type according to the follwoing attributes: "AboveAverage", "EqualAverage" and "StdDev". @StdDev greater than "0" == AboveStdDev @StdDev less than "0" == BelowStdDev @AboveAverage = "1"/null and @EqualAverage = "0"/null == AboveAverage @AboveAverage = "1"/null and @EqualAverage = "1" == AboveOrEqualAverage @AboveAverage = "0" and @EqualAverage = "0"/null == BelowAverage @AboveAverage = "0" and @EqualAverage = "1" == BelowOrEqualAverage ///
GetCellIs ( XmlElement node ) : eExcelConditionalFormattingRuleType
GetColorScaleType ( XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType	Get the "colorScale" rule type according to the number of "cfvo" and "color" nodes. If we have excatly 2 "cfvo" and "color" childs, then we return "twoColorScale"
GetIconSetType ( XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType
GetTypeByAttrbiute ( string attribute, XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType

메소드 상세

GetAttributeByType() 공개 정적인 메소드

public static GetAttributeByType ( eExcelConditionalFormattingRuleType type ) : string
type	eExcelConditionalFormattingRuleType
리턴	string

GetCfvoParentPathByType() 공개 정적인 메소드

Return cfvo §18.3.1.11 parent according to the rule type

public static GetCfvoParentPathByType ( eExcelConditionalFormattingRuleType type ) : string
type	eExcelConditionalFormattingRuleType
리턴	string

GetTimePeriodType() 공개 정적인 메소드

Get the "timePeriod" rule type according to "TimePeriod" attribute. ///

public static GetTimePeriodType ( XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType
topNode	System.Xml.XmlNode
nameSpaceManager	System.Xml.XmlNamespaceManager
리턴	eExcelConditionalFormattingRuleType

GetTop10Type() 공개 정적인 메소드

Get the "top10" rule type according to the follwoing attributes: "Bottom" and "Percent" @Bottom = "1" and @Percent = "0"/null == Bottom @Bottom = "1" and @Percent = "1" == BottomPercent @Bottom = "0"/null and @Percent = "0"/null == Top @Bottom = "0"/null and @Percent = "1" == TopPercent ///

public static GetTop10Type ( XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : eExcelConditionalFormattingRuleType
topNode	System.Xml.XmlNode
nameSpaceManager	System.Xml.XmlNamespaceManager
리턴	eExcelConditionalFormattingRuleType