[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.CfRule

CfRule Class

Represents a conditional formatting rule.

Inheritance
ConditionalItem
ConditionalObjects<CfRule, ConditionalFormatting, CfExecutedResult>.ConditionalItem
CfRule
Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public abstract class CfRule : ConditionalObjects<CfRule, ConditionalFormatting, CfExecutedResult>.ConditionalItem
Public MustInherit Class CfRule
    Inherits ConditionalObjects(Of CfRule, ConditionalFormatting, CfExecutedResult).ConditionalItem

Constructors

Name Description
CfRule(CfRule, FormulaEngine, FormulaEngine)

Initializes a new instance of the CfRule class.

CfRule(bool)

Initializes a new instance of the CfRule class.

Properties

Name Description
MaxValuesCount

Gets the maximum values this CfRule can supports.

StopIfTrue

Gets a value indicating whether all next rules will be suspended if this rule is applied.

ValuesCount

Gets the total count of conditional formatting values(s).

Methods

Name Description
Apply(ref MatchData, ref CfExecutedResult)

Applies the format of this conditional formatting rule to the format result.

ApplyFormat(ref MatchData, ref StyleFormat)

Applies the format of this conditional formatting rule to the format result.

AutoGenerateValues()

Generates conditional formatting value(s) of this CfRule automatically.

CanProcessEmptyValue()

Determines whether this rule is able to process empty value.

DecreasePriority()

Decreases the priority of CfRule rule.

Delete()

Removes this CfRule rule from worksheet.

GetValue(int)

Gets a conditional formatting value at the specified index.

IncreasePriority()

Increases the priority of CfRule rule.

IsMatched(MatchData)

Determines whether the cell value is matched conditions of this rule.

ReplaceWith(CfRule)

Replaces this CfRule rule with the specified CfRule rule.

SetFirstPriority()

Sets the priority of CfRule rule as highest.

SetLastPriority()

Sets the priority of CfRule rule as lowest.

SetValue(int, CfValue)

Sets the conditional formatting value.