https://bugs.documentfoundation.org/show_bug.cgi?id=104452
--- Comment #7 from Ascaf <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
