https://bugs.freedesktop.org/show_bug.cgi?id=68385
Priority: medium
Bug ID: 68385
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Cut/paste from different spreadsheets corrupts cell
references
Severity: normal
Classification: Unclassified
OS: All
Reporter: tmac...@gmail.com
Hardware: All
Status: UNCONFIRMED
Version: 3.3.0 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 84392
--> https://bugs.freedesktop.org/attachment.cgi?id=84392&action=edit
PDF demonstrating the bug.
Cutting and pasting cells from one spreadsheet to another modifies formula
references in the "pasted-to" spreadsheet. Formulas referencing cells in the
"cut-from" region on the "pasted-to" spreadsheet are modified.
Sorry if this is difficult to describe. If you cut from file2 a1:a7 and paste
in file1 c1:c7, any formulas in file1 that reference file1 a1:a7, will now
reference the cells where you actually pasted.
Note that this doesn't happen when you COPY. It also doesn't happen if you
paste the cut contents somewhere else first.
Steps to reproduce:
1. Create a new spreadsheet (spreadsheet1)
2. On spreadsheet1, make each cell in Column B from B1:B20 reference Column A
(B1 contains =A1, B2 contains =A2, ... B20 contains =A20)
3. Create another new spreadsheet (spreadsheet2)
4. On spreadsheet2, insert data (ex. a number sequence1 through 7) into A1:A7
5. On spreadsheet2, CUT (don't copy) A1:A7
6. On spreadsheet1, immediately paste contents to A9:A15
Expected results:
Column B will still contain cells referencing each adjacent cell from Column A
(B1->A1, B2->A2, etc...)
Actual results:
Column B cells that referenced cells in A1:A7(the cut from region on the other
sheet) have now CHANGED to reference the cut-to region on the current
sheet.(B1->A9, B2->A10, ... B7->A15, B8->A8)
I can confirm this affects 4.1.0.4 on 32bit MS Windows Vista, Version: 4.1.0.4
on 64bit RHEL6, Version 4.0.4.2 on current 64bit Arch Linux, Version 4.0.2.2
under 32bit Fedora 17, and even back to the oldest version I currently have
access to: OpenOffice 3.2.1 under 64bit RHEL6. Since it has been around since
before LibreOffice began, I marked it as version 3.3.0.
Since it's been rather difficult for me to describe this bug, I've included a
pdf to demonstrate.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
