ironcalc_base 0.7.1

Open source spreadsheet engine
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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

#![allow(clippy::unwrap_used)]

use crate::model::Model;

#[test]
fn us_locale() {
    // en-US locale with MM/DD/YYYY format
    let mut model = Model::new_empty("model", "en", "UTC", "en").unwrap();

    model._set("A1", "10/02/2026");
    model._set("A2", "=DAY(A1)");
    model._set("A3", "=MONTH(A1)");
    model._set("A4", "=YEAR(A1)");
    model.evaluate();

    assert_eq!(model._get_text("A2"), "2");
    assert_eq!(model._get_text("A3"), "10");
    assert_eq!(model._get_text("A4"), "2026");
}

#[test]
fn uk_locale() {
    // en-GB locale with DD/MM/YYYY format
    let mut model = Model::new_empty("model", "en-GB", "UTC", "en").unwrap();

    model._set("A1", "10/02/2026");
    model._set("A2", "=DAY(A1)");
    model._set("A3", "=MONTH(A1)");
    model._set("A4", "=YEAR(A1)");
    model.evaluate();

    assert_eq!(model._get_text("A2"), "10");
    assert_eq!(model._get_text("A3"), "2");
    assert_eq!(model._get_text("A4"), "2026");
}

#[test]
fn es_locale() {
    // es-ES locale with DD/MM/YYYY format
    let mut model = Model::new_empty("model", "es", "UTC", "en").unwrap();

    model._set("A1", "10/marzo/2026");
    model._set("A2", "=DAY(A1)");
    model._set("A3", "=MONTH(A1)");
    model._set("A4", "=YEAR(A1)");
    model.evaluate();

    assert_eq!(model._get_text("A2"), "10");
    assert_eq!(model._get_text("A3"), "3");
    assert_eq!(model._get_text("A4"), "2026");
}

#[test]
fn fr_locale() {
    // fr-FR locale with DD/MM/YYYY format
    let mut model = Model::new_empty("model", "fr", "UTC", "en").unwrap();
    model._set("A1", "10/mars/2026");
    model._set("A2", "=DAY(A1)");
    model._set("A3", "=MONTH(A1)");
    model._set("A4", "=YEAR(A1)");
    model.evaluate();
    assert_eq!(model._get_text("A2"), "10");
    assert_eq!(model._get_text("A3"), "3");
    assert_eq!(model._get_text("A4"), "2026");
}