Enum DataValidationKind 

pub enum DataValidationKind {
    List {
        source: String,
    },
    WholeNumber {
        operator: ComparisonOperator,
        formula1: String,
        formula2: Option<String>,
    },
    Decimal {
        operator: ComparisonOperator,
        formula1: String,
        formula2: Option<String>,
    },
    Date {
        operator: ComparisonOperator,
        formula1: String,
        formula2: Option<String>,
    },
    Time {
        operator: ComparisonOperator,
        formula1: String,
        formula2: Option<String>,
    },
    TextLength {
        operator: ComparisonOperator,
        formula1: String,
        formula2: Option<String>,
    },
    Custom {
        formula: String,
    },
}

The validation performed by a DataValidationRule.

Variants

List

type="list": the cell’s value must match one entry from a fixed list — Excel shows a dropdown. source is written verbatim as formula1, so it can be either a literal comma-separated list wrapped in quotes (e.g. "\"Yes,No,Maybe\"") or a reference to a range holding the valid values (e.g. "$D$1:$D$3").

Fields

source: String

WholeNumber

type="whole": the cell’s value must be a whole number satisfying operator against formula1 (and formula2, for Between/ NotBetween).

Fields

operator: ComparisonOperator

formula1: String

formula2: Option<String>

Decimal

type="decimal": like WholeNumber, but the value may have a fractional part.

Fields

operator: ComparisonOperator

formula1: String

formula2: Option<String>

Date

type="date": the cell’s value must be a date satisfying operator against formula1/formula2. formula1/formula2 are written verbatim, so the caller is responsible for passing an Excel date serial number (as text, e.g. "45000") or a date-returning formula — same “storage, not a conversion helper” posture as everywhere else formula text is stored in this crate; see crate::ExcelDateTime plus writer.rs::excel_serial_date if a caller needs to compute one.

Fields

operator: ComparisonOperator

formula1: String

formula2: Option<String>

Time

type="time": like Date, but for a time-of-day value (a fractional day, e.g. "0.5" for noon).

Fields

operator: ComparisonOperator

formula1: String

formula2: Option<String>

TextLength

type="textLength": the cell’s text length must satisfy operator against formula1/formula2.

Fields

operator: ComparisonOperator

formula1: String

formula2: Option<String>

Custom

type="custom": an arbitrary formula, evaluated per cell, the value is valid when it evaluates to TRUE — no operator, unlike every other variant.

Fields

formula: String

Trait Implementations

impl Clone for DataValidationKind

fn clone(&self) -> DataValidationKind

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DataValidationKind

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

Formats the value using the given formatter.

impl PartialEq for DataValidationKind

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

Equality operator ==.

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

Inequality operator !=.

impl StructuralPartialEq for DataValidationKind