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

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

#[test]
fn too_few_args() {
    assert_eq!(rate_fn(&[Value::Number(5.0), Value::Number(-100.0)]), Value::Error(ErrorKind::NA));
}

#[test]
fn too_many_args() {
    let args = vec![Value::Number(0.1), Value::Number(0.1), Value::Number(0.1),
                    Value::Number(0.1), Value::Number(0.1), Value::Number(0.1),
                    Value::Number(0.1)];
    assert_eq!(rate_fn(&args), Value::Error(ErrorKind::NA));
}

#[test]
fn non_numeric_nper() {
    let args = [Value::Text("bad".to_string()), Value::Number(-100.0), Value::Number(1000.0)];
    assert_eq!(rate_fn(&args), Value::Error(ErrorKind::Value));
}

#[test]
fn no_convergence_bad_inputs() {
    // Nonsensical inputs: pv=0, pmt=0, fv=0 — no convergence
    let args = [Value::Number(5.0), Value::Number(0.0), Value::Number(0.0)];
    // May converge to 0 or fail — just confirm it returns Number or Num error
    let result = rate_fn(&args);
    assert!(matches!(result, Value::Number(_) | Value::Error(ErrorKind::Num)));
}