https://bugs.documentfoundation.org/show_bug.cgi?id=127808
--- Comment #26 from [email protected] --- (In reply to ANACOSTIA from comment #25) > The feature where entering "=B1:B100*2" in cell "A1" automatically fills > cells "A2" through "A100" with ghost values is also a dynamic-arrays. Is > this supported as well? Yes, I just ran a test on the 27.2.0.0.alpha0 master build, and I can confirm that this is supported as well. When entering a formula like =B1:B100*2 into cell A1, it correctly and automatically spills the values down through A100 as a dynamic array. Furthermore, if you enter a value into any cell between A2 and A100 while the spill range is active, the #SPILL! error is correctly handled and displayed. As soon as the blocking value is removed, the range automatically repopulates itself as expected. Feel free to give it a try on the master builds! -- You are receiving this mail because: You are the assignee for the bug.
