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@lists.freedesktop.org
Reporter: jr87...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
