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

--- Comment #5 from Mehmet Rıza Saraç <[email protected]> ---
(In reply to m.a.riosv from comment #3)
> Sorry, but without a followed steps, it's no possible to find the issue.
> 
> What do you copy/paste? and how do you do it?

I finally figured out how this problem appears.
The problem is about drag a region of information to another’s ones place by
"mouse" drag. If both cells are referenced then references will follow moved
data in new place, but reference to over written one will stay same.
Accidentally making such a mistake cannot be completely fixed by < ctrl + Z >.
Only the moved data will be undid, but the change in references will remain
broken. Such an operation in msexcel will produce a warning for the cells to be
overwritten and old references to overwritten cells will be broken with #REF
info.

In example with new attachment moving data in D4-D9 region to D8-D15 then
undoing, and after this moving D20-D27 to D13-D20 then <undo> will produce
severe destruction in referenced calculations in columns I,K,O, and Q. We have
to fix these references manually.

-- 
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

Reply via email to