ganit-core 0.4.1

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

use super::super::*;
use crate::types::{ErrorKind, Value};

// ---------------------------------------------------------------------------
// PRICEDISC failures
// ---------------------------------------------------------------------------

#[test]
fn pricedisc_too_few_args() {
    let args = [Value::Number(44927.0), Value::Number(45108.0), Value::Number(0.05)];
    assert_eq!(pricedisc_fn(&args), Value::Error(ErrorKind::NA));
}

#[test]
fn pricedisc_settlement_after_maturity() {
    // settlement >= maturity → #NUM!
    let args = [
        Value::Number(45108.0), // maturity as settlement
        Value::Number(44927.0), // settlement as maturity
        Value::Number(0.05),
        Value::Number(100.0),
    ];
    assert_eq!(pricedisc_fn(&args), Value::Error(ErrorKind::Num));
}

// ---------------------------------------------------------------------------
// DISC failures
// ---------------------------------------------------------------------------

#[test]
fn disc_too_few_args() {
    let args = [Value::Number(44927.0), Value::Number(45108.0), Value::Number(97.5)];
    assert_eq!(disc_fn(&args), Value::Error(ErrorKind::NA));
}

#[test]
fn disc_zero_redemption() {
    // redemption = 0 → #NUM!
    let args = [
        Value::Number(44927.0),
        Value::Number(45108.0),
        Value::Number(97.5),
        Value::Number(0.0),
    ];
    assert_eq!(disc_fn(&args), Value::Error(ErrorKind::Num));
}

// ---------------------------------------------------------------------------
// TBILLPRICE failures
// ---------------------------------------------------------------------------

#[test]
fn tbillprice_too_few_args() {
    let args = [Value::Number(44927.0), Value::Number(45108.0)];
    assert_eq!(tbillprice_fn(&args), Value::Error(ErrorKind::NA));
}

#[test]
fn tbillprice_zero_discount() {
    // discount <= 0 → #NUM!
    let args = [
        Value::Number(44927.0),
        Value::Number(45108.0),
        Value::Number(0.0),
    ];
    assert_eq!(tbillprice_fn(&args), Value::Error(ErrorKind::Num));
}

// ---------------------------------------------------------------------------
// COUPDAYS failures
// ---------------------------------------------------------------------------

#[test]
fn coupdays_too_few_args() {
    let args = [Value::Number(44927.0), Value::Number(45658.0)];
    assert_eq!(coupdays_fn(&args), Value::Error(ErrorKind::NA));
}

#[test]
fn coupdays_invalid_frequency() {
    // frequency=3 is invalid (only 1, 2, 4 allowed)
    let args = [
        Value::Number(44927.0),
        Value::Number(45658.0),
        Value::Number(3.0),
    ];
    assert_eq!(coupdays_fn(&args), Value::Error(ErrorKind::Num));
}