spreadsheet-ods 1.0.4

Read and write ODS files
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

//!
//!
//!

use color::Rgb;
use icu_locale_core::locale;
use spreadsheet_ods::condition::ValueCondition;
use spreadsheet_ods::format::{ValueFormatTrait, ValueStyleMap};
use spreadsheet_ods::*;
use std::fs;

///
pub fn main() -> Result<(), OdsError> {
    let _ = fs::create_dir_all("examples_out");

    negative_numbers_red()?;

    Ok(())
}

fn negative_numbers_red() -> OdsResult<()> {
    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_out/neg.ods")?;

    Ok(())
}