Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / DatabarCfRule Class
Properties Methods


In This Topic
DatabarCfRule Class Members
In This Topic

The following tables list the members exposed by DatabarCfRule.

Public Constructors
 NameDescription
Public ConstructorDatabarCfRule ConstructorInitializes a new instance of the DatabarCfRule class.  
Top
Public Properties
 NameDescription
Public PropertyAxisColorGets or sets the axis color of the data bar.  
Public PropertyAxisPositionGets or sets the axis position for the data bar.  
Public PropertyBorderColorGets or sets the border color of the data bar.  
Public PropertyDirectionGets or sets the direction of the data bar.  
Public PropertyFillColorGets or sets the fill color of the data bar.  
Public PropertyGradientGets or sets a value indicating whether the DatabarCfRule has a gradient fill.  
Public PropertyMaxLengthGets or sets an integer value which indicates the length of the longest data bar in this conditional formatting range, expressed as a percentage of the width of the cell being formatted  
Public PropertyMinLengthGets or sets an integer value which indicates the length of the shortest data bar in this conditional formatting range, expressed as a percentage of the width of the cell containing the data bar.  
Public PropertyNegativeBorderColorGets or sets the negative border color of the data bar.  
Public PropertyNegativeFillColorGets or sets the negative fill color of the data bar.  
Public PropertyPriorityGets or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet. (Inherited from GrapeCity.Spreadsheet.Conditional.ConditionalItem)
Public PropertyShowBorderGets or sets a value indicating whether the data bar has a border.  
Public PropertyShowValueGets or sets a value indicating whether the cells in the conditional formatting range display both the data bar and the numeric value or only the data bar.  
Public PropertyStopIfTrueGets a value indicating whether all next rules will be suspended if this rule is applied. (Inherited from GrapeCity.Spreadsheet.CfRule)
Public PropertyUseNegativeBorderColorGets or sets a value that indicates whether the negative border color is used to paint the border for the negative value.  
Public PropertyUseNegativeFillColorGets or sets a value that indicates whether the negative fill color is used to paint the negative value.  
Public PropertyValuesCountGets the total count of conditional formatting values(s). (Inherited from GrapeCity.Spreadsheet.BuiltInCfRule)
Top
Protected Properties
 NameDescription
Protected PropertyMaxValuesCountOverridden. Gets the maximum values this CfRule can supports.  
Top
Public Methods
 NameDescription
Public MethodAutoGenerateValuesOverridden. Generates conditional formatting value(s) of this CfRule automatically.  
Public MethodDecreasePriorityDecreases the priority of CfRule rule. (Inherited from GrapeCity.Spreadsheet.CfRule)
Public MethodDeleteRemoves this CfRule rule from worksheet. (Inherited from GrapeCity.Spreadsheet.CfRule)
Public MethodGetValueGets a conditional formatting value at the specified index. (Inherited from GrapeCity.Spreadsheet.BuiltInCfRule)
Public MethodIncreasePriorityIncreases the priority of CfRule rule. (Inherited from GrapeCity.Spreadsheet.CfRule)
Public MethodReplaceWithReplaces this CfRule rule with the specified CfRule rule. (Inherited from GrapeCity.Spreadsheet.CfRule)
Public MethodSetFirstPrioritySets the priority of CfRule rule as highest. (Inherited from GrapeCity.Spreadsheet.CfRule)
Public MethodSetLastPrioritySets the priority of CfRule rule as lowest. (Inherited from GrapeCity.Spreadsheet.CfRule)
Public MethodSetValueOverridden. Sets the conditional formatting value.  
Top
See Also

Reference

DatabarCfRule Class
GrapeCity.Spreadsheet Namespace

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page