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::unwrap_used)]

use crate::{expressions::types::Area, types::Border, BorderArea, UserModel};

pub fn new_empty_user_model<'a>() -> UserModel<'a> {
    UserModel::new_empty("model", "en", "UTC", "en").unwrap()
}

impl<'a> UserModel<'a> {
    pub fn _set_cell_border(&mut self, cell: &str, color: &str) {
        let cell_reference = self.model._parse_reference(cell);
        let column = cell_reference.column;
        let row = cell_reference.row;
        let border_area: BorderArea = serde_json::from_str(&format!(
            r##"{{
                "item": {{
                    "style": "thin",
                    "color": "{color}"
                }},
                "type": "All"
            }}"##
        ))
        .unwrap();
        let range = &Area {
            sheet: 0,
            row,
            column,
            width: 1,
            height: 1,
        };
        self.set_area_with_border(range, &border_area).unwrap();
    }

    pub fn _set_area_border(&mut self, range: &str, color: &str, kind: &str) {
        let s: Vec<&str> = range.split(':').collect();
        let left = self.model._parse_reference(s[0]);
        let right = self.model._parse_reference(s[1]);
        let column = left.column;
        let row = left.row;
        let width = right.column - column + 1;
        let height = right.row - row + 1;
        let border_area: BorderArea = serde_json::from_str(&format!(
            r##"{{
                "item": {{
                    "style": "thin",
                    "color": "{color}"
                }},
                "type": "{kind}"
            }}"##
        ))
        .unwrap();
        let range = &Area {
            sheet: 0,
            row,
            column,
            width,
            height,
        };
        self.set_area_with_border(range, &border_area).unwrap();
    }

    pub fn _get_cell_border(&self, cell: &str) -> Border {
        let cell_reference = self.model._parse_reference(cell);
        let column = cell_reference.column;
        let row = cell_reference.row;
        let style = self.get_cell_style(0, row, column).unwrap();
        style.border
    }

    pub fn _get_cell_actual_border(&self, cell: &str) -> Border {
        let cell_reference = self.model._parse_reference(cell);
        let column = cell_reference.column;
        let row = cell_reference.row;
        let style = self.model.get_style_for_cell(0, row, column).unwrap();
        style.border
    }
}