Enum ValidationType

pub enum ValidationType {
    Integer(Criterion<i64>),
    IntegerFormula(Criterion<String>),
    Decimal(Criterion<f64>),
    DecimalFormula(Criterion<String>),
    List {
        values: IndexSet<String>,
        show_dropdown: bool,
    },
    ListFormula {
        formula: String,
        show_dropdown: bool,
    },
    Date(Criterion<DateTime<Utc>>),
    DateFormula(Criterion<String>),
    DateNumber(Criterion<i64>),
    Time(Criterion<NaiveTime>),
    TimeFormula(Criterion<String>),
    TimeNumber(Criterion<f64>),
    Length(Criterion<usize>),
    LengthFormula(Criterion<String>),
    CustomFormula(String),
    Any,
}

Variants

Integer(Criterion<i64>)

Restrict cell input to whole/integer numbers only.

IntegerFormula(Criterion<String>)

Restrict cell input to whole/integer numbers only, using a cell reference.

Decimal(Criterion<f64>)

Restrict cell input to decimal numbers only.

DecimalFormula(Criterion<String>)

Restrict cell input to decimal numbers only, using a cell reference.

List

Restrict cell input to a list of strings in a dropdown.

Fields

values: IndexSet<String>

The list of allowed values.

show_dropdown: bool

Show the drop-down.

ListFormula

Restrict cell input to a list of strings in a dropdown, using a cell range.

Fields

formula: String

A formula that yields the list of allowed values.

show_dropdown: bool

Show the drop-down.

Date(Criterion<DateTime<Utc>>)

Restrict cell input to date values only.

DateFormula(Criterion<String>)

Restrict cell input to date values only, using a cell reference.

DateNumber(Criterion<i64>)

Restrict cell input to date values only, as a serial number. Undocumented.

Time(Criterion<NaiveTime>)

Restrict cell input to time values only.

TimeFormula(Criterion<String>)

Restrict cell input to time values only, using a cell reference.

TimeNumber(Criterion<f64>)

Restrict cell input to time values only, as a serial number. Undocumented.

Length(Criterion<usize>)

Restrict cell input to strings of defined length.

LengthFormula(Criterion<String>)

Restrict cell input to strings of defined length, using a cell reference.

CustomFormula(String)

Restrict cell to input controlled by a custom formula that returns a boolean value.

Any

Allow any type of input. Mainly only useful for pop-up messages.