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
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)
I get no mean line at all in LO 7.6. Could you please attach a document with such chart.
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).
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 <mjay.francis@gmail.com> Date: Fri Sep 18 10:54:54 2015 +0800 source-hash-1ed73984639390759d26a2fc0209083d9f984d52 commit 1ed73984639390759d26a2fc0209083d9f984d52 Author: elixir <prashant3.yishu@gmail.com> AuthorDate: Mon Apr 1 20:14:07 2013 +0200 Commit: Markus Mohrhard <markus.mohrhard@googlemail.com> CommitDate: Mon Apr 1 20:48:52 2013 +0200 fdo#51656 : Mean value line starts in wrong place in column graph Change-Id: I2389687e54cec4c0e873bcc120cc21b3c3d11d78
Dear Cytwow, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug