After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 301720 - Title elements in charts do not round trip with xls
Title elements in charts do not round trip with xls
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other All
: Normal normal
: ---
Assigned To: Jean Bréfort
Jody Goldberg
evolution[filters] evolution[interop]
Depends on:
Blocks:
 
 
Reported: 2005-04-23 17:14 UTC by J.H.M. Dassen (Ray)
Modified: 2008-01-21 00:15 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
saves the graph title when the chart has no title (603 bytes, patch)
2008-01-12 09:54 UTC, Jean Bréfort
committed Details | Review

Description J.H.M. Dassen (Ray) 2005-04-23 17:14:00 UTC
Distribution/Version: Debian "sid" (unstable)

Originally reported as http://bugs.debian.org/305399

----------------------------------------------------------------------------
From: Eddy Petrisor <eddy.petrisor@gmail.com>
Date: Sun, 17 Apr 2005 23:36:56 +0300
Subject: Bug#305399: gnumeric: Title elements in charts are lost after save
(.xls files)

Package: gnumeric
Version: 1.4.2-2
Severity: normal

Gnumeric does not retain the title elements introduced in charts.

Way to reproduce the bug:
- create a set of data to be used for the input of the chart
- create a chart
- link the chart to the previously mentioned data
- add a title element and fill its information
- apply the changes and save the worksheet as an Excel file (.xls)
- close gnumeric
- reopen the xls file
- the chart should have the title missing

Is this a limitation of the xls format? I didn't try with the native
format.
----------------------------------------------------------------------------

I have verified that this behaviour is repeatable with CVS HEAD, that it does
not occur when using gnumeric's native format and that openoffice.org 1.1.3
appears to have the same problem.
Comment 1 Jody Goldberg 2005-06-26 03:46:45 UTC
Jean it seems like some of your recent work might help here.
Comment 2 Jean Bréfort 2005-06-26 08:16:43 UTC
most probably yes, but it needs some more work.
Comment 3 Jean Bréfort 2007-09-13 15:08:44 UTC
Fixed, but position is not taken into account at the moment (this is not specific to titles).
Comment 4 J.H.M. Dassen (Ray) 2007-09-13 21:12:21 UTC
Confirmed: with SVN trunk, the title text now round trips fine. It isn't recognised by OOcalc (2.2.1-8), but that may well be an issue at OOcalc's end.
Comment 5 J.H.M. Dassen (Ray) 2008-01-12 09:13:56 UTC
Unfortunately, with gnumeric 1.8.0 and goffice 0.6.1, the issue is back for
me; it can be reproduced using the same steps as in the original description
of this report.
Comment 6 Jean Bréfort 2008-01-12 09:54:48 UTC
Created attachment 102654 [details] [review]
saves the graph title when the chart has no title
Comment 7 J.H.M. Dassen (Ray) 2008-01-12 10:16:42 UTC
The patch works for the test case from the new report I received
(http://bugs.debian.org/305399) and follows the principle of least surprise,
so I'm happy with it. Thanks Jean!
Comment 8 Jody Goldberg 2008-01-12 13:51:05 UTC
Please commit to both trees.
Comment 9 Eddy Petrişor 2008-01-21 00:15:07 UTC
Cool. Nice to see this is fixed :-)

Thanks to both of you guys!