[Libreoffice-bugs] [Bug 104452] "Cut, add row, paste" doesn't update references

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Ascaf <fa0sck at gmail.com> ---
Thanks for the explanation. So I thought it might be interesting to check the
clipboard while doing the usual sequences and to see if the inconsistencies
were triggered by action different from adding row.
In particular I got this (below, with klipper I mean the values stacked in the
clipboard, newest to the right):

IN new spreadsheet: A1 --> 100
g20 --> =A1*2 (200)
g20 --> ctrl-x
klipper: 200 (the value on the clipboard stack)
d20 --> ctrl-v
now d20 is 200 (=A1*2)
klipper: 200 (unchanged)
d20 --> ctrl-v (accept overwriting)
now d20 is #RIF! (=#RIF!11*2 like if cutting-pasting)
klipper: 200, #RIF! (the same value you'll get if you copy-paste instead of
cutting-pasting)
keep on overwriting (if you want) but the value will not change any more)

for comparison with copy-paste
IN new spreadsheet: A1 --> 100
g20 --> =A1*2 (200)
g20 --> ctrl-c
klipper: 200
d20 --> ctrl-v
now d20 is #RIF! (=#RIF!11*2)
klipper: 200, #RIF! (the value pasted has been updated, in accordance with the
internal rules, I suppose)

So it seams the simple action of pasting twice triggered some formula updating
to the clipboard?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180712/37b192fc/attachment.html>