[Libreoffice-bugs] [Bug 107508] New: XY Chart auto scaling on X axis with only 1 data point generates excessive number of major units

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107508
           Summary: XY Chart auto scaling on X axis with only 1 data point
                    generates excessive number of major units
           Product: LibreOffice
           Version: 5.2.6.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: jr87654 at gmx.com

Description:
Axis auto scaling with only 1 data point is not really possible, so sensible
defaults need to be applied. The defaults generated by auto-scaling an XY
scatter chart axis span too large a range, with a large number of major units
on the scale. On a date scale, the maximum can be several centuries ahead.


Steps to Reproduce:
1. Create a Calc spreadsheet, with two columns and 1 date in Col A and 1 value
in Col B.
2. Insert XY Chart (using the wizard, or manually configured so that X = Col A
and Y = Col B with auto-scaling) and observe the X-axis.
3. Copy the date into the value cell and observe the Y-axis with the same issue
(but with a different range).

Actual Results:  
Large number of major units on the scale. If these are dates, the maximum can
be several centuries ahead.

Expected Results:
1. Axis comprising 1 or 2 major scale unit(s).
or
2. No scale on the axis, just a single axis label (as in Line or Bar Chart with
a single data point).



Reproducible: Always

User Profile Reset: No

Additional Info:
This matters when using Chart with Grouped data, for example in database
reports, to produce a series of XY scatter charts with different X-axis ranges
for which auto-scaling would be ideal when the scale can't be preset. However,
if a data group has only 1 data point, the auto-scale'd result is completely
out of line with the other charts (and the chart looks ridiculous).

AFAIK Other proprietary Office packages do one of Expected Results above.

Simple Calc file singlepointtest.ods attached to demonstrate the issue.



User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101
Firefox/50.0

-- 
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/20170428/17dd5f48/attachment-0001.html>