Bug 56988 - FILESAVE of particular .ods adds rows in sheet with comments
Summary: FILESAVE of particular .ods adds rows in sheet with comments
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.1 rc
Hardware: x86 (IA32) Windows (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard: target:4.2.1
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-11 16:43 UTC by sandrve7
Modified: 2014-02-10 17:07 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
2012_Report_OpenOffice.ods is original file. 2012_Report_LibreOffice.ods is file after bug (68.79 KB, application/x-zip)
2012-11-11 16:43 UTC, sandrve7
Details
original file (38.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-11-11 16:54 UTC, sandrve7
Details
file with bug (38.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-11-11 16:55 UTC, sandrve7
Details

Note You need to log in before you can comment on or make changes to this 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.