GNOME Bugzilla – Bug 349457
Smoothing generated by Excel graphs doesnt appear
Last modified: 2006-09-29 16:34:10 UTC
I noticed on all my MS Excel 2000 graphs that when imported into Gnumeric 1.70 (and 1.63 too), that if I had applied smoothed lines to the data points that Gnumeric ignores this and shows the line curve as discrete points instead. This is the case with Excel's 'XY Scatter graph, with data point connected by smooth lines' graphs. Is this a bug, or just something that is incomplete in Gnumeric as yet? Either way its a real shame as Gnumeric is the only app that allows me to save graph files as svg or jpg really useful. Even OpenOffice and Excel won't allow you to save individual graphs files. Please help Julian
I'm not a developer but if I understand correctly, this is not yet ready. See Bug 338626, Comment #4.
Julian, can you provide a sample file and a screenshot (in excel)? I have no excel around there. I guess it might be a style problem.
Hi Jean I have added what you requested, both created in Excel. Although the equations are not simple, the same problem occurs with very simple data.
Created attachment 70709 [details] Sample Excel 2000 File with XY points connected by smoothed lines
Created attachment 70710 [details] Screenshot showing the smothed appearance of the XLS graph Please note. You can create graphs just like this in Gnumeric fine, but the problem is when reading in previously created Excel data, that the line type reverts to an unsmoothed set of lines
OK, I need to write some code to use our bezier spline interpolation in such cases. It might take some times since I need to find the documentation and/or wait for an access to a windows machine.
Created attachment 71594 [details] [review] goffice patch in excel, the smoothing property belongs to the style, so is attached to each series. The easiest way I found to fix is to add the interpolation properties to GogXYSeries and use the ones in the plot as default for new series.
Created attachment 71595 [details] [review] the associated gnumeric patch add export/import of the smoothed property. The style children are not in the same order than in files produced by excel, but it does not seem to be a problem either in excel or gnumeric.
Created attachment 72767 [details] [review] an other way to implement that in goffice
Created attachment 73531 [details] [review] updated version of the patch
Created attachment 73532 [details] [review] the new associated gnumeric patch
Thanks for the work that's been put into to fix this bug. I notice it says FIXED. Where can I find a Download of Gnumeric which contains this patch ?
You'll have to wait for 1.7.1 release (a matter of days) unless you are able to compile goffice and gnumeric from CVS.