Bug 56988

Summary: FILESAVE of particular .ods adds rows in sheet with comments
Product: LibreOffice Reporter: sandrve7
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: critical CC: erack, kohei, LibreOffice, markus.mohrhard
Priority: medium    
Version: 3.6.0.1 rc   
Hardware: x86 (IA32)   
OS: Windows (All)   
Whiteboard: target:4.2.1
Crash report or crash signature: Regression By:
Attachments: 2012_Report_OpenOffice.ods is original file. 2012_Report_LibreOffice.ods is file after bug
original file
file with bug

Description sandrve7 2012-11-11 16:43:56 UTC
Created attachment 69903 [details]
2012_Report_OpenOffice.ods is original file. 2012_Report_LibreOffice.ods is file after bug

"2012_Report_OpenOffice.ods" is a spreadsheet with conditional formatting, cell with comment, cell with different colours, macro.
With Open office no problem.

-Open the file with LibreOffice 3.6.3
-write something in REPORT sheet
-save and close
-Reopen the file and in YEAR_PLAN_2012 sheet some extra row are added. (see file 2012_Report_LibreOffice.ods)
Comment 1 sandrve7 2012-11-11 16:54:32 UTC
Created attachment 69904 [details]
original file
Comment 2 sandrve7 2012-11-11 16:55:17 UTC
Created attachment 69905 [details]
file with bug
Comment 3 Rainer Bielefeld Retired 2012-11-11 17:50:49 UTC
[Reproducible] with "LibreOffice 3.6.3.2" German UI/ German Locale [Build-ID: 58f22d5] on German WIN7 Home Premium (64bit).

Simply saving the document under new name addes rows in YEAR_PLAN_2012 

The problem might be Comment related, at least I do not see the added rows when I delete all comments before I save the document.

Still  [Reproducible] with parallel installation of Master "LOdev  3.7.0.0.alpha0+   -  ENGLISH UI / German Locale  [Build ID: 70ec82)]"  {tinderbox: @16, pull time 2012-11-09 00:53:19} on German WIN7 Home Premium (64bit) with separate User Profile for Master Branch

Already [Reproducible] with Server Installation of  "LibreOffice 3.6.0.1 rc  German UI/Locale [Build-ID: 73f9fb6] on German WIN7 Home Premium (64bit) 

Was ok with 
- Server installation of  Master "LOdev 3.6.0alpha0+  – WIN7 Home Premium (64bit)
  ENGLISH UI [Build ID: 475d0c5-829fc92-39746e8-206648e-fefd87]" (2012-02-14)
- 3.5.7.2

@Spreadsheet Team
Please decide concerning "bibisectrequest"!
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC).
Comment 4 Kohei Yoshida 2014-02-10 17:07:41 UTC
I no longer see this in 4.2.1.  We've reworked cell comment storage, so perhaps that has fixed this.