v1.0.144
iOfficeAI/OfficeCLIv1.0.144Aug 13, 2026by github-actions[bot]
AI Summary
This release focuses on improving Excel (xlsx) handling accuracy, specifically regarding hidden rows, empty cell comparisons, and date arithmetic.
Key Highlights
- Fixed SUBTOTAL function to correctly ignore hidden rows (AutoFilter and all hidden types).
- Corrected comparison logic to treat empty cells as Excel's native empty value.
- Fixed arithmetic operations to coerce date/time-formatted text to serial numbers.
Full Release Notes
## What's Changed * fix(xlsx): SUBTOTAL ignores AutoFilter-hidden rows (1-11) and all hidden rows (101-111) by @JiaZhengOng in https://github.com/iOfficeAI/OfficeCLI/pull/270 * fix(xlsx): comparison treats an empty cell as Excel's empty value, not text by @JiaZhengOng in https://github.com/iOfficeAI/OfficeCLI/pull/271 * fix(xlsx): arithmetic coerces date/time-formatted text to its serial like Excel by @JiaZhengOng in https://github.com/iOfficeAI/OfficeCLI/pull/276 ## New Contributors * @JiaZhengOng made their first contribution in https://github.com/iOfficeAI/OfficeCLI/pull/270 **Full Changelog**: https://github.com/iOfficeAI/OfficeCLI/compare/v1.0.143...v1.0.144