Bug 58266

Summary: calc looses/breaks diagrams/charts + fails @ cut and paste of diagrams EDITING VIEWING
Product: LibreOffice Reporter: Andreas Schleth <dagobert336-bugzilla>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: critical    
Priority: medium CC: james.bottomley, suse
Version: 3.6.3.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: zip file with *.ods and 4 screenshots describing the problem

Description Andreas Schleth 2012-12-13 20:53:47 UTC
Created attachment 71467 [details]
zip file with *.ods and 4 screenshots describing the problem

create a simple bar chart from eg. 2 short columns of random data.

fail 1:  copy and paste the chart somewhere else to the same sheet: 
 a) the new chart area is blank (should be the same diagram as before), 
 b) there is no way to edit the second chart into something chart-like

fail2:  start from scratch as before (one diagram) and save as *.ods. Then reload the document and find: the chart is blank and broken as above.
Comment 1 James Bottomley 2012-12-19 12:06:09 UTC
I just saw this behaviour as well with

libreoffice-calc-3.6.3.2.3-3.4.x86_64

from openSUSE:Tumbleweed

A spreadsheet with a chart was saved, and on reopening, all the chart setup had disappeared
Comment 2 Dominik Kopp 2012-12-31 08:50:09 UTC
see also bug report
https://bugzilla.novell.com/show_bug.cgi?id=794698
Comment 3 Hans Peter Schwob 2013-01-05 09:57:50 UTC
I use Libre Office 3.5.7.2, the newest version for Win7/German. The error happens since last update on 2012-11-18.

In my case, some of the diagrams have disappeared, when I save and reopen the file. The file contains 16 sheets, nearly all with one diagram. Some diagrams are still there, some shifted to the upper left corner, some disappear completely. It might be, all diagrams created before the last update remain, but the behaviour is not clear. Older files show the diagrams, until the diagram is moved or changed.
Comment 4 Hans Peter Schwob 2013-01-05 10:45:07 UTC
Changed now to version 3.6.4 (LibO_3.6.4_Win_x86_install_multi.msi). (Search for updates said I had installed actual version. Found newer version on bugzilla!)

But problem still exists. One way, which is reproducible:
- copy one sheet with diagram to new document. This document shows diagram.
- Save this new document.
- Open new document: The diagram disappeared.
Comment 5 Hans Peter Schwob 2013-01-05 15:00:05 UTC
Additional Info to comment 3 & 4

I installed Apache-Open-Office 4.1 (actual version) and the problem is gone. Also other problems with the diagrams are gone, also some nice features. I am sad to leave LibreOffice, but I just cannot live with these problems.
Comment 6 Heinz Repp 2013-02-18 22:05:25 UTC
I think this is related: with 3.5.7 on Ubuntu 12.04 LTS (I am forced to use this version as 3.6.x breaks scrolling in writer) spreadsheets created with previous version mostly show the diagrams moved top left. I did not modify this files, as I have not enough trust in a program that gets things so wrong, so I cannot report lost diagrams.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.