ironcalc_base 0.7.1

Open source spreadsheet engine
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

#![allow(clippy::unwrap_used)]

use crate::{constants::DEFAULT_COLUMN_WIDTH, test::user_model::util::new_empty_user_model};

#[test]
fn add_undo_redo() {
    let mut model = new_empty_user_model();
    model.new_sheet().unwrap();
    model.set_user_input(1, 1, 1, "=1 + 1").unwrap();
    model.set_user_input(1, 1, 2, "=A1*3").unwrap();
    model
        .set_columns_width(1, 5, 5, 5.0 * DEFAULT_COLUMN_WIDTH)
        .unwrap();
    model.new_sheet().unwrap();
    model.set_user_input(2, 1, 1, "=Sheet2!B1").unwrap();

    model.undo().unwrap();
    model.undo().unwrap();

    assert!(model.get_formatted_cell_value(2, 1, 1).is_err());

    model.redo().unwrap();
    model.redo().unwrap();

    assert_eq!(model.get_formatted_cell_value(2, 1, 1), Ok("6".to_string()));

    model.delete_sheet(1).unwrap();
}

#[test]
fn set_sheet_color() {
    let mut model = new_empty_user_model();
    model.set_sheet_color(0, "#343434").unwrap();
    let worksheets_properties = model.get_worksheets_properties();
    assert_eq!(worksheets_properties.len(), 1);
    assert_eq!(worksheets_properties[0].color, Some("#343434".to_owned()));
    model.undo().unwrap();
    assert_eq!(model.get_worksheets_properties()[0].color, None);

    model.redo().unwrap();
    assert_eq!(
        model.get_worksheets_properties()[0].color,
        Some("#343434".to_owned())
    );
    // changes the color if there is one
    model.set_sheet_color(0, "#2534FF").unwrap();
    assert_eq!(
        model.get_worksheets_properties()[0].color,
        Some("#2534FF".to_owned())
    );
    // Setting it back to none
    model.set_sheet_color(0, "").unwrap();
    assert_eq!(model.get_worksheets_properties()[0].color, None);
}

#[test]
fn new_sheet_propagates() {
    let mut model = new_empty_user_model();
    model.new_sheet().unwrap();

    let send_queue = model.flush_send_queue();

    let mut model2 = new_empty_user_model();
    model2.apply_external_diffs(&send_queue).unwrap();
    let worksheets_properties = model2.get_worksheets_properties();
    assert_eq!(worksheets_properties.len(), 2);
}

#[test]
fn delete_sheet_propagates() {
    let mut model = new_empty_user_model();
    model.new_sheet().unwrap();
    model.delete_sheet(0).unwrap();

    let send_queue = model.flush_send_queue();

    let mut model2 = new_empty_user_model();
    model2.apply_external_diffs(&send_queue).unwrap();
    let sheets_info = model2.get_worksheets_properties();
    assert_eq!(sheets_info.len(), 1);
}

#[test]
fn delete_last_sheet() {
    // Deleting the last sheet, selects the previous
    let mut model = new_empty_user_model();
    model.new_sheet().unwrap();
    model.new_sheet().unwrap();
    model.set_selected_sheet(2).unwrap();
    model.delete_sheet(2).unwrap();

    assert_eq!(model.get_selected_sheet(), 1);
}

#[test]
fn new_sheet_selects_it() {
    let mut model = new_empty_user_model();
    assert_eq!(model.get_selected_sheet(), 0);
    model.new_sheet().unwrap();
    assert_eq!(model.get_selected_sheet(), 1);
}