https://bugs.documentfoundation.org/show_bug.cgi?id=160018
--- Comment #9 from Colin <[email protected]> --- Further to my comment #8 I am aware that sorting rows with formulae referring to rows either above or below that row always ends up losing the reference point when the reference is to an array eg C12 = SUM(D2:D6) C13 = SUM(D3:D7) C14 = SUM(D4:D8) will lose its compass if sorting on row C or D even when the parameter to update references when sorting a range of cells is active. I always refer to each cell in the sum individually and if I have an "array" of similar calculations then I only need to refine one cluster and then it will automatically replicate when "drag filled". C12 = D2+D3+D4+D5+D6 in that manner LO always knows where D4 will end up no matter where it sorted C12 or any of its precedents. With this in mind I have ascertained that the corruption mentioned above was the result of restarting in "safe" mode to try to identify why grouping and ungrouping columns - F12 & [Ctrl]+F12 - was inoperative on sheets that had been subjected to the vagaries of 7.6.5. Subsequent restarting in normal mode still left the user profile somewhere in the pavement pizza of 11000 mishandled rows. Why have I mentioned this? Because if somebody eventually fixes sorted defined arrays they may wish to consider doing it properly so arrays within function calls are automatically tracked. Or is that rocket science? -- You are receiving this mail because: You are the assignee for the bug.
