logisheets_parser 0.7.0

the parser of excel formula
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

use logisheets_base::SheetId;

use crate::ast;
use std::collections::HashSet;
use std::hash::Hash;

pub fn find_cell_references<T, F>(node: &ast::Node, filter: &F) -> HashSet<T>
where
    T: Hash + Eq,
    F: Fn(&ast::CellReference) -> Option<T>,
{
    match &node.pure {
        ast::PureNode::Func(func) => {
            let mut result = HashSet::<T>::new();
            func.args.iter().for_each(|arg| {
                let arg_result = find_cell_references(arg, filter);
                result.extend(arg_result);
            });
            result
        }
        ast::PureNode::Value(_) => HashSet::new(),
        ast::PureNode::Reference(r) => {
            let mut result = HashSet::new();
            if let Some(t) = filter(r) {
                result.insert(t);
            }
            result
        }
    }
}

pub fn is_range_vertex(reference: &ast::CellReference) -> Option<(ast::CellReference, SheetId)> {
    match reference {
        ast::CellReference::Mut(mut_ref) => {
            let sheet_id = mut_ref.sheet_id;
            match &mut_ref.reference {
                ast::MutRef::A1ReferenceRange(_) => Some((reference.clone(), sheet_id)),
                ast::MutRef::A1Reference(a1ref) => match a1ref {
                    ast::A1Reference::A1ColumnRange(_) => Some((reference.clone(), sheet_id)),
                    ast::A1Reference::A1RowRange(_) => Some((reference.clone(), sheet_id)),
                    ast::A1Reference::Addr(_) => None,
                },
            }
        }
        ast::CellReference::Name(_) => None,
        ast::CellReference::UnMut(_) => None,
    }
}

pub fn is_sts_vertex(
    reference: &ast::CellReference,
) -> Option<(SheetId, SheetId, ast::CellReference)> {
    match reference {
        ast::CellReference::Mut(_) => None,
        ast::CellReference::UnMut(unmut_ref) => match &unmut_ref.prefix {
            ast::UnMutRefPrefix::Local(l) => match l {
                ast::LocalUnMutRefPrefix::SheetToSheet(sts) => {
                    Some((sts.from_sheet, sts.to_sheet, reference.clone()))
                }
            },
            ast::UnMutRefPrefix::External(_) => None,
        },
        ast::CellReference::Name(_) => None,
    }
}