https://bugs.documentfoundation.org/show_bug.cgi?id=167188
--- Comment #8 from Warren <[email protected]> --- I was able to replicate the behavior as described using the provided file and the following environment: Version: 25.2.4.3 (X86_64) Build: 33e196637044ead23f5c3226c Environment: CPU Threads: 8 OS Windows 7 Service Pack 1 X86_64 (6.1 build 7601) User Interface: UI render: Skia/Raster; VCL:win Locale: en-US (en_US); UI: en-US Misc: Calc:threaded I was also able to replicate this with simple numerical formulas. I was able to replicate also by Dragging and Dropping the cell. However this behavior does match competitor Spreadsheet applications. There is not much in the Calc documentation to describe intended behavior with the Cut command but the "internet" describes this as more of "Move" which is why the references update versus the Copy > Paste which is replicating the contents of the first cell into the second cell. I also found that using an Absolute Reference ($) does not change this behavior which indicates that the Absolute reference is to the contents of the cell and not the actual cell and when you Cut > Paste you are moving the contents of the cell so the references update. I also found that if you repeat the paste (IE paste cell B3 twice to two different locations) the formula in F3 does not update to the second paste location presumably because at that point it is now just a copy of the item on the clipboard. As mentioned to avoid the formula updates the Copy procedure should be used. -- You are receiving this mail because: You are the assignee for the bug.
