the hash/pound # operator not working for Dynamic Arrays

Steel Contributor

I have two computers. My personal is an insider build 2006. If I am in a cell and type =A1#, if cell A1 has a dynamic array (Unique() for example) then my formula spills and returns the full array.

 

However, My work computer is on 1910 (I cannot upgrade past this - corp policy right now) which also has dynamic array functions, but typing =A1# returns a #REF! error if I am pointing to an a spilled array, in this case generated by UNIQUE() as well. 

 

Is there some crazy option somewhere on this? I thought this was all rolled out simultaneously, not # references a few months later. 

1 Reply

@Ed Hansberry 

Yes, I could be wrong but as I remember # was from very beginning, that's @ appeared some later instead of SINGLE. Strange.