v1.0.144

bilawalsidhu/gods-eye-viewv1.0.144Aug 13, 2026by github-actions[bot]

AI Summary

This release focuses on correcting Excel XLSX handling logic, specifically fixing SUBTOTAL calculations with hidden rows and aligning empty cell and date/time text behavior with Excel's native standards.

Key Highlights

Fixed SUBTOTAL function to correctly ignore hidden rows (AutoFilter and manual)
Corrected empty cell comparison logic to match Excel behavior
Fixed arithmetic coercion for date/time formatted text
New contributor @JiaZhengOng made their first contribution

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