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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

#![allow(clippy::unwrap_used)]

use crate::test::util::new_empty_model;

#[test]
fn test_inverted_range_sum() {
    let mut model = new_empty_model();
    model._set("B2", "1");
    model._set("B3", "2");
    model._set("B4", "3");

    model._set("A1", "=SUM(B2:B4)");
    model._set("A2", "=SUM(B4:B2)"); // inverted

    model.evaluate();

    assert_eq!(model._get_text("A1"), "6");
    assert_eq!(model._get_text("A2"), "6");
}

#[test]
fn test_mixed_absolute_relative_range() {
    let mut model = new_empty_model();
    model._set("B2", "10");
    model._set("B3", "20");
    model._set("B4", "30");
    model._set("B5", "40");

    model._set("A5", "=SUM(B$2:B5)");
    model._set("C5", "=SUM(B5:B$2)"); // inverted

    model.evaluate();

    assert_eq!(model._get_text("A5"), "100");
    assert_eq!(model._get_text("C5"), "100");
}

#[test]
fn test_mixed_absolute_range_after_sheet_rename() {
    let mut model = new_empty_model();
    model._set("B2", "1");
    model._set("B3", "2");
    model._set("B4", "3");
    model._set("B5", "4");

    model._set("A5", "=SUM(B$2:B5)");
    model.evaluate();
    assert_eq!(model._get_text("A5"), "10");

    model.rename_sheet("Sheet1", "RenamedSheet").unwrap();
    model.evaluate();
    assert_eq!(model._get_text("RenamedSheet!A5"), "10");
}

#[test]
fn test_inverted_range_absolute_column() {
    let mut model = new_empty_model();
    model._set("B2", "5");
    model._set("C2", "10");
    model._set("D2", "15");

    model._set("A1", "=SUM($B2:D2)");
    model._set("A2", "=SUM(D2:$B2)"); // inverted

    model.evaluate();

    assert_eq!(model._get_text("A1"), "30");
    assert_eq!(model._get_text("A2"), "30");
}

#[test]
fn test_inverted_2d_range() {
    let mut model = new_empty_model();
    model._set("B2", "1");
    model._set("B3", "2");
    model._set("C2", "3");
    model._set("C3", "4");

    model._set("A1", "=SUM(B2:C3)");
    model._set("A2", "=SUM(C3:B2)"); // fully inverted
    model._set("A3", "=SUM(B3:C2)"); // row inverted
    model._set("A4", "=SUM(C2:B3)"); // column inverted

    model.evaluate();

    assert_eq!(model._get_text("A1"), "10");
    assert_eq!(model._get_text("A2"), "10");
    assert_eq!(model._get_text("A3"), "10");
    assert_eq!(model._get_text("A4"), "10");
}

#[test]
fn test_mixed_absolute_2d_range() {
    let mut model = new_empty_model();
    model._set("B2", "1");
    model._set("B3", "2");
    model._set("B4", "3");
    model._set("C2", "4");
    model._set("C3", "5");
    model._set("C4", "6");
    model._set("D2", "7");
    model._set("D3", "8");
    model._set("D4", "9");

    model._set("A4", "=SUM($B$2:D4)");
    model._set("E4", "=SUM(D4:$B$2)"); // inverted

    model.evaluate();

    assert_eq!(model._get_text("A4"), "45");
    assert_eq!(model._get_text("E4"), "45");

    model.rename_sheet("Sheet1", "Data").unwrap();
    model.evaluate();

    assert_eq!(model._get_text("Data!A4"), "45");
    assert_eq!(model._get_text("Data!E4"), "45");
}