API Reference
ExcelConditionalFormattingInfo
Read-only snapshot of a conditional formatting rule.
Inheritance
- Object
- ExcelConditionalFormattingInfo
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 ExcelConditionalFormattingInfo() #Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public String Range { get; set; } #Gets or sets the A1 range covered by the rule.
public String Type { get; set; } #Gets or sets the OpenXML conditional formatting type.
public String Operator { get; set; } #Gets or sets the OpenXML conditional formatting operator.
public String Text { get; set; } #Gets or sets the text payload attached to a text conditional-formatting rule.
public String TimePeriod { get; set; } #Gets or sets the relative time period attached to a time-period conditional-formatting rule.
public Int32 Priority { get; set; } #Gets or sets the rule priority.
public Boolean StopIfTrue { get; set; } #Gets or sets whether evaluation stops when the rule is true.
public Nullable<UInt32> DifferentialFormatId { get; set; } #Gets or sets the differential format id attached to the rule, when present.
public String DifferentialFillColorArgb { get; set; } #Gets or sets the resolved ARGB fill color from the rule's differential format, when present.
public String DifferentialFontColorArgb { get; set; } #Gets or sets the resolved ARGB font color from the rule's differential format, when present.
public Nullable<Boolean> DifferentialFontBold { get; set; } #Gets or sets whether the rule's differential format requests bold text, when present.
public Nullable<Boolean> DifferentialFontItalic { get; set; } #Gets or sets whether the rule's differential format requests italic text, when present.
public Nullable<Boolean> DifferentialFontUnderline { get; set; } #Gets or sets whether the rule's differential format requests underlined text, when present.
public String DifferentialFontName { get; set; } #Gets or sets the rule's differential format font family, when present.
public Nullable<Double> DifferentialFontSize { get; set; } #Gets or sets the rule's differential format font size in points, when present.
public ExcelCellBorderSnapshot DifferentialBorder { get; set; } #Gets or sets the rule's differential format border, when present.
public IReadOnlyList<String> Formulas { get; set; } #Gets or sets formulas attached to the rule.
public IReadOnlyList<String> ColorScaleColors { get; set; } #Gets or sets ARGB colors attached to a color-scale rule, in rule order.
public IReadOnlyList<ExcelConditionalFormatThreshold> ColorScaleThresholds { get; set; } #Gets or sets color-scale thresholds in rule order.
public String DataBarColor { get; set; } #Gets or sets the ARGB color attached to a data-bar rule.
public IReadOnlyList<ExcelConditionalFormatThreshold> DataBarThresholds { get; set; } #Gets or sets data-bar thresholds in rule order.
public Boolean DataBarShowValue { get; set; } #Gets or sets whether the data-bar rule displays the underlying cell value.
public String IconSet { get; set; } #Gets or sets the icon-set name attached to an icon-set rule.
public Boolean IconSetShowValue { get; set; } #Gets or sets whether the icon-set rule displays the underlying cell value.
public Boolean IconSetReverse { get; set; } #Gets or sets whether the icon-set rule reverses icon order.
public IReadOnlyList<ExcelConditionalIconSetThreshold> IconSetThresholds { get; set; } #Gets or sets icon-set thresholds in rule order.
public Nullable<UInt32> TopBottomRank { get; set; } #Gets or sets the top/bottom rule rank, when present.
public Boolean TopBottomBottom { get; set; } #Gets or sets whether the top/bottom rule selects bottom values.
public Boolean TopBottomPercent { get; set; } #Gets or sets whether the top/bottom rule rank is a percentage.
public Boolean AboveAverageAbove { get; set; } #Gets or sets whether the above-average rule selects values above the average.
public Boolean AboveAverageEqual { get; set; } #Gets or sets whether the above-average rule includes values equal to the average.
public Nullable<Int32> AboveAverageStdDev { get; set; } #Gets or sets the standard-deviation threshold for above-average rules, when present.