logisheets_controller 0.7.0

the core of LogiSheets
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

use logisheets_base::column_label_to_index;
use regex::Regex;

lazy_static! {
    static ref A1_ADDR_REGEX: Regex = Regex::new(r#"\$?([A-Za-z]+)\$?([0-9]+)"#).unwrap();
}
// A1 => (0, 0)
pub fn parse_cell(r: &str) -> Option<(usize, usize)> {
    let capture = A1_ADDR_REGEX.captures_iter(&r).next()?;
    let c = capture.get(1)?.as_str();
    let r = capture.get(2)?.as_str();
    let col_idx = column_label_to_index(c);
    match r.parse::<usize>() {
        Ok(row_idx) => Some((row_idx - 1, col_idx)),
        Err(_) => None,
    }
}

pub fn parse_range(r: &str) -> Option<((usize, usize), (usize, usize))> {
    let mut s = r.split(':');
    let start = s.next()?.trim();
    let end = s.next()?.trim();
    let start_addr = parse_cell(start)?;
    let end_addr = parse_cell(end)?;
    Some((start_addr, end_addr))
}

#[cfg(test)]
mod tests {
    use super::{parse_cell, parse_range};
    #[test]
    fn parse_cell_test() {
        let s = "$A$2";
        let r = parse_cell(s);
        assert!(matches!(r, Some((1, 0))));
        let s = "A$2";
        let r = parse_cell(s);
        assert!(matches!(r, Some((1, 0))));
        let s = "AA2";
        let r = parse_cell(s);
        assert!(matches!(r, Some((1, 26))));
        let s = "AA20";
        let r = parse_cell(s);
        assert!(matches!(r, Some((19, 26))));
        let s = "A9";
        let r = parse_cell(s);
        assert!(matches!(r, Some((8, 0))));
    }

    #[test]
    fn parse_range_test() {
        let s = "A2:B4";
        let r = parse_range(s);
        assert!(matches!(r, Some(((1, 0), (3, 1)))));
    }
}