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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59

use crate::{
    calc_result::CalcResult,
    expressions::{parser::Node, types::CellReferenceIndex},
    model::Model,
    number_format::to_precision,
};

impl<'a> Model<'a> {
    // DELTA(number1, [number2])
    pub(crate) fn fn_delta(&mut self, args: &[Node], cell: CellReferenceIndex) -> CalcResult {
        let arg_count = args.len();
        if !(1..=2).contains(&arg_count) {
            return CalcResult::new_args_number_error(cell);
        }
        let number1 = match self.get_number_no_bools(&args[0], cell) {
            Ok(f) => f,
            Err(error) => return error,
        };
        let number2 = if arg_count > 1 {
            match self.get_number_no_bools(&args[1], cell) {
                Ok(f) => f,
                Err(error) => return error,
            }
        } else {
            0.0
        };

        if to_precision(number1, 16) == to_precision(number2, 16) {
            CalcResult::Number(1.0)
        } else {
            CalcResult::Number(0.0)
        }
    }

    // GESTEP(number, [step])
    pub(crate) fn fn_gestep(&mut self, args: &[Node], cell: CellReferenceIndex) -> CalcResult {
        let arg_count = args.len();
        if !(1..=2).contains(&arg_count) {
            return CalcResult::new_args_number_error(cell);
        }
        let number = match self.get_number_no_bools(&args[0], cell) {
            Ok(f) => f,
            Err(error) => return error,
        };
        let step = if arg_count > 1 {
            match self.get_number_no_bools(&args[1], cell) {
                Ok(f) => f,
                Err(error) => return error,
            }
        } else {
            0.0
        };
        if to_precision(number, 16) >= to_precision(step, 16) {
            CalcResult::Number(1.0)
        } else {
            CalcResult::Number(0.0)
        }
    }
}