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
119
120
121
122
123
124
125
126
127

#![allow(clippy::unwrap_used)]

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

#[test]
fn test_fn_chisq_test_smoke() {
    let mut model = new_empty_model();
    model._set("A2", "48");
    model._set("A3", "32");
    model._set("A4", "12");
    model._set("A5", "1");
    model._set("A6", "'13");
    model._set("A7", "TRUE");
    model._set("A8", "1");
    model._set("A9", "13");
    model._set("A10", "15");

    model._set("B2", "55");
    model._set("B3", "34");
    model._set("B4", "13");
    model._set("B5", "blah");
    model._set("B6", "13");
    model._set("B7", "1");
    model._set("B8", "TRUE");
    model._set("B9", "'14");
    model._set("B10", "16");

    model._set("C1", "=CHISQ.TEST(A2:A10, B2:B10)");
    model.evaluate();
    assert_eq!(model._get_text("C1"), *"0.997129538");
}

#[test]
fn arrays() {
    let mut model = new_empty_model();
    model._set("A2", "TRUE");
    model._set("A3", "4");
    model._set("A4", "'3");
    model._set("B2", "2");
    model._set("B3", "2");
    model._set("B4", "2");
    model._set("C1", "=CHISQ.TEST(A2:A4, B2:B4)");

    model._set("G5", "=CHISQ.TEST({TRUE,4,\"3\"}, {2,2,2})");

    // 1D arrays with different shapes
    model._set("G6", "=CHISQ.TEST({1,2,3}, {3;3;4})");

    // 2D array
    model._set("G7", "=CHISQ.TEST({1,2;3,4},{2,3;2,2})");

    // 1D arrays with same shape
    model._set("G8", "=CHISQ.TEST({1,2,3,4}, {2,3,4,5})");

    model.evaluate();
    assert_eq!(model._get_text("C1"), *"0.367879441");
    assert_eq!(model._get_text("G5"), *"0.367879441");

    assert_eq!(model._get_text("G6"), *"0.383531573");

    assert_eq!(model._get_text("G7"), *"0.067889155");

    assert_eq!(model._get_text("G8"), *"0.733094495");
}

#[test]
fn more_arrays() {
    let mut model = new_empty_model();
    model._set("V20", "2");
    model._set("V21", "4");
    model._set("W20", "3");
    model._set("W21", "5");
    model._set("C1", "=CHISQ.TEST({1,2;3,4},V20:W21)");
    model._set("C2", "=CHISQ.TEST({1,2;3,4}, {2,3;4,5})");
    model.evaluate();
    assert_eq!(model._get_text("C1"), *"0.257280177");
    assert_eq!(model._get_text("C2"), *"0.257280177");
}

#[test]
fn array_ranges() {
    let mut model = new_empty_model();
    model._set("A2", "TRUE");
    model._set("A3", "4");
    model._set("A4", "'3");
    model._set("B2", "2");
    model._set("B3", "2");
    model._set("B4", "2");
    model._set("C1", "=CHISQ.TEST(A2:A4, {2;2;2})");

    model._set("G5", "=CHISQ.TEST({TRUE;4;\"3\"}, B2:B4)");
    model.evaluate();

    assert_eq!(model._get_text("C1"), *"0.367879441");
    assert_eq!(model._get_text("G5"), *"0.367879441");
}

#[test]
fn array_2d_ranges() {
    let mut model = new_empty_model();
    model._set("A2", "2");
    model._set("B2", "3");
    model._set("C2", "4");
    model._set("A3", "5");
    model._set("B3", "6");
    model._set("C3", "7");
    model._set("G1", "=CHISQ.TEST({1,2,3;4,2,6}, A2:C3)");
    model.evaluate();
    assert_eq!(model._get_text("G1"), *"0.129195493");
}

#[test]
fn ranges_1d() {
    let mut model = new_empty_model();
    model._set("A2", "1");
    model._set("A3", "2");
    model._set("A4", "3");
    model._set("B2", "4");
    model._set("C2", "5");
    model._set("D2", "6");
    model._set("G1", "=CHISQ.TEST(A2:A4, B2:D2)");
    model._set("G2", "=CHISQ.TEST(B2:D2, A2:A4)");

    model.evaluate();
    assert_eq!(model._get_text("G1"), *"0.062349477");
    assert_eq!(model._get_text("G2"), *"0.000261259");
}