formualizer-eval 0.5.6

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

use chrono::NaiveDate;

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

#[test]
fn countifs_date_criteria_with_ampersand_concatenation() {
    // Regression for criteria strings like ">="&C1 where C1 is a date.
    // Libre/Excel treat dates as serials for criteria parsing.
    let mut engine = Engine::new(TestWorkbook::new(), EvalConfig::default());
    let sheet = "Calculations";

    // Criteria bounds: 2024-11-01 .. 2024-11-30
    engine
        .set_cell_value(
            sheet,
            1,
            3,
            LiteralValue::Date(NaiveDate::from_ymd_opt(2024, 11, 1).unwrap()),
        )
        .unwrap();
    engine
        .set_cell_value(
            sheet,
            1,
            4,
            LiteralValue::Date(NaiveDate::from_ymd_opt(2024, 11, 30).unwrap()),
        )
        .unwrap();

    // Values: 11/15, 11/29, 12/13
    engine
        .set_cell_value(
            sheet,
            110,
            3,
            LiteralValue::Date(NaiveDate::from_ymd_opt(2024, 11, 15).unwrap()),
        )
        .unwrap();
    engine
        .set_cell_value(
            sheet,
            111,
            3,
            LiteralValue::Date(NaiveDate::from_ymd_opt(2024, 11, 29).unwrap()),
        )
        .unwrap();
    engine
        .set_cell_value(
            sheet,
            112,
            3,
            LiteralValue::Date(NaiveDate::from_ymd_opt(2024, 12, 13).unwrap()),
        )
        .unwrap();

    // COUNTIFS(C110:C112,">="&C1,C110:C112,"<="&D1)
    engine
        .set_cell_formula(
            sheet,
            109,
            8,
            parse("=COUNTIFS(C110:C112,\">=\"&C1,C110:C112,\"<=\"&D1)").unwrap(),
        )
        .unwrap();

    engine.evaluate_all().unwrap();
    assert_eq!(
        engine.get_cell_value(sheet, 109, 8),
        Some(LiteralValue::Number(2.0))
    );
}

#[test]
fn countifs_date_equality_accepts_date_literal_criteria() {
    // Criteria passed as a date value (not a string) should work.
    let mut engine = Engine::new(TestWorkbook::new(), EvalConfig::default());
    let sheet = "Calculations";

    let target = NaiveDate::from_ymd_opt(2024, 11, 29).unwrap();

    engine
        .set_cell_value(sheet, 1, 3, LiteralValue::Date(target))
        .unwrap();

    engine
        .set_cell_value(
            sheet,
            110,
            3,
            LiteralValue::Date(NaiveDate::from_ymd_opt(2024, 11, 15).unwrap()),
        )
        .unwrap();
    engine
        .set_cell_value(sheet, 111, 3, LiteralValue::Date(target))
        .unwrap();
    engine
        .set_cell_value(
            sheet,
            112,
            3,
            LiteralValue::Date(NaiveDate::from_ymd_opt(2024, 12, 13).unwrap()),
        )
        .unwrap();

    engine
        .set_cell_formula(sheet, 10, 8, parse("=COUNTIFS(C110:C112,C1)").unwrap())
        .unwrap();

    engine.evaluate_all().unwrap();
    assert_eq!(
        engine.get_cell_value(sheet, 10, 8),
        Some(LiteralValue::Number(1.0))
    );
}