ganit-core 0.3.11

Spreadsheet formula engine — parser and evaluator for Excel-compatible formulas
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

use super::super::countifs_fn;
use crate::types::Value;

fn nums(ns: &[f64]) -> Value {
    Value::Array(ns.iter().map(|&n| Value::Number(n)).collect())
}

#[test]
fn no_matches_returns_zero() {
    // COUNTIFS({1,2,3}, ">5", {1,2,3}, "<10") → 0
    let range = nums(&[1.0, 2.0, 3.0]);
    let result = countifs_fn(&[
        range.clone(),
        Value::Text(">5".to_string()),
        range.clone(),
        Value::Text("<10".to_string()),
    ]);
    assert_eq!(result, Value::Number(0.0));
}

#[test]
fn all_match_returns_full_count() {
    // COUNTIFS({1,2,3}, ">=1", {1,2,3}, "<=3") → 3
    let range = nums(&[1.0, 2.0, 3.0]);
    let result = countifs_fn(&[
        range.clone(),
        Value::Text(">=1".to_string()),
        range.clone(),
        Value::Text("<=3".to_string()),
    ]);
    assert_eq!(result, Value::Number(3.0));
}

#[test]
fn empty_array_returns_zero() {
    let result = countifs_fn(&[Value::Array(vec![]), Value::Number(1.0)]);
    assert_eq!(result, Value::Number(0.0));
}

#[test]
fn scalar_range_single_element() {
    // COUNTIFS(5, 5) → 1 (scalar treated as single-element range)
    let result = countifs_fn(&[Value::Number(5.0), Value::Number(5.0)]);
    assert_eq!(result, Value::Number(1.0));
}