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

#![allow(clippy::unwrap_used)]

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

#[test]
fn test_fn_z_test_smoke() {
    let mut model = new_empty_model();
    model._set("A2", "3");
    model._set("A3", "6");
    model._set("A4", "7");
    model._set("A5", "8");
    model._set("A6", "6");
    model._set("A7", "5");
    model._set("A8", "4");
    model._set("A9", "2");
    model._set("A10", "1");
    model._set("A11", "9");

    model._set("G1", "=Z.TEST(A2:A11, 4)");
    model._set("G2", "=Z.TEST(A2:A11, 6)");
    model.evaluate();

    assert_eq!(model._get_text("G1"), *"0.090574197");
    assert_eq!(model._get_text("G2"), *"0.863043389");
}

#[test]
fn arrays() {
    let mut model = new_empty_model();
    model._set("D1", "=Z.TEST({5,2,3,4}, 4, 123)");
    model._set("D2", "=Z.TEST({5,2,3,4}, 4)");
    model.evaluate();

    assert_eq!(model._get_text("D1"), *"0.503243397");
    assert_eq!(model._get_text("D2"), *"0.780710987");
}