v1.0.144

every-app/open-seov1.0.144Aug 13, 2026by github-actions[bot]

AI Summary

This release corrects core Excel processing logic to match native Excel behavior, specifically fixing how the library handles hidden rows in SUBTOTAL functions, empty cell comparisons, and date/time text conversions.

Key Highlights

Fixed SUBTOTAL ignoring AutoFilter and hidden rows.
Fixed empty cell comparison logic.
Fixed arithmetic coercion of date/time text to serial numbers.

New Features

Excel SUBTOTAL hidden row fix
Excel empty cell comparison fix
Excel date/time text coercion fix

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