GNOME Bugzilla – Bug 777334
Linear Trendline support in non LineXY chart types
Last modified: 2017-01-26 05:22:10 UTC
I would like to report an issue that I've been having with gnumeric 1.12.32 (Fedora 25). I have a dataset here that is defined as follows (example) Date, Value 1, Value 2 xx, xx, xx xx, xx, xx xx = Any date and any value. The lines continue e.g. for a couple of hundret of lines (rows). I can select Date and Value 1 and have it paint a LineXY chart. This works without problems. I can apply a Linear Trendline to the LineXY chart and it shows up correctly. Doing the same with a Line chart (no XY) then the Trendline stays horizontally equal from beginning of the series till end. Giving you a horizontal ruler like view. Unfortunately I rely on using Line charts (or sometimes Area charts) to overlay a few different value types AND have a Trendline applied to it as well. Sadly the LineXY chart doesn't support such overlaying. Whatever I tried will squeeze the LineXY chart in a corner of the chart and thus render the results unusable. Doing the same with Line and a combination of Area charts or multiple Line charts otoh works perfectly. Only Trendline doesn't work as expected. It would therefore be necessary to have Trendline working even in non XY charts. e.g. MovingAverages seem to be working there.
Created attachment 343729 [details] Sample gnumeric file I don't have any trouble adding trend line to a line graph. Sample attached. Please attach a sample where you have problems.
No trouble for me either, please provide a sample file.
I like to come back to this within a couple of days and like to explain why. This issue occoured after importing an xlsx file into gnumeric. While everything got imported more or less correctly (except some external file references within cells), the charts otoh caused visual issues after the import. I had to go through one chart after another to "fix" the looks. This was also no big issue after clicking on default style and then going through all the tabs and lists of the elements that builds up a chart (chart properties). The only thing I noticed was, that most trendlines didn't look like the trendlines shown in the teaching videos (the excel sheets are part of a commercial series of teaching videos that I can not hand out). Though, after manually creating a few random datasets, the trendlines seem to show up correctly. Maybe the long date series (dates going back to 1948 (one nine four eight), might cause the trendline to simply show a horizontal line because of the the values counted together -> just a guess)... I like to check this up a bit more close... Watching the accompanying teaching video and looking inside the chart itself. So please give me a few days to check this up. I will come back to this again.
Coming back to this... Please find attached following example created with publicly available data. 1) Book1.xml (gnumeric created file, chart and linear Trendline) 2) Book1.ods (gnumeric exported file of above file for libreoffice 5.3) As you notice 1) has a date and data range starting from A1->A1792 and B1->B1792. A chart and a linear Trendline. Basic, no bells and whistles. Trendline is missing! Exported that file as ods and loaded up within Libreoffice 5.3. I had to adjust some cell width and quickly went through the chart properties. Same values as you notice in 2). Trendline was there since beginning! 3) Book1.png -> Expected resulting linear Trendline
Created attachment 343991 [details] Testcase M2 data (gnumeric)
Created attachment 343992 [details] Testcase M2 data (gnumeric export for libreoffice)
Created attachment 343993 [details] Expected linear Trendline (libreoffice imported gnumeric file)
Created attachment 343995 [details] Trendline missing as shown under gnumeric
OK, thanks for the sample. I understand the issue now. Not sure about how to fix it though.
The sample file shows actually a new issue related to area plots which I just fixed. I still don't see the original claim, should I close that bug?
(In reply to Jean Bréfort from comment #10) > I still don't see the original claim, should I close that bug? Sorry, I wasn't able to explain the initial issue any better because I worked with an provided xlsx Spreadsheet created by a 3rd party. I only imported it into Gnumeric and figured out that Trendlines were missing where they supposed to be. Most of the Charts I deal with have a couple of Lines / Areas / Other chart elements overlayed to show possible similarities in economic movements. I also needed to find myself back into Gnumeric because I haven't used it for a longer time. I only noticed that something was wrong but wasn't sure what exactly the reason was. I will take care and express better next time when I file a bug. Yes please close the bug and thanks for the fixes done so far. Very much appreciated. Thanks.
This problem has been fixed in our software repository. The fix will go into the next software release. Once that release is available, you may want to check for a software upgrade provided by your Linux distribution.