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: 2023-03-20 03:26 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 
Dear richard_g,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug