Forum Discussion
why hstack change the cell type ?
- Internally and until passed to the worksheet, yes.
Riny_van_Eekelen But this is really strange , have look at following figure please. I fill B1 with formula
=LET(x,HSTACK(SEQUENCE(9),A1:A9),HSTACK(x,BYROW(x,LAMBDA(row,ISBLANK(INDEX(row,2))))))
D2 show that C2 is blank, but what C2 show is zero. So what's the real value of C2? Many thanks!
Why is it so strange? Internally, those are considered blanks, though when returned to actual worksheet cells they are by default rendered as numerical zeroes.
JosWoolley So both values of A2 and C2 are blanks? If so, why are they rendered differently with the same cell format (I've changed cell format of A2 and C2 to the same)? Many thanks!
A2 is a blank. C2 is a zero, not a blank, but your formula considers it a blank since it processes it internally prior to its being rendered a zero by being passed to the worksheet.
JosWoolley So at least INDEX(x,2,2) is blank, right?