OfficeCLI Is Fixing Excel Semantics One Formula Edge Case at a Time — SUBTOTAL, Empty Cells, Date Coercion

GitHub·low signalXBlueskyLinkedInCopy link

iOfficeAI/OfficeCLI (28,277 stars), which bills itself as the first Office suite purpose-built for AI agents to read and edit Word/Excel, shipped v1.0.144 on 2026-08-13 with three spreadsheet-fidelity fixes from a first-time contributor: SUBTOTAL now ignores AutoFilter-hidden rows for codes 1-11 and all hidden rows for 101-111, comparisons treat an empty cell as Excel's empty value rather than text, and arithmetic coerces date/time-formatted text to its serial the way Excel does. These are the unglamorous compatibility details that decide whether an agent's spreadsheet output can be trusted downstream. Single-source (the release notes themselves), so treat the impact claim as unverified.