API Reference
LegacyXlsConditionalFormatting
Represents a conditional formatting rule parsed from a legacy BIFF worksheet.
Inheritance
- Object
- LegacyXlsConditionalFormatting
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
Constructors
public LegacyXlsConditionalFormatting(LegacyXlsConditionalFormattingType type, Nullable<LegacyXlsConditionalFormattingOperator> operator, String formula1, String formula2, IReadOnlyList<String> ranges, Nullable<Int32> priority = null, Boolean stopIfTrue = false) #Creates a parsed legacy XLS conditional formatting rule.
Parameters
- type OfficeIMO.Excel.LegacyXls.Model.LegacyXlsConditionalFormattingType
- operator System.Nullable{OfficeIMO.Excel.LegacyXls.Model.LegacyXlsConditionalFormattingOperator}
- formula1 System.String
- formula2 System.String
- ranges System.Collections.Generic.IReadOnlyList{System.String}
- priority System.Nullable{System.Int32} = null
- stopIfTrue System.Boolean = false
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public LegacyXlsConditionalFormattingType Type { get; } #Gets the legacy conditional formatting rule type.
public Nullable<LegacyXlsConditionalFormattingOperator> Operator { get; } #Gets the comparison operator for cell-is rules.
public String Formula1 { get; } #Gets the first formula, normalized for Open XML projection.
public String Formula2 { get; } #Gets the second formula, when required by the operator.
public IReadOnlyList<String> Ranges { get; } #Gets the A1 ranges covered by this conditional formatting rule.
public Int32 RangeCount { get; } #Gets the number of A1 ranges covered by this conditional formatting rule.
public Nullable<Int32> Priority { get; set; } #Gets the evaluation priority supplied by a conditional-formatting extension record, when present.
public Boolean StopIfTrue { get; set; } #Gets whether lower-priority rules should stop when this rule evaluates to true.
public LegacyXlsDifferentialFormat DifferentialFormat { get; set; } #Gets the differential format associated with this rule, when a supported style extension was decoded.