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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101

#![allow(clippy::unwrap_used)]

use crate::{
    expressions::{
        lexer::{Lexer, LexerMode},
        token::{Error, TokenType},
    },
    language::get_language,
    locale::get_default_locale,
};

fn new_language_lexer<'a>(formula: &str, language: &str) -> Lexer<'a> {
    let locale = get_default_locale();
    let language = get_language(language).unwrap();
    Lexer::new(formula, LexerMode::A1, locale, language)
}

// Spanish

#[test]
fn test_verdadero_falso() {
    let mut lx = new_language_lexer("IF(A1, VERDADERO, FALSO)", "es");
    assert_eq!(lx.next_token(), TokenType::Ident("IF".to_string()));
    assert_eq!(lx.next_token(), TokenType::LeftParenthesis);
    assert!(matches!(lx.next_token(), TokenType::Reference { .. }));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Boolean(true));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Boolean(false));
    assert_eq!(lx.next_token(), TokenType::RightParenthesis);
    assert_eq!(lx.next_token(), TokenType::EOF);
}

#[test]
fn test_spanish_errors_ref() {
    let mut lx = new_language_lexer("#¡REF!", "es");
    assert_eq!(lx.next_token(), TokenType::Error(Error::REF));
    assert_eq!(lx.next_token(), TokenType::EOF);
}

// German

#[test]
fn test_wahr_falsch() {
    let mut lx = new_language_lexer("IF(A1, WAHR, FALSCH)", "de");
    assert_eq!(lx.next_token(), TokenType::Ident("IF".to_string()));
    assert_eq!(lx.next_token(), TokenType::LeftParenthesis);
    assert!(matches!(lx.next_token(), TokenType::Reference { .. }));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Boolean(true));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Boolean(false));
    assert_eq!(lx.next_token(), TokenType::RightParenthesis);
    assert_eq!(lx.next_token(), TokenType::EOF);
}

#[test]
fn test_german_errors_ref() {
    let mut lx = new_language_lexer("#BEZUG!", "de");
    assert_eq!(lx.next_token(), TokenType::Error(Error::REF));
    assert_eq!(lx.next_token(), TokenType::EOF);
}

// French

#[test]
fn test_vrai_faux() {
    let mut lx = new_language_lexer("IF(A1, VRAI, FAUX)", "fr");
    assert_eq!(lx.next_token(), TokenType::Ident("IF".to_string()));
    assert_eq!(lx.next_token(), TokenType::LeftParenthesis);
    assert!(matches!(lx.next_token(), TokenType::Reference { .. }));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Boolean(true));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Boolean(false));
    assert_eq!(lx.next_token(), TokenType::RightParenthesis);
    assert_eq!(lx.next_token(), TokenType::EOF);
}

#[test]
fn test_french_errors_ref() {
    let mut lx = new_language_lexer("#REF!", "fr");
    assert_eq!(lx.next_token(), TokenType::Error(Error::REF));
    assert_eq!(lx.next_token(), TokenType::EOF);
}

// English with errors

#[test]
fn test_english_with_spanish_words() {
    let mut lx = new_language_lexer("IF(A1, VERDADERO, FALSO)", "en");
    assert_eq!(lx.next_token(), TokenType::Ident("IF".to_string()));
    assert_eq!(lx.next_token(), TokenType::LeftParenthesis);
    assert!(matches!(lx.next_token(), TokenType::Reference { .. }));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Ident("VERDADERO".to_string()));
    assert_eq!(lx.next_token(), TokenType::Comma);
    assert_eq!(lx.next_token(), TokenType::Ident("FALSO".to_string()));
    assert_eq!(lx.next_token(), TokenType::RightParenthesis);
    assert_eq!(lx.next_token(), TokenType::EOF);
}