Bug 107157 - changing the axis range of a bar chart with error bars mangles it
Summary: changing the axis range of a bar chart with error bars mangles it
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks: Chart
  Show dependency tree / graph
 
Reported: 2017-04-14 11:09 UTC by nr.hollow
Modified: 2024-01-29 06:22 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Column bar chart showing STDEV as error bars for petrol/diesel models in UK 2016 publically available data (9.49 KB, image/jpeg)
2017-04-14 11:09 UTC, nr.hollow 		Details
data file with bug graph in (310.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-17 13:26 UTC, nr.hollow 		Details
How it looks in LibreOffice 5.4 (53.30 KB, image/png)
2017-04-17 23:15 UTC, Xisco Faulí 		Details
sample ODS to start at step 7 (310.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-01-29 06:22 UTC, Stéphane Guillou (stragu) 		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 nr.hollow 2017-04-14 11:09:13 UTC 
Created attachment 132561 [details]
Column bar chart showing STDEV as error bars for petrol/diesel models in UK 2016 publically available data

I've had major issues plotting the column chart with error bars chart attached and can find no way of getting the exact format I want.  I really wanted "petrol" "diesel" etc below each column then below that fuel type on the x axis.  If I do this and don't use the legend then when I add the error bar for a particular column bar it ends up on the other column bar (definitely a bug).  

Also I exported the graph as jpeg.  Lucky I did since the next time I opened the calc file the graph had been scrambled and had lost its columns and was unusable.

Its possible that these bugs have been solved in more recent versions of calc but these are serious bugs in what is a very basic type of chart much used in science.
Comment 1 m_a_riosv 2017-04-14 14:00:18 UTC 
Please attach a basic sample file, there is no way to find the issue with only the image.
Comment 2 nr.hollow 2017-04-17 13:26:58 UTC 
Created attachment 132635 [details]
data file with bug graph in
Comment 3 Xisco Faulí 2017-04-17 23:14:30 UTC 
Reproduced in

- Version: 5.4.0.0.alpha0+
Build ID: 7635e0c1c7f821a1081f8e3868f641ae74a172d6
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk2; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

- Version: 5.0.0.0.alpha1+
Build ID: 0db96caf0fcce09b87621c11b584a6d81cc7df86
Locale: ca-ES (ca_ES.UTF-8)

- Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

- Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

- LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 4 Xisco Faulí 2017-04-17 23:15:24 UTC 
Created attachment 132643 [details]
How it looks in LibreOffice 5.4
Comment 5 m_a_riosv 2017-04-17 23:44:36 UTC 
Sorry, maybe not possible, but I think we have not the chart properly defined.

What is the meaning of data values?, what is the difference between values on the first and second row of data?
Comment 6 nr.hollow 2017-04-18 11:34:06 UTC 
The graph was properly defined but was somehow undone when closing and opening sheet.  There is a large amount of freely available data from DFT.   If you double click on the chart right click and select ranges then the correct data is highlighted in blue.

Ta.  NH
Comment 7 QA Administrators 2018-04-19 02:34:29 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2020-04-19 03:36:03 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2022-04-20 03:36:40 UTC Comment hidden (obsolete)
Comment 10 Stéphane Guillou (stragu) 2024-01-29 06:20:16 UTC 
Relying on looking at the mangled chart in the attached document is not enough to reproduce the issue in (newer or older) versions that don't have the bug.
We need steps to get to the broken chart.

Trying to mimic the chart in attachment 132561 [details], I used:

1. Open attachment 132635 [details]
2. Select range E28:F29
3. Insert chart > Next > Data series in columns; Finish
4. Insert > Titles > X axis = "fuel type"
5. Click on the first bar, then Insert > Y Error Bars > Cell Range; turn on "Same value for both"; select cell E30 for the "Positive" field; click OK
6. Repeat for the second bar
7. Change Y axis settings to use a maximum of 120, so the error bar is visible.

Result: bars disappear, error bars are one above the other, shifted to the left border of the chart wall, as in sample document.

- Not reproduced in libreoffice-4.4.0.3
- Reproduced in libreoffice-5.0.0.3 as well as:

Version: 6.1.0.3
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; 
Locale: en-AU (en_AU.UTF-8); Calc: group threaded

- However, not reproduced since 6.2:

Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 11 Stéphane Guillou (stragu) 2024-01-29 06:22:54 UTC 
Created attachment 192229 [details]
sample ODS to start at step 7

(Turns out it's also reproducible without error bars)