search

handsontable / hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting.
https://hyperformula.handsontable.com/
GNU General Public License v3.0
1.88k stars 107 forks source link

[Bug]: `COLUMN` doesn't work in the array arithmetic mode #1407

Open Azee94 opened 2 months ago

Azee94 commented 2 months ago

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

sequba commented 2 months ago

A Stackblitz demo created by @AMBudnik: https://stackblitz.com/edit/vitejs-vite-jqrj9a?file=index.html,main.js&terminal=dev

sequba commented 2 months ago

@Azee94 thank you for reporting this issue. It seems like there is a bug in the implementation of COLUMN.