formualizer-workbook 0.7.1

Ergonomic workbook API over the Formualizer engine (sheets, loaders, staging, undo/redo)
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

use crate::common::build_workbook;
use chrono::NaiveDate;
use formualizer_common::LiteralValue;
use formualizer_eval::engine::ingest::EngineLoadStream;
use formualizer_eval::engine::{Engine, EvalConfig};
use formualizer_workbook::{CalamineAdapter, SpreadsheetReader};

#[test]
fn calamine_date_arithmetic_propagates_date_tag() {
    // C107 = 2024-10-18 (serial 45583)
    // C108 = 1
    // C109 = C107 + (ROUND(C108,0) * 14) => 2024-11-01
    let path = build_workbook(|book| {
        let sh = book.get_sheet_by_name_mut("Sheet1").unwrap();

        // C107
        sh.get_cell_mut((3, 107)).set_value_number(45583.0);
        let _ = sh
            .get_style_mut("C107")
            .get_number_format_mut()
            .set_format_code(umya_spreadsheet::NumberingFormat::FORMAT_DATE_XLSX14);

        // C108
        sh.get_cell_mut((3, 108)).set_value_number(1.0);

        // C109
        sh.get_cell_mut((3, 109))
            .set_formula("=C107+(ROUND(C108,0)*14)");
    });

    let mut backend = CalamineAdapter::open_path(&path).expect("open via calamine");
    let ctx = formualizer_eval::test_workbook::TestWorkbook::new();
    let mut engine: Engine<_> = Engine::new(ctx, EvalConfig::default());
    backend
        .stream_into_engine(&mut engine)
        .expect("stream into engine");
    engine.evaluate_all().expect("evaluate");

    match engine.get_cell_value("Sheet1", 109, 3) {
        Some(LiteralValue::Date(d)) => {
            assert_eq!(d, NaiveDate::from_ymd_opt(2024, 11, 1).unwrap());
        }
        Some(LiteralValue::DateTime(dt)) => {
            assert_eq!(dt.date(), NaiveDate::from_ymd_opt(2024, 11, 1).unwrap());
        }
        other => panic!("expected date-like at Sheet1!C109, got {other:?}"),
    }
}