ironcalc 0.8.3

The democratization of spreadsheets
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

#![allow(clippy::unwrap_used)]
#![allow(clippy::panic)]

use ironcalc::import::load_from_xlsx;

#[test]
fn test_import_randarray_correctly() {
    let mut model = load_from_xlsx("tests/DynamicArrays.xlsx", "en", "UTC", "en").unwrap();
    model.evaluate();
    // B20
    let cell_b20 = model.get_localized_cell_content(0, 20, 2).unwrap();

    // A19 has the formula RANDARRAY(3,3,0,100,TRUE) in the DynamicArrays.xlsx file,
    // which should return a 3x3 array of random integers between 0 and 100.
    let cell_b20_value = cell_b20
        .parse::<i32>()
        .unwrap_or_else(|_| panic!("Expected B20 to contain an integer, got {:?}", cell_b20));
    assert!(
        (0..=100).contains(&cell_b20_value),
        "Expected B20 to contain an integer in [0, 100], got {}",
        cell_b20_value
    );
}