ganit-core 0.4.2

Spreadsheet formula engine — parser and evaluator for Excel-compatible formulas
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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74

use crate::eval::functions::check_arity;
use crate::types::{ErrorKind, Value};
use super::cell_ref::col_index_to_label;

/// `ADDRESS(row, col, [abs_mode], [a1], [sheet_text])`
/// Returns a cell address string.
/// abs_mode: 1=$A$1, 2=A$1, 3=$A1, 4=A1
/// a1: TRUE=A1 style (default), FALSE=R1C1 style
pub fn address_fn(args: &[Value]) -> Value {
    if let Some(err) = check_arity(args, 2, 5) {
        return err;
    }

    let row = match &args[0] {
        Value::Number(n) => {
            let n = n.trunc() as i64;
            if n < 1 { return Value::Error(ErrorKind::Value); }
            n as usize
        }
        _ => return Value::Error(ErrorKind::Value),
    };

    let col = match &args[1] {
        Value::Number(n) => {
            let n = n.trunc() as i64;
            if n < 1 { return Value::Error(ErrorKind::Value); }
            n as usize
        }
        _ => return Value::Error(ErrorKind::Value),
    };

    let abs_mode = if args.len() >= 3 {
        match &args[2] {
            Value::Number(n) => n.trunc() as i64,
            _ => return Value::Error(ErrorKind::Value),
        }
    } else {
        1
    };

    let a1_style = if args.len() >= 4 {
        match &args[3] {
            Value::Bool(b) => *b,
            Value::Number(n) => *n != 0.0,
            _ => return Value::Error(ErrorKind::Value),
        }
    } else {
        true
    };

    // Sheet prefix is ignored in standalone evaluator (no multi-sheet support)

    let addr = if a1_style {
        let col_label = col_index_to_label(col);
        match abs_mode {
            1 => format!("${col_label}${row}"),
            2 => format!("{col_label}${row}"),
            3 => format!("${col_label}{row}"),
            4 => format!("{col_label}{row}"),
            _ => return Value::Error(ErrorKind::Value),
        }
    } else {
        // R1C1 style
        match abs_mode {
            1 => format!("R{row}C{col}"),
            2 => format!("R{row}C[{col}]"),
            3 => format!("R[{row}]C{col}"),
            4 => format!("R[{row}]C[{col}]"),
            _ => return Value::Error(ErrorKind::Value),
        }
    };

    Value::Text(addr)
}