Bug 48883 - Automatic axis scaling does not recognize Smooth Lines values exceeding auto-ranges
Summary: Automatic axis scaling does not recognize Smooth Lines values exceeding auto-...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2012-04-18 08:27 UTC by Florian Reisinger
Modified: 2017-06-17 12:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
test document (121.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-04-18 08:27 UTC, Florian Reisinger
Details
more samples, more simple (27.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-05-11 11:10 UTC, Rainer Bielefeld Retired
Details
OpenOffice 2.3 screenshot (14.75 KB, image/png)
2012-05-12 08:57 UTC, Florian Reisinger
Details
New sample (17.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-05-12 09:02 UTC, Florian Reisinger
Details
VeryNewSample.ods (94.60 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-04-15 14:46 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Florian Reisinger 2012-04-18 08:27:01 UTC
Created attachment 60261 [details]
test document

Create a new document.
Use two solums of numbers (like:

-1	3
2	0
-4	1
0	4
3	1
-3	2
1	5
4	2
-2	3
2	6
5	3
-1	4
3	7
6	4
0	5
4	8
7	5
1	6
5	9
8	6
2	7
6	10
9	7
3	8
7	11
10	8
4	9
8	12
11	9
5	10
9	13
12	10
6	11
10	14
13	11
7	12
11	15
14	12
8	13
12	16
)
Create a new chart -> Choose XY and Just lines. Now enable / diable curve smoothing.

IS:

Not cut when disabling curve smoothing, but cut when enabled...

SHOULD: Not be cut...

Win 7 x64: LibO 3.5.2; OO.org 2.4.1
Ubuntu 12.04 : LibO 3.5.2; 3.4.6
Comment 1 Markus Mohrhard 2012-05-10 18:31:55 UTC
Most likely related to problems in the b-spline implementation. Related to Bug 47787
Comment 2 Rainer Bielefeld Retired 2012-05-11 11:10:35 UTC
Created attachment 61465 [details]
more samples, more simple

I can reproduce the Effect, but IMHO not a bug. 

By definition such a "Stacked Series - Percent" chart only can show a range 0% ... 100%, what the smoothing will exceed. So that line parts can not be shown. The question is whether user needs suggest other solutions looking more elegant. Any suggestions (what show "correct" results, what ever that might mean)?
Comment 3 Rainer Bielefeld Retired 2012-05-11 11:12:23 UTC
@Florian
Did you ever see that working in a different way in other versions?
Comment 4 Florian Reisinger 2012-05-12 07:01:28 UTC
It looks the same in OO.org 2.3
@Rainer: Where is the 0% 100% range??
Comment 5 Rainer Bielefeld Retired 2012-05-12 07:21:19 UTC
> @Rainer: Where is the 0% 100% range??

The Y-Axis (0% ... 100%).
What, by the way, shows a workaround for some applications. If you define the Y-range manually from -10% ... 110% (for example), the gaps in the data series line disappear. 

So may be the final solution can be a more smart auto axis range calculation?
Comment 6 Florian Reisinger 2012-05-12 08:57:57 UTC
Created attachment 61499 [details]
OpenOffice 2.3 screenshot

@ Rainer: I still can't see the percentages anywhere!
Please upload a screenshot too....
Comment 7 Florian Reisinger 2012-05-12 08:58:36 UTC
Change to earliest version ( OO.org 2.3)
Comment 8 Florian Reisinger 2012-05-12 09:02:37 UTC
Created attachment 61500 [details]
New sample

I marked yours as obsolete, because in your case it would not be a bug ( I agree -10 % is kind of silly ;) )
Comment 9 Rainer Bielefeld Retired 2013-04-15 14:44:30 UTC
Back to the roots with new Summary.

Indeed, Mew sample 2012-05-12 09:02 UTC, Florian Reisinger shows several cases, and I added a VeryNewSample.ods showing that also X-Axis is affected.


Possibly unrelated:
IMHO th percent-chart-problem is not directly related, because there an additional problem is that it's impossible to exceed axis-rang, and other questions need clarification, I will submit a separate bug for that.

@Markus:
Because your activity in Bug 47787 I think you also should proceed this one. Please change  Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf
Comment 10 Rainer Bielefeld Retired 2013-04-15 14:46:25 UTC
Created attachment 77998 [details]
VeryNewSample.ods