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

#![allow(clippy::panic)]

use crate::expressions::parser::Node;
use crate::expressions::types::CellReferenceRC;
use std::collections::HashMap;

use crate::expressions::parser::tests::utils::new_parser;

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

    // Reference cell is Sheet1!B3
    let cell_reference = CellReferenceRC {
        sheet: "Sheet1".to_string(),
        row: 3,
        column: 2,
    };
    let t = parser.parse("@A1:A10", &cell_reference);
    let child = Node::RangeKind {
        sheet_name: None,
        sheet_index: 0,
        absolute_row1: false,
        absolute_column1: false,
        row1: -2,
        column1: -1,
        absolute_row2: false,
        absolute_column2: false,
        row2: 7,
        column2: -1,
    };
    assert_eq!(
        t,
        Node::ImplicitIntersection {
            automatic: false,
            child: Box::new(child)
        }
    )
}

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

    // Reference cell is Sheet1!B3
    let cell_reference = CellReferenceRC {
        sheet: "Sheet1".to_string(),
        row: 3,
        column: 2,
    };
    let t = parser.parse("@A1:A10+12", &cell_reference);
    let child = Node::RangeKind {
        sheet_name: None,
        sheet_index: 0,
        absolute_row1: false,
        absolute_column1: false,
        row1: -2,
        column1: -1,
        absolute_row2: false,
        absolute_column2: false,
        row2: 7,
        column2: -1,
    };
    assert_eq!(
        t,
        Node::OpSumKind {
            kind: crate::expressions::token::OpSum::Add,
            left: Box::new(Node::ImplicitIntersection {
                automatic: false,
                child: Box::new(child)
            }),
            right: Box::new(Node::NumberKind(12.0))
        }
    )
}