C# Class OfficeOpenXml.ConditionalFormatting.ExcelConditionalFormattingValueObject

18.3.1.11 cfvo (Conditional Format Value Object) Describes the values of the interpolation points in a gradient scale.
Inheritance: XmlHelper
显示文件 Open project: ylatuya/EPPlus Class Usage Examples

Private Properties

Property Type Description
CreateNodeByOrdem void
ExcelConditionalFormattingValueObject System
ExcelConditionalFormattingValueObject System
ExcelConditionalFormattingValueObject System
GetNodeOrder int

Private Methods

Method Description
CreateNodeByOrdem ( eExcelConditionalFormattingValueObjectNodeType nodeType, string attributePath, string attributeValue ) : void

Create the 'cfvo'/'color' nodes in the right order. They should appear like this: "cfvo" --> Low Value (value object) "cfvo" --> Middle Value (value object) "cfvo" --> High Value (value object) "color" --> Low Value (color) "color" --> Middle Value (color) "color" --> High Value (color)

ExcelConditionalFormattingValueObject ( eExcelConditionalFormattingValueObjectPosition position, eExcelConditionalFormattingValueObjectType type, Color color, double value, string formula, eExcelConditionalFormattingRuleType ruleType, ExcelAddress address, int priority, ExcelWorksheet worksheet, XmlNamespaceManager namespaceManager ) : System

Initialize the ExcelConditionalFormattingValueObject

ExcelConditionalFormattingValueObject ( eExcelConditionalFormattingValueObjectPosition position, eExcelConditionalFormattingValueObjectType type, Color color, double value, string formula, eExcelConditionalFormattingRuleType ruleType, ExcelAddress address, int priority, ExcelWorksheet worksheet, XmlNode itemElementNode, XmlNamespaceManager namespaceManager ) : System

Initialize the cfvo (§18.3.1.11) node

ExcelConditionalFormattingValueObject ( eExcelConditionalFormattingValueObjectPosition position, eExcelConditionalFormattingValueObjectType type, Color color, eExcelConditionalFormattingRuleType ruleType, ExcelAddress address, int priority, ExcelWorksheet worksheet, XmlNamespaceManager namespaceManager ) : System

Initialize the ExcelConditionalFormattingValueObject

GetNodeOrder ( ) : int

Get the node order (1, 2 ou 3) according to the Position (Low, Middle and High) and the Rule Type (TwoColorScale ou ThreeColorScale).