formualizer-eval 0.7.0

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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156

//! Tests for ticket 604 — Arrow canonical values: unified read/write.
//!
//! Validates that value-read paths (get_cell_value, evaluation, range aggregates,
//! spills, named ranges) route through Arrow storage.

use crate::engine::named_range::{NameScope, NamedDefinition};
use crate::engine::{EvalConfig, eval::Engine};
use crate::reference::{CellRef, Coord, RangeRef};
use crate::test_workbook::TestWorkbook;
use formualizer_parse::LiteralValue;
use formualizer_parse::parser::parse;

#[test]
fn canonical_get_cell_value_routes_through_arrow() {
    let setup = |engine: &mut Engine<TestWorkbook>| {
        engine
            .set_cell_value("Sheet1", 1, 1, LiteralValue::Number(42.0))
            .unwrap();
        engine
            .set_cell_formula("Sheet1", 1, 2, parse("=A1*3").unwrap())
            .unwrap();
    };

    let wb = TestWorkbook::new();
    let mut engine = Engine::new(wb, EvalConfig::default());
    setup(&mut engine);
    engine.evaluate_all().unwrap();

    assert_eq!(
        engine.get_cell_value("Sheet1", 1, 1),
        Some(LiteralValue::Number(42.0))
    );
    assert_eq!(
        engine.get_cell_value("Sheet1", 1, 2),
        Some(LiteralValue::Number(126.0))
    );
}

#[test]
fn canonical_range_aggregate_parity() {
    let setup = |engine: &mut Engine<TestWorkbook>| {
        for r in 1..=10 {
            engine
                .set_cell_value("Sheet1", r, 1, LiteralValue::Number(r as f64))
                .unwrap();
        }
        engine
            .set_cell_formula("Sheet1", 1, 2, parse("=SUM(A1:A10)").unwrap())
            .unwrap();
        engine
            .set_cell_formula("Sheet1", 2, 2, parse("=AVERAGE(A1:A10)").unwrap())
            .unwrap();
    };

    let wb = TestWorkbook::new();
    let mut engine = Engine::new(wb, EvalConfig::default());
    setup(&mut engine);
    engine.evaluate_all().unwrap();

    assert_eq!(
        engine.get_cell_value("Sheet1", 1, 2),
        Some(LiteralValue::Number(55.0))
    );
    assert_eq!(
        engine.get_cell_value("Sheet1", 2, 2),
        Some(LiteralValue::Number(5.5))
    );
}

#[test]
fn canonical_spill_parity() {
    let setup = |engine: &mut Engine<TestWorkbook>| {
        engine
            .set_cell_formula("Sheet1", 1, 1, parse("=SEQUENCE(5,2)").unwrap())
            .unwrap();
        engine
            .set_cell_formula("Sheet1", 7, 1, parse("=SUM(A1:B5)").unwrap())
            .unwrap();
    };

    let wb = TestWorkbook::new();
    let mut engine = Engine::new(wb, EvalConfig::default());
    setup(&mut engine);
    engine.evaluate_all().unwrap();

    for r in 1..=5u32 {
        for c in 1..=2u32 {
            let expected = ((r - 1) * 2 + c) as f64;
            assert_eq!(
                engine.get_cell_value("Sheet1", r, c),
                Some(LiteralValue::Number(expected))
            );
        }
    }
    // SUM(1..10) = 55
    assert_eq!(
        engine.get_cell_value("Sheet1", 7, 1),
        Some(LiteralValue::Number(55.0))
    );
}

#[test]
fn canonical_constructor_forces_overlay_flags() {
    let wb = TestWorkbook::new();
    let cfg = EvalConfig {
        arrow_storage_enabled: false,
        delta_overlay_enabled: false,
        write_formula_overlay_enabled: false,
        ..EvalConfig::default()
    };
    let engine = Engine::new(wb, cfg);
    assert!(
        engine.config.arrow_storage_enabled,
        "arrow_storage_enabled must be forced true"
    );
    assert!(
        engine.config.delta_overlay_enabled,
        "delta_overlay_enabled must be forced true"
    );
    assert!(
        engine.config.write_formula_overlay_enabled,
        "write_formula_overlay_enabled must be forced true"
    );
}

#[test]
fn canonical_named_range_parity() {
    let setup = |engine: &mut Engine<TestWorkbook>| {
        for r in 1..=5u32 {
            engine
                .set_cell_value("Sheet1", r, 1, LiteralValue::Number(r as f64 * 10.0))
                .unwrap();
        }
        let sheet_id = engine.graph.sheet_id("Sheet1").unwrap();
        let start = CellRef::new(sheet_id, Coord::new(0, 0, true, true));
        let end = CellRef::new(sheet_id, Coord::new(4, 0, true, true));
        let range_def = NamedDefinition::Range(RangeRef::new(start, end));
        engine
            .define_name("prices", range_def, NameScope::Workbook)
            .unwrap();
        engine
            .set_cell_formula("Sheet1", 1, 2, parse("=SUM(prices)").unwrap())
            .unwrap();
    };

    let wb = TestWorkbook::new();
    let mut engine = Engine::new(wb, EvalConfig::default());
    setup(&mut engine);
    engine.evaluate_all().unwrap();

    // SUM(10+20+30+40+50) = 150
    assert_eq!(
        engine.get_cell_value("Sheet1", 1, 2),
        Some(LiteralValue::Number(150.0))
    );
}