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

#![allow(clippy::panic)]

use std::collections::HashMap;

use crate::expressions::parser::tests::utils::{new_parser, to_english_localized_string};
use crate::expressions::types::CellReferenceRC;

#[test]
fn issue_155_parser() {
    let worksheets = vec!["Sheet1".to_string()];
    let mut parser = new_parser(worksheets, vec![], HashMap::new());

    // Reference cell is Sheet1!A1
    let cell_reference = CellReferenceRC {
        sheet: "Sheet1".to_string(),
        row: 2,
        column: 2,
    };
    let t = parser.parse("A$1:A2", &cell_reference);
    assert_eq!(to_english_localized_string(&t, &cell_reference), "A$1:A2");
}

#[test]
fn issue_155_parser_case_2() {
    let worksheets = vec!["Sheet1".to_string()];
    let mut parser = new_parser(worksheets, vec![], HashMap::new());

    // Reference cell is Sheet1!A1
    let cell_reference = CellReferenceRC {
        sheet: "Sheet1".to_string(),
        row: 20,
        column: 20,
    };
    let t = parser.parse("C$1:D2", &cell_reference);
    assert_eq!(to_english_localized_string(&t, &cell_reference), "C$1:D2");
}

#[test]
fn issue_155_parser_only_row() {
    let worksheets = vec!["Sheet1".to_string()];
    let mut parser = new_parser(worksheets, vec![], HashMap::new());

    // Reference cell is Sheet1!A1
    let cell_reference = CellReferenceRC {
        sheet: "Sheet1".to_string(),
        row: 20,
        column: 20,
    };
    // This is tricky, I am not sure what to do in these cases
    let t = parser.parse("A$2:B1", &cell_reference);
    assert_eq!(to_english_localized_string(&t, &cell_reference), "A1:B$2");
}

#[test]
fn issue_155_parser_only_column() {
    let worksheets = vec!["Sheet1".to_string()];
    let mut parser = new_parser(worksheets, vec![], HashMap::new());

    // Reference cell is Sheet1!A1
    let cell_reference = CellReferenceRC {
        sheet: "Sheet1".to_string(),
        row: 20,
        column: 20,
    };
    // This is tricky, I am not sure what to do in these cases
    let t = parser.parse("D1:$A3", &cell_reference);
    assert_eq!(to_english_localized_string(&t, &cell_reference), "$A1:D3");
}