[Libreoffice-bugs] [Bug 51757] New: EDITING: Cut'n'Paste Of Cells Affecting Formula Alters Formula
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Thu Jul 5 20:42:06 CEST 2012
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.
More information about the Libreoffice-bugs
mailing list