https://bugs.documentfoundation.org/show_bug.cgi?id=171017
--- Comment #7 from Colin <[email protected]> --- (In reply to ady from comment #5) > (In reply to ady from comment #4) > Hi Ady, The latest attachment 205785 demonstrates what happens to me at each juncture. 1) just opened the sheet 2) edited "931" into Z3 3) delete the contents of Z3 or simply undo. NOTE 6 array elements remain filled having exited without saving and reloaded the sheet 4) select S3:AE6 5) (Ctrl]+[-] shift cells UP 6) undo 7) wonder what on earth can be wrong with the formula if undoing the edit that created the data doesn't revert the sheet to its pre-edit condition 8) wonder what on earth can be wrong with the formula if removing cells force it to return the first element of the target array for all subsequent 7 array elements BUT only for those rows NOT subsumed by the initial selection marquee. -- You are receiving this mail because: You are the assignee for the bug.
