Spread Windows Forms 17
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