Bug 100064 - Cannot remove error bars along Y axis when errors are defined on a cells range
Summary: Cannot remove error bars along Y axis when errors are defined on a cells range
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.0.6.2 rc
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency tree / graph
 
Reported: 2016-05-26 12:30 UTC by richard_g
Modified: 2024-11-03 23:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
File with two XY charts having X and Y error bars (23.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-26 12:30 UTC, richard_g 		Details
Y Error bars dialog box after selecting "None" (38.33 KB, image/png)
2016-05-26 12:31 UTC, richard_g 		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 richard_g 2016-05-26 12:30:05 UTC 
Created attachment 125293 [details]
File with two XY charts having X and Y error bars

Hello,

I have an XY chart with error bars that were set on the Y axis using the “Cells range” option. When trying to remove these error bars, the dialog box that comes with menu “Insertion→Error bars on Y axis” opens with “Cells range” selected. When selecting “None”, some fields in the bottom of the dialog box are superimposed and the “OK” button is disabled. The only way to remove these error bars is pressing the “Enter” key.

I attach an ods file with two XY charts in order to reproduce the problem. The X value is defined in column A, the Y value is defined in column B, the X error is defined in column C and the Y error is defined in column D. Both charts show the same XY curve, but the first one with the error bars on the X axis and the second one with error bars on the Y axis. Errors bars have been set using “Cells range” on C and D columns.

Edit the first chart, select menu “Insertion→Error bars on X axis”: the dialog box opens with “None” option selected. When clicking on the “OK” button, the error bars are removed and the dialog box is closed. This is the expected result.

Now edit the second chart, select menu “Insertion→Error bars on Y axis”: the dialog box opens with the “Cells range” option selected. Some fields in the bottom of the box are superimposed (see attached image) and clicking on the “OK” button has no effect. Pressing the “Enter” key removes the error bars and closes the dialog box.

Richard
Comment 1 richard_g 2016-05-26 12:31:41 UTC 
Created attachment 125294 [details]
Y Error bars dialog box after selecting "None"
Comment 2 A (Andy) 2016-05-26 18:31:17 UTC 
Reproducible with LO 5.1.3.2, Win 8.1 (also with a clean new file)

Steps done:
1. Open CALC
2. As a test sample fill four columns with numbers for the x and y values and for the x and y error
3. Select the cells of the first two columns
4. Go to INSERT -> CHART and select the type Line: Points and Lines and click FINISH
5. Repeat step 4 to have a second chart
6. Double-click to select the first chart to edit it and then go to INSERT -> X-ERROR BARS and select CELL RANGE and for Positive (+) use column C and Negative (-) column D
7. Double-click to select the second chart to edit it and go to INSERT -> Y-ERROR BARS and select CELL RANGE and for Positive (+) use column C and Negative (-) column D
8. Now double-click on the first chart with x-error bars (from step 6) to select to edit it and go to INSERT -> X-ERROR BARS and click OK
-> The x-Error Bars are removed
9. Now double-click on the second chart with y-error bars (from step 7) to select to edit it and go to INSERT -> Y-ERROR BARS
10. Now you have to select NONE as Error Category (different to step 8)
-> You will see the result from the attachment
If you try to click OK it is not working.  If you press ENTER it works.  To make the OK button working you have to enlarge the window until everything is shown fine.
Comment 3 QA Administrators 2017-09-01 11:16:59 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2021-03-19 04:40:35 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2023-03-20 03:26:33 UTC Comment hidden (obsolete)
Comment 6 LeroyG 2024-10-31 17:05:47 UTC 
Reproducible with:

Versión: 6.4.7.2 (x64)
Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5
Subprocs. CPU: 4; SO: Windows 10.0 Build 17763; Repres. IU: predet.; VCL: win; 
Configuración regional: es-AR (es_AR); Idioma de IU: es-ES
Calc: threaded

Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: ee3885777aa7032db5a9b65deec9457448a91162
CPU threads: 4; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: es-MX (es_AR); UI: en-US
Calc: threaded

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 17763); UI render: Skia/Raster; VCL: win
Locale: es-AR (es_AR); UI: pt-BR
Calc: threaded


BUT: The dialog can be resized manually, then the OK button is accesible with the mouse pointer.
Comment 7 LeroyG 2024-11-03 23:24:53 UTC 
Not reproducible with:

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded