handsontable / handsontable/hyperformula
[Bug]: `COLUMN` doesn't work in the array arithmetic mode
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 2.8k
- Forks
- 171
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 7
Description
Description
While trying to use the ARRAYFORMULA with COLUMN function inside to get the column number based on an if condition it only prints out the first column number
formula:
=ARRAYFORMULA(IF(H6:L6>10, COLUMN(H6:L6)))
Video or screenshots
https://www.loom.com/share/139860f5fbb7447bb51a432ab7ca2c42?sid=b9c9d134-c0d7-4372-94d9-8b0b1d7446e6
Demo
https://www.loom.com/share/139860f5fbb7447bb51a432ab7ca2c42?sid=b9c9d134-c0d7-4372-94d9-8b0b1d7446e6
HyperFormula version
2.5
Your framework
vanilla JS
Your environment
Chrome Version 122.0.6261.94 (Official Build) (arm64) on Mac OS
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the reported formula =ARRAYFORMULA(IF(H6:L6>10, COLUMN(H6:L6))) in HyperFormula 2.5, then trace the ARRAYFORMULA and COLUMN evaluation paths. Confirm the expected result for each column in H6:L6 and verify that the corrected behavior returns the corresponding column numbers rather than only the first one.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript
- Domain
- backend
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100