ganit-core 0.3.10

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

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

/// Serial for 2024-01-01 = 45292. TODAY() must be at or above that.
const MIN_SERIAL: f64 = 45292.0;

#[test]
fn returns_a_number() {
    assert!(matches!(today_fn(&[]), Value::Date(_)));
}

#[test]
fn result_is_after_2024_jan_01() {
    if let Value::Date(n) = today_fn(&[]) {
        assert!(n >= MIN_SERIAL, "today serial {n} should be >= {MIN_SERIAL}");
    } else {
        panic!("expected Date");
    }
}

#[test]
fn result_has_no_fractional_part() {
    if let Value::Date(n) = today_fn(&[]) {
        assert_eq!(n.fract(), 0.0, "TODAY() should be a whole number, got {n}");
    } else {
        panic!("expected Date");
    }
}