Apache OpenOffice (AOO) Bugzilla – Issue 100895
[Collaboration]Bad handling of row deletion in shared spreadsheet
Last modified: 2013-08-07 15:14:39 UTC
When sharing a spreadsheet, if one of the users deletes rows, it can happen that other rows get deleted. I set it as "P2" as this is a "silent data loss" issue. I'm working on a minimal testcase and will upload it as soon as it's ready.
I could not reproduce this. Please give a step by step description how to get this problem.
Created attachment 61459 [details] Test case to start from
Here are the steps to reproduce the problem : Step 01:Computer A : Open the file "TestCase.ods", share it (Tools>Share...) Step 02:Computer B : Open the file "TestCase.ods" Step 03:Computer A : In A9 B9 type in "Computer A" and "A8" Step 04:Computer A : Select lines 6 and 7 Step 05:Computer A : delete lines Step 06:Computer B : select line 3 Step 07:Computer B : insert line Step 08:Computer B : In A3 B3 type in "Computer B" and "B1,5" Step 09:Computer A : Save Step 10:Computer B : Save Step 11:Computer A : Save Step 12:Computer A : In A9 B9 type in "Computer A" and "A9" Step 13:Computer A : select line 3 Step 14:Computer A : delete line Step 15:Computer B : Select lines 5 and 6 Step 16:Computer B : delete lines Step 17:Computer A : Save Step 18:Computer B : Save Step 19:Computer A : Save Step 20:Put £2 in the swear box Step 21:Compare the results. Here is what I get : Computer A Author Value Computer A A1 Computer A A2 Computer A A7 Computer A A8 Computer A A9 Computer B Author Value Computer A A1 Computer A A2 Computer A A9 The strange thing is that you get the right result if you start at step 12. Might be a issue While trying to reproduce, I encountered another funny behaviour: at some stage, even if I didn't do anything new on the first computer, I kept having updates on the second one, as if some kind of buffer wasn't cleaned properly (just guessing). Don't hesitate to ask for more details. I can also be available on IRC if that can help
reproducible, forwarded to development
@oc : thanks very much. Sorry to be so demanding, but would it be possible to have it targeted for 3.1, as it's not a feature request but a defect?
Taking the issue
The fix is in CWS "calcdelrows".
@nn : this is *so* cool. Thanks a million.
Back to QA for verification
verified in internal build cws_calcdelrows. Remaining problem: not all changes are correctly highligted (#i101099#).
This issue is closed automatically. It should be fixed in a version with is available for longer than half a year (OOo 3.1). If you think this issue isn't fixed in the current version (OOo 3.2) please reopen it. But then please pay attention about the field 'target milestone'. The closure was approved by the Release Status Meeting at 22nd of February 2010 and it is based on the issue handling guideline for fixed/verified issues : http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues