https://bugs.freedesktop.org/show_bug.cgi?id=71058
Priority: medium
Bug ID: 71058
Assignee: [email protected]
Summary: EDITING: Cut and paste special does not shift formula
links as expected
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: Inherited From OOo
Component: Spreadsheet
Product: LibreOffice
If cells are cut and then pasted normally (i.e. with "Paste" instead of "Paste
Special"), all formula links to these cells point to the new cell positions
after pasting the cells. This shift of formula links does not occur with the
command "Paste Special" after cutting cells. The result is unexpected: Formula
links still point to the old positions of the moved cells. Therefore, "Cut" and
"Paste Special" leads to the same result as "Copy" and "Paste Special" with
subsequent deletion of the old cells.
The expected and unexpected results are illustrated in the attached spreadsheet
"Example-sheet-for-bug-report_Cut-and-paste-special-with-transposing_2013-10-30.ods"
with the "Paste Special" option "Transpose". Instead of downloading the sheet,
the following workflow can be carried out for illustration and reproduction.
1. Fill cell B6 with the number 4 and cell C6 with the number 7
2. Link cell E6 to cell B6 and link cell F6 to cell C6
3. Mark cells B6:C6 and cut these two cells
4. Select cell B7
5. Paste Special with selection "Paste all", option "Transpose", operation
"None" and no shift of cells.
Expected result: Cell E6 is linked with cell B7 and cell F6 is linked with cell
B8.
Actual result: Cell E6 is still linked with cell B6 and cell F6 is still linked
with cell C6.
I suggest the interim solution to disable "Paste Special" after cutting cells.
Disabling "Paste Special" after cutting cells avoids potentially severe loss or
change of data due to bug 68976.
Disabling "Paste Special" after cutting cells does not lead to a loss of
functionality. It can be replaced in the workflow by "Copy" and "Paste Special"
with subsequent deletion of the old cells. A loss of functionality occurs only
if this bug can be fixed by aligning the behaviour of "Paste Special" with
"Paste" after cutting cells. MS Excel 2007 does not offer the full set of
"Paste Special" options after cutting cells either. I do not have access to
later Excel versions.
I reproduced the unexpected behaviour under Windows 7 and Linux.
I reproduced it with different LibreOffice versions including the most recent
pre-release 4.1.3.2. I reproduced it with OpenOffice.org 3.3.0 as well. Hence
it is inherited from OpenOffice.org.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
