Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Azee94 opened this issue Apr 15, 2024 · 2 comments
Open

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

Azee94 opened this issue Apr 15, 2024 · 2 comments
Labels
Bug Something isn't working Function Feature or bug in formula function Impact: Medium

Comments

@Azee94
Copy link

Azee94 commented Apr 15, 2024

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
Copy link
Contributor

sequba commented Apr 17, 2024

@sequba
Copy link
Contributor

sequba commented Apr 17, 2024

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

@sequba sequba added Bug Something isn't working Function Feature or bug in formula function Impact: Medium labels Apr 17, 2024
@sequba sequba changed the title [Bug]: [Bug]: COLUMN doesn't work in the array arithmetic mode Apr 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working Function Feature or bug in formula function Impact: Medium
Projects
None yet
Development

No branches or pull requests

2 participants