https://bugs.freedesktop.org/show_bug.cgi?id=71058
--- Comment #5 from Ralf <[email protected]> --- (In reply to comment #3) > I actually think the problem might be in “Cut+Paste”, not in > “Cut+PasteSpecial”. > > The formulas in E6 and F6 should “follow” the new position of their > “Precedents” if you *move* those precedents; e.i. select B6:C6 and *drag* > the > selection to B7:C7. > > But if you “Copy+Paste” or “Cut+Paste” or “Copy+PasteSpecial” or > “Cut+PasteSpecial”, IMO the formulas in E6 and F6 should remain as they were > before, pointing to the same “Precedent” cells, B6 and C6 respectively. > > I think that the respective behaviors should be confirmed with some other > spreadsheet software of reference (like Excel for example) and then, > perhaps, > changed in LibreOffice accordingly. Hi Ady, I think that as well "Copy"/"Paste" as "Cut"/"Paste" behave well and as expected in LibreOffice. MS Excel does not behave differently. We agree that the links should not change after "Copy"/"Paste". However, I think that it is convenient that the links follow the cell in case of "Cut"/"Paste" like when "moving" or "dragging" the cells with the cursor. A large number of links can point to a single cell. If one wants to move this cell to another position in the spreadsheet without the mouse (e.g. to another worksheet), one can simply move the cell with "Cut"/"Paste". This workflow takes a few seconds also across worksheets, and the large number of links is adjusted accordingly without any effort. If "Cut"/"Paste" behaved like "Copy"/"Paste", the large number of links would have to adjusted manually. Best regards, Ralf -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
