I use a simple range where the boundary first row is the 'Head" and boundary end row is the "Foot". In the Foot some cells refers to Head, other sum the column range. Es. range A5:B10, put formulas in A10 = A5 and in B10 = SUM(B5:B9). If I select A5:B5 (the Head) and drag and drop of two rows up, I find the formulas: in A10 = A3 (new position) and in B10 = SUM(B5:B9).(same of old positions). The link has follow the movement for single cell, but for the range with the same start position no. In excel the range change and follow the movement. For me this is a bug because we have two behavior for the same action, and this easy carry a mistake. Thank you in advance
Created attachment 174444 [details] file to show the bug reported add a file to show the bug reported actually in LO (7.1.5.2) the range is only modified if it is completely moved in the example as only one celle of the range is moved the first cell of the range is not modifed i'm not able to decide if it's a real bug
Created attachment 174448 [details] Extended example of cells drag and drop
laurent combe , Thank you for the quick answer. It is true, also in the oldest versions, "actually in LO (7.1.5.2) the range is only modified if it is completely moved" but I disagree because we have two behavior for the same action, and this easy carry a mistake. My Attachment extend your file, and shows that when one user need some space in a range, the natural e simplest action to do is to keep the cells in the first row and move them up. In the example the first cell E20 Follow the movement and you see the correct value, and so you easy think that all other formulas follow the movement, but G20 NOT Follows the movement and you don't see that, easy carry a mistake. Indeed if you insert rows all is ok. Also in excel the range movement the formulas change and follow the movement. This "strange" behavior is not a good idea, for me is an error in the development of Calc. By, Nicola Giardinelli
For me a bug, dragging an edge of a range of a formula, must adapt the range to the new position, like it does with an only one cell reference. The bug it's also with cut & paste.
Reproduced in OOo 3.3 and a recent master build. I can confirm that in Excel 365, following the same steps, the range is extended in the C10 formula. However, the range is not updated if the cell is dragged to a different column, or if it is dragged below the original range. So this seems to only happen in specific, straight-forward cases. Other apps: - OnlyOffice does not extend the range, same as LibreOffice - Gnumeric and Google Sheets extend the range, same as Excel I consider this as request for enhancement rather than a bug. Eike and UX team, what are your thoughts on this? Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 002ae41bb6088002ba3ed0188ac822fb823a23f9 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
(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.
Makes sense _iff_ the move is in the same direction as the range span, e.g. moving (drag&drop) top cell(s) further up or down (not below the bottom row), and not elsewhere.