spreadsheet-mcp 0.10.1

Stateful MCP server for spreadsheet analysis and editing — token-efficient tools for LLM agents to read, profile, edit, and recalculate .xlsx workbooks
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

#![cfg(feature = "recalc")]

use serde_json::json;
use spreadsheet_mcp::tools::write_normalize::{EditBatchParamsInput, normalize_edit_batch};

#[test]
fn edit_batch_accepts_shorthand_and_formula() {
    let input = json!({
        "fork_id": "f1",
        "sheet_name": "Inputs",
        "edits": [
            "A1=Hello",
            "B2==SUM(A3:A4)",
            { "address": "C3", "formula": "SUM(A1:A2)" },
            { "address": "D4", "value": "=NOT_A_FORMULA" },
            { "address": "E5", "value": "=ALWAYS_FORMULA", "is_formula": false },
            { "address": "F6", "formula": "=SUM(B1:B2)" }
        ]
    });

    let params: EditBatchParamsInput = serde_json::from_value(input).unwrap();
    let (normalized, warnings) = normalize_edit_batch(params).unwrap();

    assert_eq!(normalized.edits[0].address, "A1");
    assert_eq!(normalized.edits[0].value, "Hello");
    assert!(!normalized.edits[0].is_formula);

    assert_eq!(normalized.edits[1].address, "B2");
    assert_eq!(normalized.edits[1].value, "SUM(A3:A4)");
    assert!(normalized.edits[1].is_formula);

    assert_eq!(normalized.edits[2].value, "SUM(A1:A2)");
    assert!(normalized.edits[2].is_formula);

    assert_eq!(normalized.edits[4].value, "ALWAYS_FORMULA");
    assert!(normalized.edits[4].is_formula);

    assert_eq!(normalized.edits[5].value, "SUM(B1:B2)");
    assert!(normalized.edits[5].is_formula);

    assert!(warnings.iter().any(|w| w.code == "WARN_SHORTHAND_EDIT"));
    assert!(warnings.iter().any(|w| w.code == "WARN_FORMULA_PREFIX"));
}

#[test]
fn edit_batch_rejects_shorthand_without_equals() {
    let input = json!({
        "fork_id": "f1",
        "sheet_name": "Inputs",
        "edits": ["A1"]
    });

    let params: EditBatchParamsInput = serde_json::from_value(input).unwrap();
    let err = normalize_edit_batch(params).unwrap_err();

    assert!(err.to_string().contains("invalid shorthand edit"));
}

#[test]
fn edit_batch_shorthand_allows_space_before_formula() {
    let input = json!({
        "fork_id": "f1",
        "sheet_name": "Inputs",
        "edits": ["A1 = =SUM(A1:A2)"]
    });

    let params: EditBatchParamsInput = serde_json::from_value(input).unwrap();
    let (normalized, warnings) = normalize_edit_batch(params).unwrap();

    assert_eq!(normalized.edits[0].address, "A1");
    assert_eq!(normalized.edits[0].value, "SUM(A1:A2)");
    assert!(normalized.edits[0].is_formula);
    assert!(warnings.iter().any(|w| w.code == "WARN_FORMULA_PREFIX"));
}