https://bugs.documentfoundation.org/show_bug.cgi?id=145640
--- Comment #4 from Eike Rathke <[email protected]> --- Note that the expression =SUM(F10:G10:H10:I10:J10:K10) uses the ':' range operator repeatedly to extend the range, effectively resulting in the range F10:K10. Apparently that somehow makes a difference when the references are updated during sort that then forms for example =SUM(F21:G21:H21:I21:J21:K21) but the internal reference does not result in the effective range F21:K21. Re-entering the formula, by Function Wizard or editing the formula, of course produces the expected result again. -- You are receiving this mail because: You are the assignee for the bug.
