Issue 125286 - Unintentionally Copy&Paste on all sheets
Summary: Unintentionally Copy&Paste on all sheets
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.0
Hardware: Mac OS X 10.9
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-07-20 17:10 UTC by Gilles SOUBIRAN
Modified: 2017-05-20 11:55 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Gilles SOUBIRAN 2014-07-20 17:10:21 UTC
File Description 
I use a file consisting of several tens of structured identically sheets: each sheet corresponds to the observed price of items in a given month 
Basically, there a date column, a description column of item with its reference n° and a price column. In each sheet, there is a hundred rows. 

I found the bug in the following circumstances : 
To save an item in the current month, I search if already recorded earlier with "SEARCH" function using its reference n°. If it already exists, I paste a copy in the current month. Sometimes I correct the labeling of an item on the current month, then on other months. 

The bug appears in the following circumstances: 
I copy the corrected label on the current month and search the same item in other months with the "SEARCH" function (still has reference n° in its cell). If found, I make a paste and then all the boxes with identical address in all sheets are pasted, which corrupts the whole file permanently. 

Re-emergence of an old bug 
This bug is not new. I had mentioned it a few years ago on a previous version and it was corrected. It has reappeared since I downloaded the latest update. 
OpenOffice 4.1.0 - OS X 10.9.4
Comment 1 Gilles SOUBIRAN 2014-07-20 17:14:25 UTC
Please read : all cells with identical address 
Instead : all the boxes with identical address