Bug 107508 - XY Chart auto scaling on X axis with only 1 data point generates excessive number of major units
Summary: XY Chart auto scaling on X axis with only 1 data point generates excessive nu...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency tree / graph
 
Reported: 2017-04-28 16:57 UTC by branestawm
Modified: 2024-04-01 11:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Simple Calc file showe auto scaling weakness with 1 data point (13.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-28 16:59 UTC, branestawm 		Details
Example of actual behaviour (screen scrape) (151.10 KB, image/jpeg)
2017-04-30 22:03 UTC, branestawm 		Details
Example of expected/preferred behaviour (image mock-up) (21.58 KB, image/jpeg)
2017-04-30 22:04 UTC, branestawm 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description branestawm 2017-04-28 16:57:06 UTC 
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
Comment 1 branestawm 2017-04-28 16:59:36 UTC 
Created attachment 132943 [details]
Simple Calc file showe auto scaling weakness with 1 data point
Comment 2 branestawm 2017-04-30 22:03:34 UTC 
Created attachment 132978 [details]
Example of actual behaviour (screen scrape)
Comment 3 branestawm 2017-04-30 22:04:41 UTC 
Created attachment 132979 [details]
Example of expected/preferred behaviour (image mock-up)
Comment 4 branestawm 2017-04-30 22:08:00 UTC 
Using LO v5.2.6.2 downloaded from LO website on 29/4/2017 on OpenSuse 13.2 x64
Comment 5 Buovjaga 2017-05-13 11:11:53 UTC 
Repro.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha1+
Build ID: c0968aa4673a8ac9a8a09a0e291b58b94bdbb35e
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on May 13th 2016

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 6 QA Administrators 2018-05-14 02:28:58 UTC Comment hidden (obsolete)
Comment 7 branestawm 2018-05-14 20:03:23 UTC 

(In reply to QA Administrators from comment #6)

AFAIK, charting in LO Base v6 is comprehensively broken, so I can't test this bug in LO v6.

I have tried most releases (from TDF website) since LO v5.3, and have found that charting in LO Base is broken in one way or another in all them. Running a chart report produces a blank space where the chart should be. Clicking on a chart in Report Builder (to edit it or check settings) likely crashes LO Base. So I am sticking with LO v5.3.6.1 in a separate install for Base reporting, which still works for me (well, works well enough).

Text reports in LO Base v6 and previous versions work well. Report Builder 
seems a lot more stable than it was. So the regression with charts is disappointing - and hard to understand as there seems to have been no changes in LO Base functionality (nothing in release notes).

I have experimented with scripts to recreate chart reports for each new LO release, because recreating the reports has resolved some issues in the past, but without success for charts. It seems to me that the issues are not in Report Builder itself but with the underlying API.

Just to confirm that I am running LO from TDF on OpenSuse 42.3 x64.
Comment 8 QA Administrators 2019-05-15 02:56:58 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2021-05-15 04:17:36 UTC Comment hidden (obsolete)
Comment 10 branestawm 2021-06-29 18:08:05 UTC 
Bug couldn't be tested, because charts aren't shown since LO 5.4.0.3. See bug 117162
Comment 11 QA Administrators 2023-06-30 03:13:25 UTC Comment hidden (obsolete)
Comment 12 branestawm 2024-04-01 11:30:48 UTC 
(In reply to QA Administrators from comment #11)

Bug persists in LO 7.4.3.2 on OpenSUSE LEAP 15.5.