Abstract base class which encapsulates the condition for a formatting rule.
Inheritance
object
Classes that extend this class.
Derived ClassesConstructors
Section titled "Constructors"constructor
protected ConditionBase()Returns ConditionBase
Properties
Section titled "Properties"ConditionType
Section titled "ConditionType"Returns a value which identifies the type of condition for this instance.
public FormatConditionType ConditionType { get; }Priority
Section titled "Priority"Returns or sets a value which determines the order of evaluation when multiple conditional formatting rules exist.
public int Priority { get; set; }Regions
Section titled "Regions"Returns the which identifies the cell range with which this condition is associated.
public ReadOnlyCollection<WorksheetRegion> Regions { get; }StopIfTrue
Section titled "StopIfTrue"Returns or sets a boolean indicating whether additional formatting rules are evaluated if this rule evaluates to true. Applicable only in the case where the containing contains more than one element.
public bool StopIfTrue { get; set; }Workbook
Section titled "Workbook"Returns a reference to the associated workbook.
public Workbook Workbook { get; }Worksheet
Section titled "Worksheet"Returns a reference to the associated worksheet.
public Worksheet Worksheet { get; }Methods
Section titled "Methods"SetFirstPriority()
Section titled "SetFirstPriority()"Sets the value for this rule such that it is the first condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated .
public void SetFirstPriority()Returns any
SetLastPriority()
Section titled "SetLastPriority()"Sets the value for this rule such that it is the last condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated .
public void SetLastPriority()Returns any
SetRegions(string, CellReferenceMode?)
Section titled "SetRegions(string, CellReferenceMode?)"Replaces the existing regions with new ones
public void SetRegions(string regionAddress, CellReferenceMode? cellReferenceMode)Parameters
- regionAddress:
string - cellReferenceMode:
CellReferenceMode?