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

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

#[test]
fn small_ignores_text_and_bool_in_array() {
    // Only numbers counted; text/bool ignored
    let arr = Value::Array(vec![
        Value::Number(10.0),
        Value::Text("abc".to_string()),
        Value::Bool(false),
        Value::Number(5.0),
    ]);
    // SMALL([10, "abc", false, 5], 1) = 5
    assert_eq!(small_fn(&[arr, Value::Number(1.0)]), Value::Number(5.0));
}

#[test]
fn small_duplicate_values() {
    // SMALL([3,3,3], 2) = 3
    let arr = Value::Array(vec![
        Value::Number(3.0), Value::Number(3.0), Value::Number(3.0),
    ]);
    assert_eq!(small_fn(&[arr, Value::Number(2.0)]), Value::Number(3.0));
}

#[test]
fn small_negative_values() {
    // SMALL([-5,-3,-1], 1) = -5
    let arr = Value::Array(vec![
        Value::Number(-5.0), Value::Number(-3.0), Value::Number(-1.0),
    ]);
    assert_eq!(small_fn(&[arr, Value::Number(1.0)]), Value::Number(-5.0));
}

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