Starstruk Logo MarkStarstruk

v1.0.144

macro-inc/macrov1.0.144Aug 13, 2026by github-actions[bot]

AI Summary

Fixes Excel SUBTOTAL function behavior regarding hidden rows and resolves issues with empty cell comparisons and date/time arithmetic.

Key Highlights

  • Fixed SUBTOTAL ignoring AutoFilter-hidden rows (1-11) and all hidden rows (101-111)
  • Fixed comparison treating an empty cell as Excel's empty value, not text
  • Fixed arithmetic coercing date/time-formatted text to its serial like Excel

New Features

  • SUBTOTAL ignores hidden rows fix
  • Empty cell comparison fix
  • Arithmetic date/time 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