formualizer-parse 3.2.0

High-performance Excel/OpenFormula tokenizer + parser with a stable AST surface
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

use formualizer_parse::{parse, pretty::canonical_formula};

#[test]
fn unions_nested_in_delimited_expressions_keep_their_grouping() {
    for (source, expected) in [
        ("=SUM((A1,B1)+1)", "=SUM((A1, B1) + 1)"),
        ("=SUM(1+(A1,B1))", "=SUM(1 + (A1, B1))"),
        ("=SUM(-(A1,B1))", "=SUM(-(A1, B1))"),
        ("=SUM((A1,B1)%,C1)", "=SUM((A1, B1)%, C1)"),
        ("=SUM((A1,B1,C1)+D1)", "=SUM((A1, B1, C1) + D1)"),
        ("=SUM(((A1,B1)+C1)*D1)", "=SUM((A1, B1 + C1) * D1)"),
    ] {
        let original = parse(source).unwrap();
        let printed = canonical_formula(&original);
        assert_eq!(printed, expected, "{source}");
        assert_eq!(
            parse(&printed).unwrap().fingerprint(),
            original.fingerprint(),
            "{source} -> {printed}"
        );
    }
}