Starstruk Logo MarkStarstruk

v1.0.144

msitarzewski/agency-agentsv1.0.144Aug 13, 2026by github-actions[bot]

AI Summary

This release fixes Excel calculation logic to match native Excel behavior regarding hidden rows and empty cells.

Key Highlights

  • SUBTOTAL ignores AutoFilter-hidden rows (1-11) and all hidden rows (101-111)
  • Comparison treats an empty cell as Excel's empty value, not text
  • Arithmetic coerces date/time-formatted text to its serial like Excel

New Features

  • Excel SUBTOTAL calculation fix for hidden rows
  • Empty cell comparison logic fix
  • Date/time arithmetic coercion to serial numbers

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