formualizer-eval 0.8.4

High-performance Arrow-backed Excel formula engine with dependency graph and incremental recalculation
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

use super::common::arrow_eval_config;
use crate::engine::Engine;
use crate::test_workbook::TestWorkbook;
use crate::traits::{ArgumentHandle, DefaultFunctionContext, FunctionProvider};
use formualizer_common::LiteralValue;
use formualizer_parse::parser::{ASTNode, ASTNodeType, ReferenceType};

fn range_ref(sheet: &str, sr: u32, sc: u32, er: u32, ec: u32) -> ASTNode {
    let r = ReferenceType::range(
        Some(sheet.to_string()),
        Some(sr),
        Some(sc),
        Some(er),
        Some(ec),
    );
    ASTNode::new(
        ASTNodeType::Reference {
            original: String::new(),
            reference: r,
        },
        None,
    )
}

fn lit_text(s: &str) -> ASTNode {
    ASTNode::new(ASTNodeType::Literal(LiteralValue::Text(s.into())), None)
}

fn engine_with_debt_blank_equity() -> Engine<TestWorkbook> {
    let mut engine = Engine::new(TestWorkbook::new(), arrow_eval_config());
    let mut ab = engine.begin_bulk_ingest_arrow();
    ab.add_sheet("Sheet1", 2, 8);
    ab.append_row(
        "Sheet1",
        &[LiteralValue::Text("Debt".into()), LiteralValue::Int(10)],
    )
    .unwrap();
    ab.append_row("Sheet1", &[LiteralValue::Empty, LiteralValue::Int(20)])
        .unwrap();
    ab.append_row(
        "Sheet1",
        &[LiteralValue::Text("Equity".into()), LiteralValue::Int(30)],
    )
    .unwrap();
    ab.finish().unwrap();
    engine
}

#[test]
fn sumifs_ne_text_includes_blank_criteria_cell() {
    let engine = engine_with_debt_blank_equity();
    let sum_rng = range_ref("Sheet1", 1, 2, 3, 2);
    let crit_rng = range_ref("Sheet1", 1, 1, 3, 1);
    let crit = lit_text("<>Debt");

    let fun = engine.get_function("", "SUMIFS").expect("SUMIFS available");
    let interp = crate::interpreter::Interpreter::new(&engine, "Sheet1");
    let args = vec![
        ArgumentHandle::new(&sum_rng, &interp),
        ArgumentHandle::new(&crit_rng, &interp),
        ArgumentHandle::new(&crit, &interp),
    ];
    let fctx = DefaultFunctionContext::new_with_sheet(&engine, None, engine.default_sheet_name());
    let got = fun.dispatch(&args, &fctx).unwrap().into_literal();

    assert_eq!(got, LiteralValue::Number(50.0));
}

#[test]
fn countifs_ne_text_includes_blank_criteria_cell() {
    let engine = engine_with_debt_blank_equity();
    let crit_rng = range_ref("Sheet1", 1, 1, 3, 1);
    let crit = lit_text("<>Debt");

    let fun = engine
        .get_function("", "COUNTIFS")
        .expect("COUNTIFS available");
    let interp = crate::interpreter::Interpreter::new(&engine, "Sheet1");
    let args = vec![
        ArgumentHandle::new(&crit_rng, &interp),
        ArgumentHandle::new(&crit, &interp),
    ];
    let fctx = DefaultFunctionContext::new_with_sheet(&engine, None, engine.default_sheet_name());
    let got = fun.dispatch(&args, &fctx).unwrap().into_literal();

    assert_eq!(got, LiteralValue::Number(2.0));
}

#[test]
fn sumif_ne_text_includes_blank_criteria_cell() {
    let engine = engine_with_debt_blank_equity();
    let crit_rng = range_ref("Sheet1", 1, 1, 3, 1);
    let crit = lit_text("<>Debt");
    let sum_rng = range_ref("Sheet1", 1, 2, 3, 2);

    let fun = engine.get_function("", "SUMIF").expect("SUMIF available");
    let interp = crate::interpreter::Interpreter::new(&engine, "Sheet1");
    let args = vec![
        ArgumentHandle::new(&crit_rng, &interp),
        ArgumentHandle::new(&crit, &interp),
        ArgumentHandle::new(&sum_rng, &interp),
    ];
    let fctx = DefaultFunctionContext::new_with_sheet(&engine, None, engine.default_sheet_name());
    let got = fun.dispatch(&args, &fctx).unwrap().into_literal();

    assert_eq!(got, LiteralValue::Number(50.0));
}