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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131

//! show some features of sheets
use color::Rgb;
use icu_locale_core::locale;
use spreadsheet_ods::style::units::{Border, Margin, PrintCentering};
use spreadsheet_ods::style::{HeaderFooter, MasterPage, PageStyle, TableStyle};
use spreadsheet_ods::text::{
    MetaAuthorName, MetaDate, MetaPageCount, MetaPageNumber, MetaTime, TextP, TextS,
};
use spreadsheet_ods::{cm, pt, write_ods, CellRange, OdsResult, Sheet, WorkBook};

///
pub fn main() -> OdsResult<()> {
    printing()?;
    cell_grid()?;

    Ok(())
}

// visual stuff with a sheet
fn cell_grid() -> OdsResult<()> {
    let mut wb = WorkBook::new(locale!("de-AT"));

    let mut sh = Sheet::new("grouping");
    sheet_data(&mut sh);

    // widths
    sh.set_col_width(0, cm!(0.55));
    sh.set_col_width(1, cm!(0.90));
    sh.set_col_width(2, cm!(1.48));
    sh.set_col_width(3, cm!(2.44));
    sh.set_col_width(4, cm!(4));

    // hide grid
    sh.config_mut().show_grid = false;

    // groups
    sh.add_col_group(1, 2);
    sh.add_col_group(3, 4);

    // split header
    sh.split_row_header(1);

    // spans
    sh.set_col_span(0, 0, 5);

    wb.push_sheet(sh);

    write_ods(&mut wb, "examples_out/visual.ods")?;

    Ok(())
}

// print ranges & headers & footers
fn printing() -> OdsResult<()> {
    let mut wb = WorkBook::new(locale!("de-AT"));

    // page styling
    let mut s_page = PageStyle::new("one");
    s_page.set_table_centering(PrintCentering::Both);
    s_page.set_margin(Margin::Length(cm!(1)));
    s_page.set_border(pt!(1), Border::Dotted, Rgb::new(0, 0, 0));

    let s_footer = s_page.footerstyle_mut();
    s_footer.set_background_color(Rgb::new(248, 128, 128));
    // seems to have no effect
    s_footer.set_dynamic_spacing(false);
    // works!
    s_footer.set_min_height(cm!(0.7));
    // has no effect
    // s_footer.set_height(cm!(2));
    s_footer.set_margin(Margin::Length(cm!(0)));
    let s_page = wb.add_pagestyle(s_page);

    // header/footer data
    let mut m_page = MasterPage::new("one");
    m_page.set_pagestyle(&s_page);

    let mut m_footer = HeaderFooter::new();
    m_footer.add_left(TextP::new().tag(MetaAuthorName::new()).into_xmltag());
    m_footer.add_center(
        TextP::new()
            .tag(MetaPageNumber::new())
            .tag(TextS::new())
            .text("/")
            .tag(TextS::new())
            .tag(MetaPageCount::new())
            .into_xmltag(),
    );
    m_footer.add_right(
        TextP::new()
            .tag(MetaDate::new())
            .tag(TextS::new())
            .tag(MetaTime::new())
            .into_xmltag(),
    );
    m_page.set_footer(m_footer);
    let m_page = wb.add_masterpage(m_page);

    // per table page-settings.
    let mut s_table = TableStyle::new("one");
    s_table.set_master_page(&m_page);
    let s_table = wb.add_tablestyle(s_table);

    let mut sh = Sheet::new("one");
    sh.set_style(&s_table);
    sheet_data(&mut sh);

    // define print header
    sh.set_header_rows(0, 1);
    // restriction on the print-data.
    sh.add_print_range(CellRange::local(1, 0, 1001, 3));

    wb.push_sheet(sh);

    write_ods(&mut wb, "examples_out/printing.ods")?;

    Ok(())
}

fn sheet_data(sh: &mut Sheet) {
    sh.set_value(0, 0, "Heading");
    let heading = ["A", "B", "C", "D", "E"];
    for c in 0..5 {
        sh.set_value(1, c, heading[c as usize]);
    }
    for c in 0..5 {
        for r in 0..1000 {
            sh.set_value(r + 2, c, r * c);
        }
    }
}