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