https://bugs.documentfoundation.org/show_bug.cgi?id=90920
Bug ID: 90920
Summary: Calc Search can Clone contents of cell to another
sheet
Product: LibreOffice
Version: Inherited From OOo
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: danloomi...@gmail.com
Created attachment 115169
--> https://bugs.documentfoundation.org/attachment.cgi?id=115169&action=edit
Small spreadsheet to reproduce the problem.
Download and open the attached document
Click on sheet1
Position the cursor on a blank cell in column c. Note the line number.
Enter some data in the cell.
control f to bring up the search menu.
Click the icon to go to full search
Make sure search entire document is checked.
Enter "sam" in the search window and start the search.
The data you entered will be moved from the cell on sheet1 to the same cell on
the sheet where the string is found.
+++
Click on sheet1
Position the cursor on a blank cell in column c. Note the line number.
Enter some data in the cell. Click on another cell, then double click back into
the cell you modified. Add something to the cell.
control F to bring up the search menu. Make sure search entire document is
checked.
Enter sam in the search window and start the search.
The data you entered will be copied from the cell on sheet1 to the same cell on
the sheet where the string is found.
This was originally reported in Open Office in May of 2010. It is a data
corruption bug and should receive more attention than it has. Detection of the
problem is difficult because users may not realize that row 1000 of their
spreadsheet was overlaid because the search stopped at row 500. It took me
months to recognize how this was happening.
I noticed with 4.4.2.2-4.fc22 (Fedora 22 Beta) that the data in the source cell
disappears now as well. The bug is worse then when I originally discovered
it.
Workaround. Click out of the cell being modified before initiating the search
dialogue.
--
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
