Struct DataValidationConfig 

pub struct DataValidationConfig {

    pub sqref: String,
    pub validation_type: ValidationType,
    pub operator: Option<ValidationOperator>,
    pub formula1: Option<String>,
    pub formula2: Option<String>,
    pub allow_blank: bool,
    pub error_style: Option<ErrorStyle>,
    pub error_title: Option<String>,
    pub error_message: Option<String>,
    pub prompt_title: Option<String>,
    pub prompt_message: Option<String>,
    pub show_input_message: bool,
    pub show_error_message: bool,
}

Configuration for a data validation rule.

Fields

sqref: String

The cell range to apply validation to (e.g. “A1:A100”).

validation_type: ValidationType

The type of validation.

operator: Option<ValidationOperator>

The comparison operator (not used for list validations).

formula1: Option<String>

The first formula/value for the validation constraint.

formula2: Option<String>

The second formula/value (used with Between/NotBetween operators).

allow_blank: bool

Whether blank cells are allowed.

error_style: Option<ErrorStyle>

The error display style.

error_title: Option<String>

The title for the error dialog.

error_message: Option<String>

The message for the error dialog.

prompt_title: Option<String>

The title for the input prompt.

prompt_message: Option<String>

The message for the input prompt.

show_input_message: bool

Whether to show the input message when the cell is selected.

show_error_message: bool

Whether to show the error message on invalid input.

Implementations

impl DataValidationConfig

pub fn dropdown(sqref: &str, items: &[&str]) -> Self

Create a dropdown list validation.

The items are joined with commas and quoted for the formula. Individual items must not contain commas (Excel limitation).

pub fn whole_number(sqref: &str, min: i64, max: i64) -> Self

Create a whole number range validation (between min and max).

pub fn decimal(sqref: &str, min: f64, max: f64) -> Self

Create a decimal range validation (between min and max).

pub fn text_length( sqref: &str, operator: ValidationOperator, length: u32, ) -> Self

Create a text length validation.

Trait Implementations

impl Clone for DataValidationConfig

fn clone(&self) -> DataValidationConfig

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DataValidationConfig

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

Formats the value using the given formatter.