Bug 154165 - Mean Value Line in wrong place when using Logarithmic scale
Mean Value Line in wrong place when using Logarithmic scale
 Status: NEW None LibreOffice Unclassified Chart (show other bugs) 4.1.0.4 release All All medium minor Not Assigned bibisected, bisected, regression Chart Show dependency tree / graph

 Reported: 2023-03-13 16:16 UTC by Cytwow 2023-10-07 05:25 UTC (History) 4 users (show) prashant3.yishu raal rb.henschel stephane.guillou

Attachments
test document, created in LO 7.6 alpha (15.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-13 20:24 UTC, Stéphane Guillou (stragu)
Details

 Note You need to log in before you can comment on or make changes to this bug.
 Cytwow 2023-03-13 16:16:42 UTC ```Description: When inserting a Mean Value Line while a series of data is plotted using a Y axis in Logarithmic scale, the mean value line does not use that scale but linear scale instead. Hence the plotting of the Mean value does not correspond to the values. Steps to Reproduce: 1. Create a series of numbers (let be 1, 5, 10) in column 2. Select this column then click on the 'insert chart' button 3. Configure a Line chart with 'Lines Only' (doesn't really matter but for visual purpose) and Finish the Chart creation 4. In the chart editor, select the created data series, then from the 'Insert' menu, insert a 'Mean Value Lines' 5. Still in chart editor, edit Y axis, in the Scale tab with Logarithmic scale and maximum value equal 1E+(expected mean value) (let be max=1e+6 for the values of 1.) Actual Results: The values are plotted the right way, following the log scale (no problem here). The corresponding Mean Value Line is way higher, 'at the position it would be in linear scale', for our values at 1e+(5.33) Expected Results: I would expect the Mean value Line to be 'around' the original values. I don't know if I'm missing the setting to make it work properly but there doesn't seem to be a way to specify the Y axis of the 'Mean Value Line' as the Mean seems to follow the Y-axis setting of the 'original values' Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.4.6.2 (x64) / LibreOffice Community Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d Calc: CL``` Stéphane Guillou (stragu) 2023-03-13 17:47:38 UTC ```Than you for the report. Reproduced in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 98f35cf85ee66e995610fec92ea5224fbf28dff3 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Already reproduced in: Version: 6.0.0.3 Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; Locale: en-AU (en_AU.UTF-8); Calc: group But it's a regression as the mean line is placed correctly in: OpenOffice.org 3.3.0 OOO330m20 (Build:9567) (zaedee: if you set a bug report to New, please report which version / OS you tested with at the same time)``` Regina Henschel 2023-03-13 18:48:07 UTC `I get no mean line at all in LO 7.6. Could you please attach a document with such chart.` Stéphane Guillou (stragu) 2023-03-13 20:24:25 UTC ```Created attachment 185939 [details] test document, created in LO 7.6 alpha Here is one. The step in extending the y axis range is important as the "mean" line is placed at a ridiculously high value. Please note that for testing in a version that works as expected, one probably has to trigger and update of chart (e.g. in OOo 3.3, I had to double-click on the chart for the line to jump back to where it should be, intersecting the y axis at 5.3).``` raal 2023-10-07 05:25:17 UTC ```This seems to have begun at the below commit in bibisect repository/OS bibisect-41max. Adding Cc: to elixir; Could you possibly take a look at this one? Thanks 024be529205af911606c1476ba24477b6453373c is the first bad commit commit 024be529205af911606c1476ba24477b6453373c Author: Matthew Francis Date: Fri Sep 18 10:54:54 2015 +0800 source-hash-1ed73984639390759d26a2fc0209083d9f984d52 commit 1ed73984639390759d26a2fc0209083d9f984d52 Author: elixir AuthorDate: Mon Apr 1 20:14:07 2013 +0200 Commit: Markus Mohrhard CommitDate: Mon Apr 1 20:48:52 2013 +0200 fdo#51656 : Mean value line starts in wrong place in column graph Change-Id: I2389687e54cec4c0e873bcc120cc21b3c3d11d78```