Struct spreadsheet_ods::condition::ValueCondition

pub struct ValueCondition { /* private fields */ }

Defines a condition that compares the cell-content with a value.

Implementations

impl ValueCondition

pub fn value_eq<V: Into<Value>>(value: V) -> ValueCondition

Compares the cell-content with a value.

pub fn value_ne<V: Into<Value>>(value: V) -> ValueCondition

Compares the cell-content with a value.

pub fn value_lt<V: Into<Value>>(value: V) -> ValueCondition

Compares the cell-content with a value.

pub fn value_gt<V: Into<Value>>(value: V) -> ValueCondition

Compares the cell-content with a value.

pub fn value_le<V: Into<Value>>(value: V) -> ValueCondition

Compares the cell-content with a value.

pub fn value_ge<V: Into<Value>>(value: V) -> ValueCondition

Compares the cell-content with a value.

Examples found in repository

examples/negative_number_red.rs (line 30)

pub fn main() -> Result<(), OdsError> {
    let mut wb = WorkBook::new(locale!("de_AT"));

    // positive format
    let mut f_number = ValueFormatNumber::new_localized("num0", locale!("de_AT"));
    f_number
        .part_number()
        .decimal_places(2)
        .min_integer_digits(1)
        .grouping()
        .build();
    let f_number = wb.add_number_format(f_number);

    // negative format
    let mut f_number_red = ValueFormatNumber::new_localized("num0red", locale!("de_AT"));
    f_number_red.part_text("-").build();
    f_number_red
        .part_number()
        .decimal_places(2)
        .min_integer_digits(1)
        .grouping()
        .build();
    f_number_red.set_color(Rgb::new(255, 0, 0));
    f_number_red.push_stylemap(ValueStyleMap::new(ValueCondition::value_ge(0), f_number));
    let f_number_red = wb.add_number_format(f_number_red);

    // cellstyle for this number format
    let s_number = CellStyle::new("num_red", &f_number_red);
    let s_number = wb.add_cellstyle(s_number);

    // ...

    let mut sheet = Sheet::new("sample");

    sheet.set_styled_value(0, 0, 723, &s_number);
    sheet.set_styled_value(1, 0, -723, &s_number);

    wb.push_sheet(sheet);

    write_ods(&mut wb, "examples/neg.ods")?;

    Ok(())
}

Trait Implementations

impl Clone for ValueCondition

fn clone(&self) -> ValueCondition

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for ValueCondition

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

Formats the value using the given formatter.

impl Display for ValueCondition

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

Formats the value using the given formatter.