https://bugs.documentfoundation.org/show_bug.cgi?id=155837
Bug ID: 155837
Summary: CTRL+Z operation not working properly after moving
source data.
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
We have source data and an output formula that uses that data.
We move the source data to another place by dragging the mouse.
The addresses in the resulting formula are modified.
We perform the CTRL+Z operation, reverting the changes made.
If the resulting formula is in the same sheet as the source data, the operation
is performed correctly.
If the result formula is on a different worksheet, even though the source data
returns to where it was, the addresses in the result formula are not restored.
Performing the same operation with CTRL+X → CTRL+V can be undone without any
problems (press CTRL+Z twice).
Actual Results:
Enter the case number A1 of sheet1.
Enter the formula =sheet1.A1 in sheet2.
Drag cell A1 in sheet1 with the mouse.
The address in the formula has changed accordingly.
Do CTRL+Z.
Expected Results:
The formula in cell A1 in sheet2 does not have the original address
Reproducible: Always
User Profile Reset: No
Additional Info:
Restore the address from before the change.
--
You are receiving this mail because:
You are the assignee for the bug.
