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

#![allow(clippy::unwrap_used)]

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

#[test]
fn test_fn_f_dist_sanity() {
    let mut model = new_empty_model();
    model._set("A1", "=F.DIST(15, 6, 4, TRUE)");
    model._set("A2", "=F.DIST(15, 6, 4, FALSE)");
    model._set("A3", "=F.DIST(15, 6, 4)");
    model._set("A4", "=F.DIST(15, 6, 4, TRUE, FALSE)");
    model.evaluate();
    assert_eq!(model._get_text("A1"), *"0.989741952");
    assert_eq!(model._get_text("A2"), *"0.001271447");
    assert_eq!(model._get_text("A3"), *"#ERROR!");
    assert_eq!(model._get_text("A4"), *"#ERROR!");
}

#[test]
fn test_fn_f_dist_rt_sanity() {
    let mut model = new_empty_model();

    // Valid call
    model._set("A1", "=F.DIST.RT(15, 6, 4)");
    // Too few args
    model._set("A2", "=F.DIST.RT(15, 6)");
    // Too many args
    model._set("A3", "=F.DIST.RT(15, 6, 4, 1)");

    model.evaluate();

    assert_eq!(model._get_text("A1"), *"0.010258048");
    assert_eq!(model._get_text("A2"), *"#ERROR!");
    assert_eq!(model._get_text("A3"), *"#ERROR!");
}

#[test]
fn test_fn_f_inv_sanity() {
    let mut model = new_empty_model();

    // Valid call: left-tail inverse
    model._set("A1", "=F.INV(0.9897419523940, 6, 4)");

    // Too many args
    model._set("A2", "=F.INV(0.5, 6, 4, 2)");

    // Too few args
    model._set("A3", "=F.INV(0.5, 6)");

    model.evaluate();

    assert_eq!(model._get_text("A1"), *"15");
    assert_eq!(model._get_text("A2"), *"#ERROR!");
    assert_eq!(model._get_text("A3"), *"#ERROR!");
}

#[test]
fn test_fn_f_inv_rt_sanity() {
    let mut model = new_empty_model();

    // Valid call: left-tail inverse
    model._set("A1", "=F.INV.RT(0.0102580476059808, 6, 4)");

    // Too many args
    model._set("A2", "=F.INV.RT(0.5, 6, 4, 2)");

    // Too few args
    model._set("A3", "=F.INV.RT(0.5, 6)");

    model.evaluate();

    assert_eq!(model._get_text("A1"), *"15");
    assert_eq!(model._get_text("A2"), *"#ERROR!");
    assert_eq!(model._get_text("A3"), *"#ERROR!");
}