Bug 51757 - EDITING: Cut'n'Paste Of Cells Affecting Formula Alters Formula
Summary: EDITING: Cut'n'Paste Of Cells Affecting Formula Alters Formula
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2012-07-05 11:42 UTC by Jason Teagle
Modified: 2012-07-05 13:14 UTC (History)
0 users

See Also:
Crash report or crash signature:

Before, during and after shots showing formula in B2 as it gets changed (23.39 KB, image/png)
2012-07-05 11:42 UTC, Jason Teagle

Note You need to log in before you can comment on or make changes to this bug.
Description Jason Teagle 2012-07-05 11:42:06 UTC
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)
Comment 1 Eike Rathke 2012-07-05 13:13:15 UTC
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.