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

#![allow(clippy::unwrap_used)]

use crate::test::util::new_empty_model;

#[test]
fn test_formulas() {
    let mut model = new_empty_model();
    model
        .set_user_input(0, 1, 1, "$100.348".to_string())
        .unwrap();
    model
        .set_user_input(0, 1, 2, "=ISNUMBER(A1)".to_string())
        .unwrap();

    model.evaluate();

    assert_eq!(
        model.get_localized_cell_content(0, 1, 1).unwrap(),
        "100.348"
    );
    assert_eq!(
        model.get_localized_cell_content(0, 1, 2).unwrap(),
        "=ISNUMBER(A1)"
    );
    assert_eq!(model.get_localized_cell_content(0, 5, 5).unwrap(), "");

    assert!(model.get_localized_cell_content(1, 1, 2).is_err());
}