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

mod lib_test;

use lib_test::*;
use spreadsheet_ods::sheet::Grouped;
use spreadsheet_ods::{read_ods, OdsError, Sheet, WorkBook};

#[test]
fn test_write_group1() -> Result<(), OdsError> {
    let mut wb = WorkBook::new_empty();

    let mut sh = Sheet::new("Sheet1");
    sh.set_value(0, 0, 1);
    sh.set_value(1, 0, 1);
    sh.set_value(2, 0, 1);
    sh.set_value(3, 0, 1);
    sh.set_value(4, 0, 1);
    sh.set_value(5, 0, 1);
    sh.set_value(6, 0, 1);
    sh.set_value(7, 0, 1);
    sh.set_value(8, 0, 1);
    sh.set_value(9, 0, 1);

    sh.add_row_group(1, 4);
    sh.add_row_group(1, 2);
    sh.add_row_group(1, 3);
    sh.add_row_group(4, 4);
    sh.add_row_group(6, 9);
    sh.set_row_group_displayed(6, 9, false);
    sh.add_row_group(7, 9);
    sh.add_row_group(8, 9);
    sh.add_row_group(9, 9);
    sh.add_row_group(40, 45);

    wb.push_sheet(sh);

    test_write_ods(&mut wb, "test_out/test_grouped_1.ods")?;

    let wb = read_ods("test_out/test_grouped_1.ods")?;
    let sh = wb.sheet(0);

    let v = sh.row_group_iter().cloned().collect::<Vec<_>>();
    assert!(v.contains(&Grouped::new(1, 4, true)));
    assert!(v.contains(&Grouped::new(1, 2, true)));
    assert!(v.contains(&Grouped::new(1, 3, true)));
    assert!(v.contains(&Grouped::new(4, 4, true)));
    assert!(v.contains(&Grouped::new(6, 9, false)));
    assert!(v.contains(&Grouped::new(7, 9, true)));
    assert!(v.contains(&Grouped::new(8, 9, true)));
    assert!(v.contains(&Grouped::new(9, 9, true)));

    Ok(())
}

#[test]
fn test_write_group2() -> Result<(), OdsError> {
    let mut wb = WorkBook::new_empty();

    let mut sh = Sheet::new("Sheet1");
    sh.set_value(0, 0, 1);
    sh.set_value(1, 1, 1);
    sh.set_value(2, 2, 1);
    sh.set_value(3, 3, 1);
    sh.set_value(4, 4, 1);
    sh.set_value(5, 5, 1);
    sh.set_value(6, 6, 1);
    sh.set_value(7, 7, 1);
    sh.set_value(8, 8, 1);
    sh.set_value(9, 9, 1);

    sh.add_col_group(1, 4);
    sh.add_col_group(1, 2);
    sh.add_col_group(1, 3);
    sh.add_col_group(4, 4);
    sh.add_col_group(6, 9);
    sh.set_col_group_displayed(6, 9, false);
    sh.add_col_group(7, 9);
    sh.add_col_group(8, 9);
    sh.add_col_group(9, 9);
    sh.add_col_group(40, 45);

    wb.push_sheet(sh);

    test_write_ods(&mut wb, "test_out/test_grouped_2.ods")?;

    let wb = read_ods("test_out/test_grouped_2.ods")?;
    let sh = wb.sheet(0);

    let v = sh.col_group_iter().cloned().collect::<Vec<_>>();
    assert!(v.contains(&Grouped::new(1, 4, true)));
    assert!(v.contains(&Grouped::new(1, 2, true)));
    assert!(v.contains(&Grouped::new(1, 3, true)));
    assert!(v.contains(&Grouped::new(4, 4, true)));
    assert!(v.contains(&Grouped::new(6, 9, false)));
    assert!(v.contains(&Grouped::new(7, 9, true)));
    assert!(v.contains(&Grouped::new(8, 9, true)));
    assert!(v.contains(&Grouped::new(9, 9, true)));

    Ok(())
}

#[test]
#[should_panic]
fn test_write_group3() {
    let mut sh = Sheet::new("Sheet1");
    sh.add_col_group(4, 1);
}

#[test]
#[should_panic]
fn test_write_group4() {
    let mut sh = Sheet::new("Sheet1");
    sh.add_row_group(4, 1);
}

#[test]
#[should_panic]
fn test_write_group5() {
    let mut sh = Sheet::new("Sheet1");
    sh.add_col_group(1, 4);
    sh.add_col_group(2, 5);
}

#[test]
#[should_panic]
fn test_write_group6() {
    let mut sh = Sheet::new("Sheet1");
    sh.add_row_group(1, 4);
    sh.add_row_group(2, 5);
}