Created attachment 63869 [details] Before, during and after shots showing formula in B2 as it gets changed If you cut (Ctrl-X on Windows) a range of cells in a row that affect a formula on the same row (but that formula cell is not included in the cut) and then paste the cut contents into another row (accepting the existing data warning) that contains a similar formula, the formula from the cut row is changed to that of the paste row when it should remain untouched. Steps to reproduce: 1. Start a new sheet 2. In A1, enter 35, and in A2 enter 77 3. In B1 enter =A1/7 and in B2 enter =A2/7 4. Click in A2, and Cut the contents (Ctrl-X on Windows). Formula in B2 remains correct. 5. Click in A1, and Paste the cut contents (Ctrl-V in Windows). The formula in B2 is now the same as the formula in B1. Current behavior: Formula of cell in row with data Cut is changed to formula of cell in row that is target of Paste. Expected behavior: Formula should remain untouched; user did not change cell contents and paste did not target that cell (thus, no reason to change). Platform (if different from the browser): Windows 7 Pro 64-bit. Browser: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; .NET CLR 1.1.4322; Creative AutoUpdate v1.40.01)
This is standard spreadsheet behavior and not a bug, formulas referring a cell that is moved with cut&paste or drag&drop are adapted to the new position. If you don't want that copy&paste and afterwards delete the original.