formualizer-eval 0.6.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

use chrono::NaiveDate;

use crate::engine::{Engine, EvalConfig};
use crate::test_workbook::TestWorkbook;
use formualizer_common::LiteralValue;
use formualizer_parse::parser::parse;

fn date(y: i32, m: u32, d: u32) -> NaiveDate {
    NaiveDate::from_ymd_opt(y, m, d).unwrap()
}

fn assert_date_like(v: Option<LiteralValue>, expected: NaiveDate) {
    match v {
        Some(LiteralValue::Date(d)) => assert_eq!(d, expected),
        Some(LiteralValue::DateTime(dt)) => assert_eq!(dt.date(), expected),
        Some(LiteralValue::Number(n)) => {
            let got = NaiveDate::from_ymd_opt(1899, 12, 30).unwrap()
                + chrono::Duration::days(n.trunc() as i64);
            assert_eq!(got, expected, "serial {n} did not map to {expected}");
        }
        other => panic!("expected date-like {expected:?}, got {other:?}"),
    }
}

fn run_edate(start: NaiveDate, months: i64) -> Option<LiteralValue> {
    let mut engine = Engine::new(TestWorkbook::new(), EvalConfig::default());
    engine
        .set_cell_value("Sheet1", 1, 1, LiteralValue::Date(start))
        .unwrap();
    engine
        .set_cell_formula(
            "Sheet1",
            1,
            2,
            parse(format!("=EDATE($A$1, {months})")).unwrap(),
        )
        .unwrap();
    engine.evaluate_all().unwrap();
    engine.get_cell_value("Sheet1", 1, 2)
}

#[test]
fn edate_with_date_cell_adds_months_preserving_day() {
    assert_date_like(run_edate(date(2025, 2, 4), 15), date(2026, 5, 4));
}

#[test]
fn edate_with_date_cell_clamps_to_month_end() {
    assert_date_like(run_edate(date(2025, 1, 31), 1), date(2025, 2, 28));
}

#[test]
fn edate_with_date_cell_handles_negative_months() {
    assert_date_like(run_edate(date(2025, 3, 15), -3), date(2024, 12, 15));
}

#[test]
fn eomonth_with_date_cell_returns_month_end() {
    let mut engine = Engine::new(TestWorkbook::new(), EvalConfig::default());
    engine
        .set_cell_value("Sheet1", 1, 1, LiteralValue::Date(date(2025, 2, 4)))
        .unwrap();
    engine
        .set_cell_formula("Sheet1", 1, 2, parse("=EOMONTH($A$1, 0)").unwrap())
        .unwrap();
    engine.evaluate_all().unwrap();
    assert_date_like(engine.get_cell_value("Sheet1", 1, 2), date(2025, 2, 28));
}