Created attachment 94086 [details]
Calc file with sheet that loses data when copied/moved
Problem description: When you use the copy/move functions associated to each sheet of a calc file to duplicate a sheet into the same file or into another one, some cells completely lose their contents with no apparent reasons. Data is lost and nobody warns you if you do not check this thoroughly.
Moving instead of copying has the same problem, but it is even worse since you are left without the original sheet and your data are in this case totally gone if you do not spot the malfunction.
Also, if you clone the sheet in the same file, resulting in some wrongly empty cells in it, save it and reopen it, the content is gone not only on the the cloned sheet, but in the original one as well! S.O.S.
Steps to reproduce:
1. open attached calc file
2. right click on the tab of the only existing sheet "28-1-14" and choose move/copy
3. select "copy", choose the same file or another, new one at your will as destination. The newly obtained sheet is NOT a full copy of the original one: cells C2;D2;H2 and I2 are now empty while they were full of data in the original sheet.
Current behavior: the copy/move function worked correctly in 4.1.4
Expected behavior: the copied sheet should be a fully identical copy of the original one. As it is now, I cannot trust Calc in version 4.2 for any serious work. You're at risk of data loss.
Operating System: Windows 7
Version: 22.214.171.124 release
Last worked in: 126.96.36.199 release
Reproduce by copying the sheet to a new file. Confirmed with Version: 188.8.131.52
Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 Ubuntu 13.10 x64.
Set as New, raise to highest as there is dataloss and add to MAB. I didn't find duplicate. Sophie
Sophie, Can you try reproducing this using a more recent 4.2.x build? We now have a pre-release 4.2.1 build available. Thanks.
Version: 184.108.40.206 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b
Maybe we can change to resolved-fixed.
I remember fixing this one. There is a duplicate bug for this somewhere...
*** This bug has been marked as a duplicate of bug 74414 ***
Migrating Whiteboard tags to Keywords: (possibleRegression)