FN-CHOOSE-001: An array index in CHOOSE turns selected blank cells into 0
Quirk · measured · recorded 2026-11-04
When an array index_num lifts CHOOSE in dynamic-array Excel, selected empty cells come back as the number 0 rather than as blank references, so ISBLANK over them is FALSE. With a scalar index the selected reference survives: ISREF(CHOOSE(1,ref)) was recorded TRUE.
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
=ISBLANK(CHOOSE({1,2},Data!Z1,Data!Z2))formula-literal | As typed | {FALSE,FALSE} | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=ISREF(CHOOSE(1,[ylr-source.xlsx]Sheet1!A1))formula-literal | As typed | TRUE | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
Basis: One recorded array reading, with ROWS 1 and COLUMNS 2 from observer cells, and one scalar ISREF reading with a reference to another workbook.
Inferred: That a scalar index over an empty cell gives ISBLANK TRUE is inferred from the ISREF reading. No ISBLANK reading of it is recorded.
Evidence and capture sources
- DnaCalc · crates/calc-func/tests/captures/fn2_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn2_q193
- DnaCalc · .beads/issues.jsonl 1ec418b2c1301d36309d717999512776b1d8630d · dc-b1l.24 review record
- DnaCalc · crates/calc-func/tests/captures/fn2_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn2_q193, row 20, column 10
- DnaCalc · crates/calc-host/tests/captures/dc_ylr/oracle.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet Main, row 54, column 1 The recorded formula names the source workbook by its full path