v1.0.144

tt-a1i/archifyv1.0.144Aug 13, 2026by github-actions[bot]

AI Summary

This release focuses on bug fixes for Excel file processing, correcting SUBTOTAL logic for hidden rows and refining how empty cells and date/time text are interpreted to match Excel's native behavior.

Key Highlights

Fixes SUBTOTAL calculations to ignore hidden rows based on AutoFilter and manual hiding.
Corrects empty cell comparison logic to match Excel's empty value definition.
Improves date/time text arithmetic to match Excel's serial number conversion.

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