Hacker News Reader

1980phipsi

Excel has had array formulas since at least 2003.

I believe the OP is referring to array formulas which effectively explode the results into multiple cells, which was introduced in 2018.

Exactly. I’m not sure what to call the new feature, “array spillage”? I didn’t know the original was called “array formulas”. Anyway, the change to make the output go into cells automatically is indeed what I meant.

In a programming language it would be called destructuring.

Your link calls them "multi-cell array formulas" (expand the first accordion).

Yeah, 'spilled array' and 'spilling' are the correct noun and verb.

https://support.microsoft.com/en-us/office/dynamic-array-for...

Since the 90s IIRC. Possible since at least v2 ('87) which I think is what I was using (on Windows 2 running off a couple of floppy drives) at the time.

He is probably referring to the new dynamic array handling which enables “array spill” for almost any built-in function and can be much more intuitive than the previous (still supported, of course) variant. This was introduced in ~2019 I think.

Reply on news.ycombinator.com