https://bugs.documentfoundation.org/show_bug.cgi?id=145751
--- Comment #4 from Mike Kaganski <[email protected]> --- (In reply to gmarco from comment #3) When you insert a row in the middle of a range, your range is technically not expanded - in the sense that the specific rows/columns (not their numbers! the rows/columns as entities), that formulas refer to, are unchanged. OTOH, when you insert above the SUM, the range should change: its last row now should become different entity. And that needs changing the internal references, unlike the first case. People will never need the former case to behave differently; but people may want the latter case to behave differently. Hence the preference. -- You are receiving this mail because: You are the assignee for the bug.
