https://bugs.documentfoundation.org/show_bug.cgi?id=143962
--- Comment #6 from Heiko Tietze <[email protected]> --- (In reply to laurent combe from comment #1) > Created attachment 174444 [details] > file to show the bug reported =B5+B6+B7+B8+B9 vs. =SUM(C5:C9) We update individual cells but keep the range while Excel also changes the range to C3:C9. The difference is if C4 contains a value: Excel will add it to the equation, we not. I tend to disagree with Excel's workflow but user expect similar behavior. Some limits exist in that pasting below the SUM function or in columns left or right has no effect on the range. -- You are receiving this mail because: You are the assignee for the bug.
