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

Reply via email to