ganit-core 0.4.0

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
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

use super::super::{daverage_fn, dcount_fn, dmax_fn, dmin_fn, dproduct_fn, dstdev_fn, dsum_fn};
use crate::types::{ErrorKind, Value};

fn simple_db() -> Value {
    Value::Array(vec![
        Value::Array(vec![
            Value::Text("Name".to_string()),
            Value::Text("Sales".to_string()),
        ]),
        Value::Array(vec![Value::Text("Alice".to_string()), Value::Number(100.0)]),
    ])
}

fn criteria_all() -> Value {
    Value::Array(vec![
        Value::Array(vec![Value::Text("Sales".to_string())]),
        Value::Array(vec![Value::Text(">=0".to_string())]),
    ])
}

#[test]
fn no_matching_rows_dsum_returns_zero() {
    let db = simple_db();
    let criteria_no_match = Value::Array(vec![
        Value::Array(vec![Value::Text("Name".to_string())]),
        Value::Array(vec![Value::Text("Charlie".to_string())]),
    ]);
    let result = dsum_fn(&[db, Value::Text("Sales".to_string()), criteria_no_match]);
    assert_eq!(result, Value::Number(0.0));
}

#[test]
fn no_matching_rows_dmax_returns_zero() {
    let db = simple_db();
    let criteria_no_match = Value::Array(vec![
        Value::Array(vec![Value::Text("Name".to_string())]),
        Value::Array(vec![Value::Text("Charlie".to_string())]),
    ]);
    let result = dmax_fn(&[db, Value::Text("Sales".to_string()), criteria_no_match]);
    assert_eq!(result, Value::Number(0.0));
}

#[test]
fn no_matching_rows_dmin_returns_zero() {
    let db = simple_db();
    let criteria_no_match = Value::Array(vec![
        Value::Array(vec![Value::Text("Name".to_string())]),
        Value::Array(vec![Value::Text("Charlie".to_string())]),
    ]);
    let result = dmin_fn(&[db, Value::Text("Sales".to_string()), criteria_no_match]);
    assert_eq!(result, Value::Number(0.0));
}

#[test]
fn no_matching_rows_dproduct_returns_zero() {
    let db = simple_db();
    let criteria_no_match = Value::Array(vec![
        Value::Array(vec![Value::Text("Name".to_string())]),
        Value::Array(vec![Value::Text("Charlie".to_string())]),
    ]);
    let result = dproduct_fn(&[db, Value::Text("Sales".to_string()), criteria_no_match]);
    assert_eq!(result, Value::Number(0.0));
}

#[test]
fn no_matching_rows_daverage_returns_div_by_zero() {
    let db = simple_db();
    let criteria_no_match = Value::Array(vec![
        Value::Array(vec![Value::Text("Name".to_string())]),
        Value::Array(vec![Value::Text("Charlie".to_string())]),
    ]);
    let result = daverage_fn(&[db, Value::Text("Sales".to_string()), criteria_no_match]);
    assert_eq!(result, Value::Error(ErrorKind::DivByZero));
}

#[test]
fn dstdev_single_match_returns_div_by_zero() {
    // sample stdev requires at least 2 values
    let result = dstdev_fn(&[simple_db(), Value::Text("Sales".to_string()), criteria_all()]);
    assert_eq!(result, Value::Error(ErrorKind::DivByZero));
}

#[test]
fn dcount_counts_only_numeric_values() {
    // Name column contains text — DCOUNT of Name should return 0
    let result = dcount_fn(&[simple_db(), Value::Text("Name".to_string()), criteria_all()]);
    assert_eq!(result, Value::Number(0.0));
}

#[test]
fn field_lookup_is_case_insensitive() {
    // "sales" (lowercase) should resolve to "Sales" column
    let result = dsum_fn(&[simple_db(), Value::Text("sales".to_string()), criteria_all()]);
    assert_eq!(result, Value::Number(100.0));
}

#[test]
fn database_with_only_header_row_returns_zero() {
    // No data rows → sum = 0
    let db = Value::Array(vec![Value::Array(vec![
        Value::Text("Name".to_string()),
        Value::Text("Sales".to_string()),
    ])]);
    let criteria = Value::Array(vec![
        Value::Array(vec![Value::Text("Name".to_string())]),
        Value::Array(vec![Value::Text("Alice".to_string())]),
    ]);
    let result = dsum_fn(&[db, Value::Text("Sales".to_string()), criteria]);
    assert_eq!(result, Value::Number(0.0));
}