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

use crate::args::CriteriaPredicate;
use crate::builtins::utils::criteria_match;
use formualizer_common::LiteralValue;

#[cfg(test)]
mod tests {
    use super::*;

    fn create_text_like(pattern: &str) -> CriteriaPredicate {
        CriteriaPredicate::TextLike {
            pattern: pattern.to_string(),
            case_insensitive: true,
        }
    }

    #[test]
    fn test_anchored_start_wildcard() {
        let pred = create_text_like("abc*");

        assert!(criteria_match(&pred, &LiteralValue::Text("abc".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("abcdef".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("ABC123".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("ABCxyz".into())));

        assert!(!criteria_match(&pred, &LiteralValue::Text("xabc".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("ab".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("dabc".into())));
    }

    #[test]
    fn test_anchored_end_wildcard() {
        let pred = create_text_like("*xyz");

        assert!(criteria_match(&pred, &LiteralValue::Text("xyz".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("abcxyz".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("123XYZ".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("testXYZ".into())));

        assert!(!criteria_match(&pred, &LiteralValue::Text("xyzabc".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("xy".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("xyzd".into())));
    }

    #[test]
    fn test_contains_wildcard() {
        let pred = create_text_like("*mid*");

        assert!(criteria_match(&pred, &LiteralValue::Text("mid".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("middle".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("amid".into())));
        assert!(criteria_match(
            &pred,
            &LiteralValue::Text("beginning_MID_end".into())
        ));
        assert!(criteria_match(&pred, &LiteralValue::Text("MID".into())));

        assert!(!criteria_match(&pred, &LiteralValue::Text("md".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("mdi".into())));
    }

    #[test]
    fn test_exact_match_no_wildcard() {
        let pred = create_text_like("exact");

        assert!(criteria_match(&pred, &LiteralValue::Text("exact".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("EXACT".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("ExAcT".into())));

        assert!(!criteria_match(&pred, &LiteralValue::Text("exac".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("exacta".into())));
    }

    #[test]
    fn test_question_mark_fallback() {
        let pred = create_text_like("a?c");

        assert!(criteria_match(&pred, &LiteralValue::Text("abc".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("a1c".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("AXC".into())));

        assert!(!criteria_match(&pred, &LiteralValue::Text("ac".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("abbc".into())));
    }

    #[test]
    fn test_complex_pattern_fallback() {
        let pred = create_text_like("a*b?c*");

        assert!(criteria_match(&pred, &LiteralValue::Text("abxc".into())));
        assert!(criteria_match(
            &pred,
            &LiteralValue::Text("axxxxbxc".into())
        ));
        assert!(criteria_match(&pred, &LiteralValue::Text("abxcyyy".into())));
        assert!(criteria_match(&pred, &LiteralValue::Text("ABXCDEF".into())));

        assert!(!criteria_match(&pred, &LiteralValue::Text("abc".into())));
        assert!(!criteria_match(&pred, &LiteralValue::Text("axc".into())));
    }

    #[test]
    fn test_case_sensitivity() {
        let pred_insensitive = create_text_like("ABC*");
        let pred_sensitive = CriteriaPredicate::TextLike {
            pattern: "ABC*".to_string(),
            case_insensitive: false,
        };

        assert!(criteria_match(
            &pred_insensitive,
            &LiteralValue::Text("abc123".into())
        ));
        assert!(criteria_match(
            &pred_insensitive,
            &LiteralValue::Text("ABC123".into())
        ));

        assert!(!criteria_match(
            &pred_sensitive,
            &LiteralValue::Text("abc123".into())
        ));
        assert!(criteria_match(
            &pred_sensitive,
            &LiteralValue::Text("ABC123".into())
        ));
    }

    #[test]
    fn test_numeric_coercion() {
        let pred = create_text_like("123*");

        assert!(criteria_match(&pred, &LiteralValue::Number(123.0)));
        assert!(criteria_match(&pred, &LiteralValue::Number(123.456)));
        assert!(criteria_match(&pred, &LiteralValue::Int(123)));

        assert!(!criteria_match(&pred, &LiteralValue::Number(12.3)));
        assert!(!criteria_match(&pred, &LiteralValue::Int(12)));
    }

    #[test]
    fn test_empty_values() {
        let pred_empty = create_text_like("*");
        let pred_something = create_text_like("some*");

        assert!(criteria_match(&pred_empty, &LiteralValue::Empty));
        assert!(criteria_match(&pred_empty, &LiteralValue::Text("".into())));

        assert!(!criteria_match(&pred_something, &LiteralValue::Empty));
        assert!(!criteria_match(
            &pred_something,
            &LiteralValue::Text("".into())
        ));
    }
}