https://bugs.documentfoundation.org/show_bug.cgi?id=167188
Bug ID: 167188
Summary: cut & paste alters a formula in another cell
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Hello.
When I cut the cell B3 to paste it in the cell B5, for example, the formula in
F3 changes (but not the formula in A3).
In F3, all occurences of "B3" in the formula are changed to "B5". The other
references (F2) do not change.
The formula in F5 is ok (the value changes, but not the formula).
F3 before the cut and paste :
=SI(GAUCHE(B3;2)="->";F2;CONCAT(GAUCHE(B3;1);SUBSTITUE(F2;GAUCHE(B3;1);"";1)))
F3 after the cut and paste :
=SI(GAUCHE(B5;2)="->";F2;CONCAT(GAUCHE(B5;1);SUBSTITUE(F2;GAUCHE(B5;1);"";1)))
Steps to Reproduce:
1.Cut the cell B3.
2.Go to cell B5.
3.Paste.
Actual Results:
The formula in F3 was :
=SI(GAUCHE(B3;2)="->";F2;CONCAT(GAUCHE(B3;1);SUBSTITUE(F2;GAUCHE(B3;1);"";1)))
After pasting B3 in B5, the formula in F3 becomes :
=SI(GAUCHE(B5;2)="->";F2;CONCAT(GAUCHE(B5;1);SUBSTITUE(F2;GAUCHE(B5;1);"";1)))
Expected Results:
The formula does not change after pasting B3 in B5.
Reproducible: Always
User Profile Reset: No
Additional Info:
The formula in A3 doesn't use B3, so it doesn't change.
--
You are receiving this mail because:
You are the assignee for the bug.
