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

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

#[test]
fn quartile_q5_returns_num_error() {
    // quart=5 out of range → #NUM!
    let arr = Value::Array(vec![Value::Number(1.0), Value::Number(2.0)]);
    assert_eq!(quartile_fn(&[arr, Value::Number(5.0)]), Value::Error(ErrorKind::Num));
}

#[test]
fn quartile_negative_quart_returns_num_error() {
    // quart=-1 → #NUM!
    let arr = Value::Array(vec![Value::Number(1.0), Value::Number(2.0)]);
    assert_eq!(quartile_fn(&[arr, Value::Number(-1.0)]), Value::Error(ErrorKind::Num));
}

#[test]
fn quartile_empty_array_returns_num_error() {
    let arr = Value::Array(vec![]);
    assert_eq!(quartile_fn(&[arr, Value::Number(1.0)]), Value::Error(ErrorKind::Num));
}

#[test]
fn quartile_fractional_quart_returns_num_error() {
    // quart=1.5 not integer → #NUM!
    let arr = Value::Array(vec![Value::Number(1.0), Value::Number(2.0)]);
    assert_eq!(quartile_fn(&[arr, Value::Number(1.5)]), Value::Error(ErrorKind::Num));
}