[Libreoffice-ux-advise] [Bug 143962] EDITING range reference should update when edge cell is moved in same column (drag and drop or cut and paste)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143962

--- Comment #6 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(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 on the CC list for the bug.