Enum ConditionalFormatType 

pub enum ConditionalFormatType {
    CellIs {
        operator: CfOperator,
        formula: String,
        formula2: Option<String>,
    },
    Expression {
        formula: String,
    },
    ColorScale {
        min_type: CfValueType,
        min_value: Option<String>,
        min_color: String,
        mid_type: Option<CfValueType>,
        mid_value: Option<String>,
        mid_color: Option<String>,
        max_type: CfValueType,
        max_value: Option<String>,
        max_color: String,
    },
    DataBar {
        min_type: CfValueType,
        min_value: Option<String>,
        max_type: CfValueType,
        max_value: Option<String>,
        color: String,
        show_value: bool,
    },
    DuplicateValues,
    UniqueValues,
    Top10 {
        rank: u32,
        percent: bool,
    },
    Bottom10 {
        rank: u32,
        percent: bool,
    },
    AboveAverage {
        above: bool,
        equal_average: bool,
    },
    ContainsBlanks,
    NotContainsBlanks,
    ContainsErrors,
    NotContainsErrors,
    ContainsText {
        text: String,
    },
    NotContainsText {
        text: String,
    },
    BeginsWith {
        text: String,
    },
    EndsWith {
        text: String,
    },
}

The type of conditional formatting rule.

Variants

CellIs

Cell value comparison (e.g., greater than, between).

Fields

operator: CfOperator

formula: String

formula2: Option<String>

Optional second formula for Between/NotBetween.

Expression

Formula-based rule.

Fields

formula: String

ColorScale

Color scale (2 or 3 color gradient).

Fields

min_type: CfValueType

min_value: Option<String>

min_color: String

mid_type: Option<CfValueType>

mid_value: Option<String>

mid_color: Option<String>

max_type: CfValueType

max_value: Option<String>

max_color: String

DataBar

Data bar visualization.

Fields

min_type: CfValueType

min_value: Option<String>

max_type: CfValueType

max_value: Option<String>

color: String

show_value: bool

DuplicateValues

Duplicate values.

UniqueValues

Unique values.

Top10

Top N values.

Fields

rank: u32

percent: bool

Bottom10

Bottom N values.

Fields

rank: u32

percent: bool

AboveAverage

Above or below average.

Fields

above: bool

equal_average: bool

ContainsBlanks

Cells that contain blanks.

NotContainsBlanks

Cells that do not contain blanks.

ContainsErrors

Cells that contain errors.

NotContainsErrors

Cells that do not contain errors.

ContainsText

Cells containing specific text.

Fields

text: String

NotContainsText

Cells not containing specific text.

Fields

text: String

BeginsWith

Cells beginning with specific text.

Fields

text: String

EndsWith

Cells ending with specific text.

Fields

text: String

Trait Implementations

impl Clone for ConditionalFormatType

fn clone(&self) -> ConditionalFormatType

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for ConditionalFormatType

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl PartialEq for ConditionalFormatType

fn eq(&self, other: &ConditionalFormatType) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for ConditionalFormatType