https://bugs.documentfoundation.org/show_bug.cgi?id=97968
Bug ID: 97968
Summary: EDITING: Cut/paste doesn't change formula references
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Cut/paste of a part of a range with formulas depending on each other will not
move the cell references correctly.
Example:
1. Enter 1 in A1 and =A1+1 in A2.
2. Copy A2 into cells A3:A6.
3. Cut the range A4:A6 and paste it into B4.
The result in B4:B6 will be 4, 1, 1 instead of the expected 4, 5, 6. The
formulas in B5 and B6 refers to A4 and A5 instead of B4 and B5.
If you had cut and paste the entire range (A1:A6) the result would have been
correct. There is minor bug when undoing the paste. Numbers 1, 2, 3, 4, 5 in
cells A2:A6. When you press a second time on undo number one will appear in A1.
Cutting and pasting works correctly if the formulas had been written
horizontally e.g. on the first row instead of vertically in column A.
--
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
