v1.0.144

affaan-m/ECCv1.0.144Aug 13, 2026by github-actions[bot]

AI Summary

This release focuses on correcting Excel calculation behaviors, specifically fixing how the SUBTOTAL function handles hidden rows and ensuring empty cells are treated correctly during comparisons and arithmetic.

Key Highlights

SUBTOTAL function now correctly ignores hidden rows
Empty cells are treated as Excel's empty value in comparisons
Date/time formatted text is correctly coerced to serial numbers in arithmetic
New contributor @JiaZhengOng

New Features

SUBTOTAL ignores hidden rows
Empty cell comparison logic fix
Date/time text arithmetic 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