Struct DataValidation 

pub struct DataValidation {

    pub allow_blank: bool,
    pub error: Option<String>,
    pub error_style: Option<String>,
    pub error_title: Option<String>,
    pub operator: String,
    pub prompt: Option<String>,
    pub prompt_title: Option<String>,
    pub show_drop_down: bool,
    pub show_error_message: bool,
    pub show_input_message: bool,
    pub sqref: String,
    pub type: String,
    pub formula1: String,
    pub formula2: String,
}

Data validation rule settings.

Fields

allow_blank: bool

error: Option<String>

error_style: Option<String>

error_title: Option<String>

operator: String

prompt: Option<String>

prompt_title: Option<String>

show_drop_down: bool

show_error_message: bool

show_input_message: bool

sqref: String

type: String

formula1: String

formula2: String

Implementations

impl DataValidation

pub fn set_error( &mut self, style: DataValidationErrorStyle, title: &str, msg: &str, )

Set the error alert for this data validation rule.

pub fn set_input(&mut self, title: &str, msg: &str)

Set the input prompt for this data validation rule.

pub fn set_drop_list(&mut self, keys: &[&str]) -> Result<()>

Set a fixed drop-down list.

pub fn set_range( &mut self, f1: DataValidationValue, f2: DataValidationValue, t: DataValidationType, o: DataValidationOperator, ) -> Result<()>

Set a numeric range validation.

pub fn set_sqref_drop_list(&mut self, sqref: &str)

Set a drop-down list backed by a worksheet range reference.

pub fn set_sqref(&mut self, sqref: &str)

Append a cell reference sequence to this rule’s sqref.

Trait Implementations

impl Clone for DataValidation

fn clone(&self) -> DataValidation

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DataValidation

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

Formats the value using the given formatter.

impl Default for DataValidation

fn default() -> DataValidation

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for DataValidation

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Eq for DataValidation

impl PartialEq for DataValidation

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

Equality operator ==.

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

Inequality operator !=.

impl Serialize for DataValidation

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for DataValidation