truecalc-core 1.0.2

Spreadsheet formula engine — parser and evaluator for Excel-compatible formulas
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

use crate::Engine;
use crate::types::Value;
use std::collections::HashMap;

#[test]
fn no_args_returns_single_number_in_0_1() {
    let eng = Engine::sheets();
    let result = eng.evaluate("=RANDARRAY()", &HashMap::new());
    assert!(
        matches!(result, Value::Number(_)),
        "expected Number, got {:?}",
        result
    );
    if let Value::Number(v) = result {
        assert!(v >= 0.0 && v < 1.0, "random value {} not in [0, 1)", v);
    }
}

#[test]
fn one_arg_rows_returns_nested_2d_array() {
    let eng = Engine::sheets();
    let result = eng.evaluate("=RANDARRAY(3)", &HashMap::new());
    assert!(matches!(result, Value::Array(_)));
    if let Value::Array(outer) = result {
        assert_eq!(outer.len(), 3);
        for row in &outer {
            assert!(matches!(row, Value::Array(_)));
            if let Value::Array(inner) = row {
                assert_eq!(inner.len(), 1);
                assert!(matches!(inner[0], Value::Number(_)));
            }
        }
    }
}

#[test]
fn two_args_rows_cols_returns_correct_shape() {
    let eng = Engine::sheets();
    let result = eng.evaluate("=RANDARRAY(2, 4)", &HashMap::new());
    if let Value::Array(outer) = result {
        assert_eq!(outer.len(), 2, "expected 2 rows");
        for row in &outer {
            if let Value::Array(inner) = row {
                assert_eq!(inner.len(), 4, "expected 4 cols");
            } else {
                panic!("expected inner array");
            }
        }
    } else {
        panic!("expected outer array");
    }
}

#[test]
fn values_are_numbers() {
    let eng = Engine::sheets();
    let result = eng.evaluate("=RANDARRAY(2, 2)", &HashMap::new());
    if let Value::Array(outer) = result {
        for row in &outer {
            if let Value::Array(inner) = row {
                for v in inner {
                    assert!(
                        matches!(v, Value::Number(_)),
                        "expected Number, got {:?}",
                        v
                    );
                }
            }
        }
    }
}