goffice issueshttps://gitlab.gnome.org/GNOME/goffice/-/issues2018-05-22T13:04:50Zhttps://gitlab.gnome.org/GNOME/goffice/-/issues/23Please add principal components "trend line"2018-05-22T13:04:50ZBugzillaPlease add principal components "trend line"## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605047)](https://bugzilla.gnome.org/show_bug.cgi?id=605047)**
## Description
Please can you add an additional trend line type that shows the principal components ...## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605047)](https://bugzilla.gnome.org/show_bug.cgi?id=605047)**
## Description
Please can you add an additional trend line type that shows the principal components of a 2D series, using a longer and shorter line to represent the eigenvectors corresponding to the first and second eigenvalues respectively? (Also, the position of the centroid and the equation of the principal axis through the centroid would need to be accessible in the normal way by adding an equation to the trendline.) There are a *lot* of applications for this, I would use it all the time. Thanks!
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/22Discriminant analysis visualization for scatterplots2018-05-22T13:04:41ZBugzillaDiscriminant analysis visualization for scatterplots## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605046)](https://bugzilla.gnome.org/show_bug.cgi?id=605046)**
## Description
It would be very useful if Gnumeric could display not just trend lines on graphs, but...## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605046)](https://bugzilla.gnome.org/show_bug.cgi?id=605046)**
## Description
It would be very useful if Gnumeric could display not just trend lines on graphs, but discriminant lines that separate two or more different classes of points. For example, if you add one series of XY points that correspond a cluster of items in one class and a second series of XY points that correspond to a cluster of items in a second class, and the points are supposed to be linearly separable, it would be very useful to be able to see the decision boundary between the two classes plotted on a scatterplot.
(1) In the simplest case, simple linear discriminant analysis could be performed and the linear decision boundary between the points could be shown. Being able to see the result of Fischer discriminant analysis or of running an SVM classifier or logistic regression (without having to export data into R or something) would be extremely useful for many applications, and would be an excellent addition to the current trend line support, only requiring the implementation of the discriminant analysis, but without requiring much in the way of architectural changes to graph plotting.
(2) In the more complex case, with more than two classes of points and non-linear boundaries (e.g. with three classes and quadratic decision boundaries), rather than drawing a decision line between the classes, the plot background could be colored differently in the regions of the domain that fall within each class. This would also be extremely useful, but would probably be trickier to implement with Gnumeric's current architecture than the above, and may fall more in the realm of the sort of thing you would be trying to do with R in the first place -- so I'll just add (2) as a "blue-skies wishlist item", although (1) is definitely something that a lot of people could use in Gnumeric.
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/21Please add "total least squares" orthogonal regression2018-05-22T13:04:26ZBugzillaPlease add "total least squares" orthogonal regression## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605044)](https://bugzilla.gnome.org/show_bug.cgi?id=605044)**
## Description
The current linear regression line in charts in Gnumeric uses ordinary least squares ...## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605044)](https://bugzilla.gnome.org/show_bug.cgi?id=605044)**
## Description
The current linear regression line in charts in Gnumeric uses ordinary least squares (OLS), minimizing the squared error in vertical distance between points and the regression line, rather than the orthogonal distance. Specifically "A fitted linear regression model can be used to identify the relationship between a single predictor variable x_j and the response variable y when all the other predictor variables in the model are 'held fixed'." -- http://en.wikipedia.org/wiki/Linear_regression
In some datasets, neither variable is "held fixed", and as a result the interpretation of the results of OLS would be wrong. An example is a scatterplot between two variables where the points form a cluster that is horizontally narrow but vertically quite tall. OLS will likely produce a shallow regression line in an attempt to minimize vertical squared error. However a much more natural best fit line would be a steep line -- possibly even of infinite gradient, i.e. a perfectly vertical line -- that properly shows the trend in the points. The difference is that when there is no "held fixed" variable, perpendicular distance to the regression line must be used, not vertical distance. The total least squares (TLS) method to accomplish this is described here:
http://en.wikipedia.org/wiki/Total_least_squares
(This is probably closely related to the 1st principal component...) The result is not in the form y=mx+c but ax+by+c=0, because the gradient can be infinite.
Please can you add a TLS regression line method to Gnumeric? For XY plots, standard linear regression only works correctly some of the time. Thank you.
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/20Regression lines need labeling features2018-05-22T13:04:05ZBugzillaRegression lines need labeling features## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605041)](https://bugzilla.gnome.org/show_bug.cgi?id=605041)**
## Description
Regression lines need a number of other features to make them really useful:
(1) Whe...## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#605041)](https://bugzilla.gnome.org/show_bug.cgi?id=605041)**
## Description
Regression lines need a number of other features to make them really useful:
(1) When adding a regression line to a graph, it is often really important to display the "r value" (Pearson's correlation coefficient, given by =correl() ) right next to the regression line. This should be manually moveable in case the automatically-assigned location is undesirable.
(2) The actual equation of the regression line (whether linear or otherwise) needs to be able to be added (and possibly repositioned) too.
(3) It would be immensely helpful if "axis intercept lines" could be added to any regression line: given a certain X value, calculate the corresponding Y value of the regression line for that X value, and then draw a vertical line from the X axis up to the regression line, and then a horizontal line from the regression line to the Y axis. These lines could optionally extend the entire width and height of the graph, or just the partial distance from the axis to the regression line. This allows for certain points of interest (e.g. thresholds) to be clearly shown on the graph.
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/19Scale and tick auto-sizes depend on scale limits weirdly2018-05-22T13:03:36ZBugzillaScale and tick auto-sizes depend on scale limits weirdly## Submitted by Vladimir Chukharev
**[Link to original bug (#599901)](https://bugzilla.gnome.org/show_bug.cgi?id=599901)**
## Description
Created attachment 146417
A simple graph exhibiting the misbehavior
This is a minor POLA viol...## Submitted by Vladimir Chukharev
**[Link to original bug (#599901)](https://bugzilla.gnome.org/show_bug.cgi?id=599901)**
## Description
Created attachment 146417
A simple graph exhibiting the misbehavior
This is a minor POLA violation. Tested with 1.9.12 under WinXP and 1.9.14 in
FreeBSD.
A graph with a XY plot has different size of the plot area and of the scale
ticks if the scale bounds are switched from automatic to non-automatic mode, if
the tick size is automatic (and plot size is also automatic).
The attached file contains an example of such a plot with two points, (-0.06,
-0.06), (0.22, 0.22). All scale parameters are automatic. The actual bounds of
the scales are -0.1 and 0.25, the ticks are 0.05 (both X and Y scales, on X
scale only every second tick has a label).
If you deselect 'automatic' from e.g. Minimum bound of X-Axis1, the actual
Maximum bound is changed to 0.3 and Major ticks to 0.1. The greyed-out values
of these parameters are not refreshed, but the preview graph shows the changes.
When Apply is clicked, all the values are really applied.
If you deselect 'automatic' from Maximum bound of X-Axis1, the scale bounds are
not changed, but the Major ticks value is changed to 0.1, and the ralative size
of the plot in Chart1 is increased.
Similar changes happen with Y-Axis1.
**Attachment 146417**, "A simple graph exhibiting the misbehavior":
[scale_limits.gnumeric](/uploads/e99063b2e601bd6cbf03a6d977c07d77/scale_limits.gnumeric)
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/18Unicode ellipsis in menu2018-05-22T13:02:56ZBugzillaUnicode ellipsis in menu## Submitted by Bruce Cowan `@suborbitalpigeon`
**[Link to original bug (#596003)](https://bugzilla.gnome.org/show_bug.cgi?id=596003)**
## Description
Created attachment 143747
Patch
Patch attached.
../goffice/graph/gog-series-pre...## Submitted by Bruce Cowan `@suborbitalpigeon`
**[Link to original bug (#596003)](https://bugzilla.gnome.org/show_bug.cgi?id=596003)**
## Description
Created attachment 143747
Patch
Patch attached.
../goffice/graph/gog-series-prefs.ui.h:2 -
"`<i>`y'`</i>`(`<i>`x`</i>``<sub>`first`</sub>`):"
Translator comment would useful there
**Attachment 143747**, "Patch":
[0001-Minor-string-fixes.patch](/uploads/b2da3c3e5b57e923d0fca6af60a843d3/0001-Minor-string-fixes.patch)
### Depends on
* [Bug 595615](https://bugzilla.gnome.org/show_bug.cgi?id=595615)
### Blocking
* [Bug 621639](https://bugzilla.gnome.org/show_bug.cgi?id=621639)https://gitlab.gnome.org/GNOME/goffice/-/issues/17Surface plots should allow multiple series2018-05-22T13:02:27ZBugzillaSurface plots should allow multiple series## Submitted by Andreas J. Guelzow `@guelzow`
**[Link to original bug (#591478)](https://bugzilla.gnome.org/show_bug.cgi?id=591478)**
## Description
If 2 surface plots are included in teh same chart, the first one is drawn and then...## Submitted by Andreas J. Guelzow `@guelzow`
**[Link to original bug (#591478)](https://bugzilla.gnome.org/show_bug.cgi?id=591478)**
## Description
If 2 surface plots are included in teh same chart, the first one is drawn and then the second one without regard to which surface is closer to the view point.
I will be attaching a file showing two charts that only differ in the order of the surface plots. In the right chart the lower surface hides the upper surface.
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/16Allow to specify the starting values when major ticks are set to 2 (or bigger)2018-05-22T13:02:02ZBugzillaAllow to specify the starting values when major ticks are set to 2 (or bigger)## Submitted by Christian Göbel
**[Link to original bug (#563850)](https://bugzilla.gnome.org/show_bug.cgi?id=563850)**
## Description
When working with the xy-chart in Gnumeric I found myself several times willing to have an uneven...## Submitted by Christian Göbel
**[Link to original bug (#563850)](https://bugzilla.gnome.org/show_bug.cgi?id=563850)**
## Description
When working with the xy-chart in Gnumeric I found myself several times willing to have an uneven starting number on the X-axis combined with major ticks that are set to the value "2".
Obviously this could be handy for the Y-axis, too.
Description:
Imagine you want to visualise XY-values:
x y
1995 1
1996 2
1997 3
...
Currently there there is no way to specify that the numbers of the x-axis start with the value 1995 - when major ticks are set to 2.
From the UI-perspective the requested option should only appear when major ticks have values bigger than one. A toggle starting value button would be a handy solution.
To illustrate the "problem" I will attach a small example-file. (Maybe it is just me but I would think that 2005 would be a natural starting point in this case).
Right now it seems that when major ticks are set to 2 then only even numbered values are shown.
Anyway, thanks a lot for providing Gnumeric!! I love the fact that all the properties can be manipulated at a single place.
Version: GIT
### Depends on
* [Bug 414383](https://bugzilla.gnome.org/show_bug.cgi?id=414383)https://gitlab.gnome.org/GNOME/goffice/-/issues/15Bad accounting formats when the currency symbol follows the amount2018-05-22T13:01:28ZBugzillaBad accounting formats when the currency symbol follows the amount## Submitted by andre brunet
**[Link to original bug (#556633)](https://bugzilla.gnome.org/show_bug.cgi?id=556633)**
## Description
I used the icon (not the menu) to format a number like 1232,45 € (german localized gnome) in a selec...## Submitted by andre brunet
**[Link to original bug (#556633)](https://bugzilla.gnome.org/show_bug.cgi?id=556633)**
## Description
I used the icon (not the menu) to format a number like 1232,45 € (german localized gnome) in a selected cell but it looked like this:
1234,45 €
123,23 €
....
but it should look like this:
1234,45 €
123,23 €
I did'nt find this in the reported bugs (I searched "currency")
Thank you very much for gnumeric.
Version: 0.7.x
### Blocking
* [Bug 647218](https://bugzilla.gnome.org/show_bug.cgi?id=647218)https://gitlab.gnome.org/GNOME/goffice/-/issues/14Need more test2018-05-22T13:01:02ZBugzillaNeed more test## Submitted by Hiroyuki Ikezoe
**[Link to original bug (#529832)](https://bugzilla.gnome.org/show_bug.cgi?id=529832)**
## Description
There are no sufficient test in GOffice.
I need it!## Submitted by Hiroyuki Ikezoe
**[Link to original bug (#529832)](https://bugzilla.gnome.org/show_bug.cgi?id=529832)**
## Description
There are no sufficient test in GOffice.
I need it!https://gitlab.gnome.org/GNOME/goffice/-/issues/13providing graph/chart only library2018-05-22T13:00:30ZBugzillaproviding graph/chart only library## Submitted by Kouhei Sutou `@kou`
Assigned to **Emmanuel Pacaud `@EmmanuelP`**
**[Link to original bug (#527294)](https://bugzilla.gnome.org/show_bug.cgi?id=527294)**
## Description
libgoffice is great!
I want to use libgoffice ...## Submitted by Kouhei Sutou `@kou`
Assigned to **Emmanuel Pacaud `@EmmanuelP`**
**[Link to original bug (#527294)](https://bugzilla.gnome.org/show_bug.cgi?id=527294)**
## Description
libgoffice is great!
I want to use libgoffice in my application to output some graphs but I don't want it to depends on GTK+. Because it isn't a GUI application. I will use gog_graph_render_to_cairo() to output some graphs.
I know that libgoofice has --without-gtk option. But if I use the option, I can't use same libgoofice installation with other GUI applications that uses libgoffice like Gnumeric.
If libgoffice provides graph related (no UI) package (libgoffice-graph?) and libgoffice depends on the package, I will use only the graph related (no UI) package and others will use full libgoffice package. So, my application and other GUI applications will be able to use same libgoffice installation.
Could you consider my request?https://gitlab.gnome.org/GNOME/goffice/-/issues/12Not display # N/A series in a chart2018-05-22T13:00:16ZBugzillaNot display # N/A series in a chart## Submitted by Naud
**[Link to original bug (#522243)](https://bugzilla.gnome.org/show_bug.cgi?id=522243)**
## Description
Would it be possible to have series, kept in a chart's data, that would not be displayed (even in the legend...## Submitted by Naud
**[Link to original bug (#522243)](https://bugzilla.gnome.org/show_bug.cgi?id=522243)**
## Description
Would it be possible to have series, kept in a chart's data, that would not be displayed (even in the legend), when their value is null (or #N/A, or something else, any condition would be great) ?
Or to have a variable data set for charts ?
That would particularly be usefull with radar charts, that could display a variable number of axes...https://gitlab.gnome.org/GNOME/goffice/-/issues/11Best fit line of inverse proportional quantities2018-05-22T13:00:00ZBugzillaBest fit line of inverse proportional quantities## Submitted by Maciej Marcin Piechotka `@mpiechotka`
**[Link to original bug (#521521)](https://bugzilla.gnome.org/show_bug.cgi?id=521521)**
## Description
Good for for example Boyle's law charts ;)
Best fit line for y = a/x
(Poss...## Submitted by Maciej Marcin Piechotka `@mpiechotka`
**[Link to original bug (#521521)](https://bugzilla.gnome.org/show_bug.cgi?id=521521)**
## Description
Good for for example Boyle's law charts ;)
Best fit line for y = a/x
(Possibly other negative powers as well - but 1/x is most commonly used).https://gitlab.gnome.org/GNOME/goffice/-/issues/10Color Selector : extend to support multiple simple targets2018-05-22T13:03:23ZBugzillaColor Selector : extend to support multiple simple targets## Submitted by Paul Wayper
**[Link to original bug (#500113)](https://bugzilla.gnome.org/show_bug.cgi?id=500113)**
## Description
When creating an X-Y Chart with point symbols shown, the 'cross', 'plus', and 'star' symbols are obsc...## Submitted by Paul Wayper
**[Link to original bug (#500113)](https://bugzilla.gnome.org/show_bug.cgi?id=500113)**
## Description
When creating an X-Y Chart with point symbols shown, the 'cross', 'plus', and 'star' symbols are obscured by the fill, which is set to be completely opaque. There is no 'transparent' colour easily available on the colour selector dialog, and one has to go into the custom colour chooser to turn the opacity down to zero. As one cannot also save this colour back to the colour selector, it means that you have to go through the custom colour chooser for each series' points that you want to make transparent.
By changing the top row of the colour selector into two buttons, 'Automatic', and 'Transparent', this would be easily available to anyone that wanted a purely transparent fill. Also, a 'save' button on the custom colour chooser would allow the user to save a colour into bottom row of the colour selector, which is already provided for this purpose but which lacks any such functionality.https://gitlab.gnome.org/GNOME/goffice/-/issues/7We need a different UI for each scale maping2018-05-22T12:59:01ZBugzillaWe need a different UI for each scale maping## Submitted by Emmanuel Pacaud `@EmmanuelP`
**[Link to original bug (#414383)](https://bugzilla.gnome.org/show_bug.cgi?id=414383)**
## Description
Bugs #315288, #338624 and #375756 show that we need a dedicated UI for each differen...## Submitted by Emmanuel Pacaud `@EmmanuelP`
**[Link to original bug (#414383)](https://bugzilla.gnome.org/show_bug.cgi?id=414383)**
## Description
Bugs #315288, #338624 and #375756 show that we need a dedicated UI for each different axis maping we have (discrete, linear, log), or we should have (time).
For example, for time axis, we could add a calendar combo box for bounds, and specify tick spacing as number of second, minute, day, etc...
For log axis, major tick spacing entry could have an additional decade unit label.
Version: GIT
### Blocking
* [Bug 563850](https://bugzilla.gnome.org/show_bug.cgi?id=563850)
* [Bug 315288](https://bugzilla.gnome.org/show_bug.cgi?id=315288)
* [Bug 338624](https://bugzilla.gnome.org/show_bug.cgi?id=338624)
* [Bug 375756](https://bugzilla.gnome.org/show_bug.cgi?id=375756)
* [Bug 576000](https://bugzilla.gnome.org/show_bug.cgi?id=576000)https://gitlab.gnome.org/GNOME/goffice/-/issues/6Implement B-Splines interpolation.2018-05-22T12:58:21ZBugzillaImplement B-Splines interpolation.## Submitted by Vladimir Chukharev
**[Link to original bug (#338626)](https://bugzilla.gnome.org/show_bug.cgi?id=338626)**
## Description
More XY chart subtypes are needed, at least similar to Stacked area
(both for linear and spli...## Submitted by Vladimir Chukharev
**[Link to original bug (#338626)](https://bugzilla.gnome.org/show_bug.cgi?id=338626)**
## Description
More XY chart subtypes are needed, at least similar to Stacked area
(both for linear and spline interpolations) and Stacked columns
(with 3 alignments of the columns). More general splines are also
needed, for smoothing the curve.
I want to repeat: Thank you for a great program!
### Blocking
* [Bug 698533](https://bugzilla.gnome.org/show_bug.cgi?id=698533)https://gitlab.gnome.org/GNOME/goffice/-/issues/5In place chart editing2018-05-22T12:58:05ZBugzillaIn place chart editing## Submitted by Diego González
**[Link to original bug (#170204)](https://bugzilla.gnome.org/show_bug.cgi?id=170204)**
## Description
it would be awesome if i could click on a chart and add/modify a title directly,
double click on a...## Submitted by Diego González
**[Link to original bug (#170204)](https://bugzilla.gnome.org/show_bug.cgi?id=170204)**
## Description
it would be awesome if i could click on a chart and add/modify a title directly,
double click on an axis and have its properties displayed, click on a bar of the
chart and have its properties shown.
Pretty much like MS Excel.
I think that would improve quite a lot the way to interact with the charts.
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/4Data point label support2018-05-22T12:57:36ZBugzillaData point label support## Submitted by Reed Hedges
**[Link to original bug (#164484)](https://bugzilla.gnome.org/show_bug.cgi?id=164484)**
## Description
I would like to be able to label the points of an XY graph (either normal or
with lines) with either ...## Submitted by Reed Hedges
**[Link to original bug (#164484)](https://bugzilla.gnome.org/show_bug.cgi?id=164484)**
## Description
I would like to be able to label the points of an XY graph (either normal or
with lines) with either one or both of the data values for that point, but
couldn't figure out how to do this.
Thanks!
reed
Version: GIThttps://gitlab.gnome.org/GNOME/goffice/-/issues/3General-purpose commandline graphing frontend2018-05-22T12:57:23ZBugzillaGeneral-purpose commandline graphing frontend## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#112849)](https://bugzilla.gnome.org/show_bug.cgi?id=112849)**
## Description
I do a lot of processing in commandline-only programs. Most of my output
is in CSV f...## Submitted by Luke Hutchison `@lukehutch`
**[Link to original bug (#112849)](https://bugzilla.gnome.org/show_bug.cgi?id=112849)**
## Description
I do a lot of processing in commandline-only programs. Most of my output
is in CSV format. Given that Gnumeric can import formatted text files, and
that it sounds like Jody will soon be adding support to be able to work in
commandline-only mode (e.g. batch-convert to .xls?), and to plot with the
new graphing framework that he's been working so hard on, it would be nice
if there were an option to take data from a file or from stdin, produce a
sheet from it, and create a graph (perhaps in another sheet), all from the
commandline. This would allow gnumeric to act as a visualization tool for
many commandline-only analysis tools.
Thanks for all the great work you do, Jody.https://gitlab.gnome.org/GNOME/goffice/-/issues/1Support changing major type of plot (eg line -> barcol)2018-05-22T12:56:47ZBugzillaSupport changing major type of plot (eg line -> barcol)## Submitted by Chema Celorio
**[Link to original bug (#66832)](https://bugzilla.gnome.org/show_bug.cgi?id=66832)**
## Description
After creating a graph, the type can't be changed.## Submitted by Chema Celorio
**[Link to original bug (#66832)](https://bugzilla.gnome.org/show_bug.cgi?id=66832)**
## Description
After creating a graph, the type can't be changed.