Apache OpenOffice (AOO) Bugzilla – Issue 73234
Display each n-th data point only
Last modified: 2013-02-24 21:21:05 UTC
If a series contains a lot of points, one needs to adjust symbol frequency (interval) manually.
@Iha: Maybe a good idea.
I'd like to add that if there is no such an ability any plots with more than 20 points cannot be distinguished on black-and-white prints as no symbols can be used and no color is seen.
I am not quite sure what you mean with symbol frequency. Would you like to have an option that makes only each nth point to be displayed?
Yes, it's exactly what I mean. Currently OO with new chart uses symbols to mark points if user chooses "points" or "points with line" chart subtype. It is displayed as "icon" when user chooses "object properties" after selecting data series from chart plot. Plotting applications I used before allowed adjusting the frequency of symbol (here "icon") displaying. So if there are more than one data series per plot and they consist from a lot of points user can choose points and line and adjust points frequency for better plot perception. Also there was a mechanism there for series selection. Currently a data series can only be selected with a mouse on the plot to adjust its visual representation. If there are 5, 10, 15... data series it would be rather hard to select them with a mouse. Golden Software Grapher used a Ctrl modifier to select consequently data series which graphs lie one under another. Or it could be done via a list in a tree. So OO needs an access from its list of series to their visual representation.
The problem with displaying only every n'th data point is that the result can give a wrong impression - for example when outliers are skipped or you hit a sample frequency. I am not sure whether this option might bring some users into trouble. Hm.
I rate this feature to be too dangerous. So I won't implement it.
So the alternative is to display all say 2048 points just from one column. How much processor power and memory it would require? Well known commercial applications like Grapher have such an ability and they are not afraid a user would not see some peak. It is up to a user, to use this feature or not. And user can check it by disabling/enabling the option and looking at the graph or it even can be checked automatically when the data is changed or the chart is to be drawn for the first time. If OO performance would not suffer from displaying such amount of data, this issue is obsolete. If no, I would like to see any solution to this problem.
Since OOo 2.3 the chart does not create shapes when a data point for a given resolution is on the same pixel as its predecessor. Thus only the necessary points will be created. It is no problem to create a chart with 2084 points from one column when the data have any trend. Please give it a try. When there are still performance problems I'd rather invest my time there instead of implementing workarounds. So again, I won't fix this feature.
close the invalid issue