Created attachment 94731 [details] Images illustrating the problem Problem description: Steps to reproduce: 1. Create a spreadsheet 2. Create a set n of data rows each one containing an x value column, an y value column and two columns containing some asymmetric error bar values, something like: 1 3 .2 .1 3 4 .5 .3 . . . . and so on. Use the leftmost column a x values, the next column as y, and the other two columns as negative and positive range limits. Use positive and negative error indicators with the "same values for both" box unchecked (see mi screen image called BeforeSaving.png). My case the plot should be like my Plot_Before_saving_and_reopening_calc.jpg image. Now save the spreadsheet. 3. Reopen the spreadsheet and now the saved error bar properties look like in PropertiesAfterSavingAndReopeningCalc.png and the saved plot will look like Plot_after_saving_and_reopening_calc.jpg. Current behavior: The errorbars of asimetric error bars (line width, color and the unchecked condition of the "same values for both" box) are not saved. Expected behavior: The same plot asymmetric error bars should appear onece and again after opening and closing a Calc spreadsheet. Operating System: Ubuntu Version: 4.2.0.4 release
Created attachment 94732 [details] Images illustrating the problem
Created attachment 94733 [details] Images illustrating the problem
Created attachment 94734 [details] Images illustrating the problem
Please provide an ODS with data - and then simplify the steps as much as possible, always best to have steps enumerated: 1. Do x 2. do Y 3. Do Z Observed: Expected: This helps QA tremendously. Thanks! Once you attach a document (and if possible provide enumerated steps as to what we should do with THAT document) mark the bug as UNCONFIRMED. Thanks for your understanding
Well, I tried to make a foolproof example in the file I am attaching (Bug.zip). All the instructions are in the spreadsheet, two images are also included. I cannot explain myself any better, so if you can't foolw that it means I am bad at explaining or that you cannot make something foolproof because ..... :-)
Created attachment 94819 [details] Zipped file with explanatory Calc spreadsheet and two images
"so if you can't foolw" should be "so if you can't folow" in my prior comment, sorry.
We shall try :) Thanks!
The bug persists in LO 4.2.2.1
So this is really interesting - the value IS saved - it's just not being read correctly. Working on a bibisect now
Well bibisect isn't cooperating so I'll request one Marking as: New (confirmed) Major -- looks like loss of data to the user even though it's not Highest -- regression Adding to MAB bibisectrequest - Kohei if you don't need feel free to remove the request :)
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7470b3ef17570581fe590a4853de59cac1be6ea5 fix negative error bar range export, fdo#75510 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5da51525fab4d424b76b681ee70f76b54d99f73d add test for fdo#75510 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
It was a nasty export issue. Actually it was in some of my fixes to get the error bar export fixed for 4.0
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e687941b2b5af347a99707783302c0d03b6a5c55&h=libreoffice-4-1 fix negative error bar range export, fdo#75510 It will be available in LibreOffice 4.1.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=787a663d8579921af4176feeb265dea8aac4d50c&h=libreoffice-4-2 fix negative error bar range export, fdo#75510 It will be available in LibreOffice 4.2.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
This bug is active on my Calc 4.1.3.2. It has been a long time error bars are giving me throuble. Right now I notice: 1) No matter how a create them, some times they simply disapear when I operate on other aspects of the chart format or close / open the file. 2) If I copy / paste a graph or simply save it, the error bar format is lost. Sometimes I just loose the format (consistenlty), sometimes I loose the whole bar (seems to be rare, cannot identify well the trigger). 3) If I save the worksheet in MS Excel .xls, the error bars are completly lost. Those bugs exist since 3.X and seems to be here for a long time. Hope it will be fixed someday sooner than later because error bars are such a usefull feature of Calc. Regards and thanks, Braulio Dantas.
please check the dailies - it should be resolved. http://dev-builds.libreoffice.org/daily/master/
As the original poster of this bug I must say it has been notably ameliorated since now the magnitude of the asymmetric error bars are consistently stored and recovered in LO 4.2.3.3 and 4.2.4.1 . But part of the bug still remains in LO 4.2.4.1 since the properties of the error bar line are either not stored or recovered proparly. This is, the line thinness and color must be reset to the desired non default values each time the spreadsheet is reopened. Say you set the line thickness for the error barss to 0.02 and the color to red (or any other set of non-default values), the lines will always have thickness 0.00 and color black (the default properties) after saving and reopening.
Open a new bug report for it.
I confirm that the 4 properties of the error bar line are either not stored or recovered proparly in LO 4.2.3 (style, color, width and transparency). I added DATALOSS since something is lost for the user. I removed "Asymetric" since this happens also for symetric error bars. I will open a new bug as suggested by Markus.
Migrating Whiteboard tags to Keywords: (bibisectrequest) [NinjaEdit]