truecalc-core 0.6.4

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

use super::super::*;
use crate::types::Value;

fn approx(a: Value, b: f64, tol: f64) -> bool {
    if let Value::Number(n) = a { (n - b).abs() < tol } else { false }
}

#[test]
fn pricedisc_zero_discount_returns_num() {
    // GS (and Excel) require discount > 0; discount=0 returns #NUM!
    let args = [
        Value::Number(44927.0), // 2023-01-01
        Value::Number(45108.0), // 2023-07-01
        Value::Number(0.0),     // discount = 0%
        Value::Number(100.0),
    ];
    assert_eq!(pricedisc_fn(&args), Value::Error(crate::types::ErrorKind::Num));
}

#[test]
fn coupdays_annual_frequency() {
    // COUPDAYS with frequency=1 (annual): 30/360 basis → 360 days
    let args = [
        Value::Number(44927.0), // 2023-01-01
        Value::Number(45658.0), // 2025-01-01
        Value::Number(1.0),     // annual
        Value::Number(0.0),     // basis: 30/360
    ];
    assert!(approx(coupdays_fn(&args), 360.0, 1e-4));
}