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

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

#[test]
fn iso_format() {
    let args = [Value::Text("2024-01-15".to_string())];
    assert_eq!(datevalue_fn(&args), Value::Number(45306.0));
}

#[test]
fn us_slash_format() {
    let args = [Value::Text("1/15/2024".to_string())];
    assert_eq!(datevalue_fn(&args), Value::Number(45306.0));
}

#[test]
fn long_month_name() {
    let args = [Value::Text("January 15, 2024".to_string())];
    assert_eq!(datevalue_fn(&args), Value::Number(45306.0));
}

#[test]
fn short_month_name() {
    let args = [Value::Text("Jan 15, 2024".to_string())];
    assert_eq!(datevalue_fn(&args), Value::Number(45306.0));
}

#[test]
fn zero_padded_slash() {
    let args = [Value::Text("06/15/2024".to_string())];
    assert_eq!(datevalue_fn(&args), Value::Number(45458.0));
}