[Libreoffice-bugs] [Bug 136963] New: chart upper Y bound is 1.2 when real range upper bound is 1

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136963

            Bug ID: 136963
           Summary: chart upper Y bound is 1.2 when real range upper bound
                    is 1
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: musicman at strannik.com

Description:
I'm plotting a series of values, scaled against their maximum. For example, the
cell D2 contains "=B2/MAX($B$2:$B$27)", and the same repeated through D3:D27.
The adjusted cell reference is B2, changed to B3-B27.

The important point is that no cell value in column D is greater than 1.

But if I try to plot column D on a chart, the upper bound of the chart is 1.2.
No value in column D is greater than 1.

Why is the chart-bounding algorithm adding that extra space?

Steps to Reproduce:
1. Start a new spreadsheet.
2. In A1, enter "0", and in A2, enter "1". Select these two cells.
3. From the menu: "Insert"/"Chart..."
4. A dialog opens up, pertaining to the chart that's already added to the
spreadsheet. It's a column chart. Move the dialog out of the way, so you can
see the chart.

Actual Results:
The chart's maximum Y-value is 1.2, even though the actual maximum value in the
data range is 1.

Expected Results:
The maximum Y-value on the chart should be 1, not something larger.


Reproducible: Always


User Profile Reset: No



Additional Info:
Slackware-current. I can confirm this on both 6.2.8.2 and 7.0.1 versions of
LibreOffice.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200923/694fbba0/attachment.htm>