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
29
30
31
32
33
34
35
36

#![allow(clippy::unwrap_used)]

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

#[test]
fn computation() {
    let i2 = "=-C2*(1+D2)^E2-F2*((D2+1)*((1+D2)^E2-1))/D2";

    let mut model = new_empty_model();
    model._set("C2", "1");
    model._set("D2", "2");
    model._set("E2", "3");
    model._set("F2", "4");

    model._set("I2", i2);

    model.evaluate();

    assert_eq!(model._get_text("I2"), "-183");
    assert_eq!(model._get_formula("I2"), i2);
}

#[test]
fn format_as_currency() {
    let mut model = new_empty_model();
    model._set("C2", "1");
    model._set("D2", "2");
    model._set("E2", "3");
    model._set("F2", "4");

    model._set("I2", "=FV(D2,E2,F2,C2,1)");

    model.evaluate();

    assert_eq!(model._get_text("I2"), "-$183.00");
}