[Libreoffice-bugs] [Bug 51757] New: EDITING: Cut'n'Paste Of Cells Affecting Formula Alters Formula

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=51757

             Bug #: 51757
           Summary: EDITING: Cut'n'Paste Of Cells Affecting Formula Alters
                    Formula
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.4.3 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: jason.teagle at yahoo.co.uk


Created attachment 63869
  --> https://bugs.freedesktop.org/attachment.cgi?id=63869
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)

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.