hyperformula icon indicating copy to clipboard operation
hyperformula copied to clipboard
verified publisher icon handsontable

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

Open Azee94 opened this issue 1 year ago • 2 comments

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

Azee94 avatar Apr 15 '24 18:04 Azee94

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

sequba avatar Apr 17 '24 13:04 sequba

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

sequba avatar Apr 17 '24 13:04 sequba