formualizer-eval 0.7.0

High-performance Arrow-backed Excel formula engine with dependency graph and incremental recalculation
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

//! Lookup and reference functions module
//!
//! This module contains all lookup and reference functions:
//! - Classic lookup: MATCH, VLOOKUP, HLOOKUP, CHOOSE
//! - Reference info: ROW, ROWS, COLUMN, COLUMNS
//! - Reference creation: ADDRESS

mod address;
mod array_shape;
mod choose;
mod core;
mod dynamic;
mod legacy; // classic LOOKUP function (vector & array forms)
pub(crate) mod lookup_utils; // shared helper utilities for lookup family
mod reference_info; // modern lookup & dynamic array subset (XLOOKUP, FILTER, UNIQUE)
mod stack; // stacking & concatenation functions (HSTACK, VSTACK)

pub use address::AddressFn;
pub use array_shape::{ToColFn, ToRowFn};
pub use choose::ChooseFn;
pub use core::{HLookupFn, MatchFn, VLookupFn};
pub use dynamic::{
    FilterFn, GroupByFn, PivotByFn, RandArrayFn, SortByFn, SortFn, UniqueFn, XLookupFn, XMatchFn,
};
pub use legacy::LookupFn;
pub use reference_info::{ColumnFn, ColumnsFn, RowFn, RowsFn};
pub use stack::{HStackFn, VStackFn};
// CHOOSECOLS / CHOOSEROWS live in choose.rs alongside CHOOSE
pub use choose::{ChooseColsFn, ChooseRowsFn};

/// Register all lookup and reference functions
pub fn register_builtins() {
    use crate::function_registry::register_function;
    use std::sync::Arc;

    // Classic lookup functions (from parent lookup.rs)
    register_function(Arc::new(MatchFn));
    register_function(Arc::new(VLookupFn));
    register_function(Arc::new(HLookupFn));

    // Legacy LOOKUP (vector & array forms)
    register_function(Arc::new(LookupFn));

    // Choose function
    register_function(Arc::new(ChooseFn));

    // Reference info functions
    register_function(Arc::new(RowFn));
    register_function(Arc::new(RowsFn));
    register_function(Arc::new(ColumnFn));
    register_function(Arc::new(ColumnsFn));

    // Address function
    register_function(Arc::new(AddressFn));

    // Dynamic / modern lookup subset (Sprint 5 initial)
    dynamic::register_builtins();

    // Stack and array-shaping functions
    stack::register_builtins();
    array_shape::register_builtins();

    // CHOOSECOLS / CHOOSEROWS
    register_function(Arc::new(choose::ChooseColsFn));
    register_function(Arc::new(choose::ChooseRowsFn));
}