C# Class OfficeOpenXml.ConditionalFormatting.ExcelConditionalFormattingRuleType

Functions related to the ExcelConditionalFormattingRule
Afficher le fichier Open project: pruiz/EPPlus Class Usage Examples

Méthodes publiques

Méthode Description
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 ///

Private Methods

Méthode Description
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

Method Details

GetAttributeByType() public static méthode

public static GetAttributeByType ( eExcelConditionalFormattingRuleType type ) : string
type eExcelConditionalFormattingRuleType
Résultat string

GetCfvoParentPathByType() public static méthode

Return cfvo §18.3.1.11 parent according to the rule type
public static GetCfvoParentPathByType ( eExcelConditionalFormattingRuleType type ) : string
type eExcelConditionalFormattingRuleType
Résultat string

GetTimePeriodType() public static méthode

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
Résultat eExcelConditionalFormattingRuleType

GetTop10Type() public static méthode

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
Résultat eExcelConditionalFormattingRuleType