FormatCondition Class

FormatCondition class

Represents conditional formatting condition.


type FormatCondition struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
GetFormula1_Bool_BoolGets the value or expression associated with this format condition.
GetFormula2_Bool_BoolGets the value or expression associated with this format condition.
GetFormula1_Bool_Bool_Int_IntGets the value or expression of the conditional formatting of the cell.
GetFormula2_Bool_Bool_Int_IntGets the value or expression of the conditional formatting of the cell.
SetFormulasSets the value or expression associated with this format condition.
SetFormula1_String_Bool_BoolSets the value or expression associated with this format condition.
SetFormula2_String_Bool_BoolSets the value or expression associated with this format condition.
GetFormula1Gets and sets the value or expression associated with conditional formatting.
SetFormula1_StringGets and sets the value or expression associated with conditional formatting.
GetFormula1_Int_IntGets the formula of the conditional formatting of the cell.
GetFormula2Gets and sets the value or expression associated with conditional formatting.
SetFormula2_StringGets and sets the value or expression associated with conditional formatting.
GetFormula2_Int_IntGets the formula of the conditional formatting of the cell.
GetOperatorGets and sets the conditional format operator type.
SetOperatorGets and sets the conditional format operator type.
GetStopIfTrueTrue, no rules with lower priority may be applied over this rule, when this rule evaluates to true.Only applies for Excel 2007;
SetStopIfTrueTrue, no rules with lower priority may be applied over this rule, when this rule evaluates to true.Only applies for Excel 2007;
GetPriorityThe priority of this conditional formatting rule. This value is used to determine whichformat should be evaluated and rendered. Lower numeric values are higher priority thanhigher numeric values, where ‘1’ is the highest priority.
SetPriorityThe priority of this conditional formatting rule. This value is used to determine whichformat should be evaluated and rendered. Lower numeric values are higher priority thanhigher numeric values, where ‘1’ is the highest priority.
GetStyleGets or setts style of conditional formatted cell ranges.
SetStyleGets or setts style of conditional formatted cell ranges.
GetTypeGets and sets whether the conditional format Type.
SetTypeGets and sets whether the conditional format Type.
GetIconSetGet the conditional formatting’s “IconSet” instance.The default instance’s IconSetType is TrafficLights31.Valid only for type = IconSet.
GetDataBarGet the conditional formatting’s “DataBar” instance.The default instance’s color is blue.Valid only for type is DataBar.
GetColorScaleGet the conditional formatting’s “ColorScale” instance.The default instance is a “green-yellow-red” 3ColorScale .Valid only for type = ColorScale.
GetTop10Get the conditional formatting’s “Top10” instance.The default instance’s rule highlights cells whosevalues fall in the top 10 bracket.Valid only for type is Top10.
GetAboveAverageGet the conditional formatting’s “AboveAverage” instance.The default instance’s rule highlights cells that areabove the average for all values in the range.Valid only for type = AboveAverage.
GetTextThe text value in a “text contains” conditional formatting rule.Valid only for type = containsText, notContainsText, beginsWith and endsWith.The default value is null.
SetTextThe text value in a “text contains” conditional formatting rule.Valid only for type = containsText, notContainsText, beginsWith and endsWith.The default value is null.
GetTimePeriodThe applicable time period in a “date occurring…” conditional formatting rule.Valid only for type = timePeriod.The default value is TimePeriodType.Today.
SetTimePeriodThe applicable time period in a “date occurring…” conditional formatting rule.Valid only for type = timePeriod.The default value is TimePeriodType.Today.