[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 #8 from Ascaf <fa0sck at gmail.com> ---
(In reply to Ascaf from comment #7)
> 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?

Sorry above read g10 instead of g20:

IN new spreadsheet: A1 --> 100
g10 --> =A1*2 (200)
g10 --> 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
g10 --> =A1*2 (200)
g10 --> 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)

-- 
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/a60fee47/attachment.html>