[Bug]: Endless ranges cause !ERROR when there is a starting cell, ie: A2:A (but A:A works)

[oodavid]

Description

• A:A - works
• A2:A99 - works
• A2:A - causes #!ERROR, I think this is unexpected (it works in excel / google sheets)

The demo shows this behaviour

Video or screenshots

No response

Demo

https://stackblitz.com/edit/sgkxpfpa?file=index.ts,index.html

HyperFormula version

3.2.0

Your framework

No response

Your environment

Chrome latest

[AMBudnik]

Thanks for flagging this, @oodavid. I can see why this felt unexpected, especially since the same reference works in Excel and Google Sheets.

This behavior is a current HyperFormula limitation. The documentation explains that HyperFormula does not treat single cells as ranges in the same way as Excel or Google Sheets, so a reference like A2:A is not supported.

Here is the relevant documentation:
https://hyperformula.handsontable.com/guide/cell-references.html#range-references

If helpful, I would be glad to suggest a workaround that fits your use case.