In old versions of Excel a formula like =A1:A10 in cell B5 would perform a operation known as Implicit Intersection and return the value in A5. In newer version that is a Dynamic Array and will return 10 values. The way Excel manages compatibility is converting the old version in =@A1:A10. The Implicit Intersection operator is needed to implement correctly Dynamic Arrays in #16
See: https://support.microsoft.com/en-au/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34
In old versions of Excel a formula like
=A1:A10
in cellB5
would perform a operation known as Implicit Intersection and return the value inA5
. In newer version that is a Dynamic Array and will return 10 values. The way Excel manages compatibility is converting the old version in=@A1:A10
. The Implicit Intersection operator is needed to implement correctly Dynamic Arrays in #16This is blocked by #15