[Libreoffice-bugs] [Bug 127359] Match formula changes, when cells it looks to are cut and pasted.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from ralarock <ralarock at hotmail.com> ---
I was able to recreate this. When the value for A2 is CUT and PASTED into A4
the formula in cell D2 changes to "=IF(ISNA(MATCH(A4,A3:A$5,0)),0,1)". Note the
"A4" in the MATCH was "A2" before the paste.

I believe (I do not know for certain) that this is normal behavior for
spreadsheets. When COPY/PASTE is used with A2 the association between the
formula in D2 and cell A2 remains intact. So the formula in D2 remains the
same. The pasted value in cell A4 is not associated with the formula in cell
D2. When CUT/PASTE is used the association between the formula in D2 and the
value remain intact. When the value is PASTED into cell A4, the first parameter
in the MATCH function changes to A4.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191004/bf03dd7b/attachment.html>