Created attachment 74288 [details]
A 3 bar chart (values in column B) and values for symmetric error bars in C. It is not possible to add the error bars under LO 4.0.0.rc2
When you create even a very simple bar chart under LO 4.0.0.r2 it is impossible to create y correct error bars (didn't try x bars) of any kind. The either appear with wrong values or do not appear at all. A simple calc sheeth to test this is include as annex.
I can't reproduce this one with current master branch of 4.1
I'm marking as WFM, if you still have the issue with the release version of 4, please reopen the bug and we'll take a look at it.
Version 18.104.22.168.alpha0+ (Build ID: 027bb41aa16793e88e9fc1b3550c8c893363647)
Thanks Joel, I ma hurring to download 4.1 and give it a try. I liked 4.0.2 very much but I need error bars in my chart sine statistics is central to my work.
Current stable release is 22.214.171.124 release ;) 4.1 is only master build which you won't want to do.
Let us know if it works on 126.96.36.199 release (ie. the current stable release available as of today :) )
Yes the bug as reported does not exist in L= 4.0.3 but it suffers of bug 56730 wich I reported for LO 3.6.x and does not exist in LO 3.5.x
Why did you reopen this bug if you said "as reported it does not exist in 188.8.131.52"?
Sorry for upsetting you Joel for my ignorance of the bugzilla protocol. I will post it as as bug of 4.0.3 which duplicates de bug of 3.6.x which is still unsolved and now was inherited by 4.0.3 :-( .
no no no I'm not upset at all ;) I assumed I was missing something. Your dedication in reporting a bug is exactly what we need to make LibreOffice a better product.
So in this case what we do is close this one as WORKSFORME (since we don't know which patch fixed it), then we just post a comment in fdo#56730 saying that it's still present in 4.0 stable. We don't want to open an identical bug report as 56730 just because the bug exists in 4.0
Again, please don't think that I am discouraging your input! It is greatly appreciated
THe bug is not fixed. It does not show with the simple spreadshheat I posted. But when I tried 4.0.03 v of LO with an actual calc spreadsheath (fairly complex) which I use profesionally the error bars still could not be added. My problem is that I cannot submit the spreadsheath since it has corporative private data.
I had to downgrade LO to 3.5 in order to have a workable version.
I just noticed that if I open the spreadsheath created with LO 3.5 with error bars, but open it with 184.108.40.206 the error bars are in the charts BUT INVIBLE, you will get only the option to edit them or erase them but you won't see them. Evereythink will look OK if you reopen the the same file with LO 3.5 once again.
Hope it helps.
Sory for the typos.
Created attachment 74871 [details]
See comment including Spreadsheth_test_2.ods
In Spreadsheth_test_2.ods error bars are included, they show under LO v 3.5xxx but not under LO 220.127.116.11.
I managed to deface a page of my work spreadsheath as to remove confidential information. It is annexed as Spreadsheth_test_2.ods. The chart at bottom has data bars with error bars, the error bars shoe under LO Calc v 3.5xxxxx but not under LO Calc 18.104.22.168
"shoe" means "show" in the comment above
I tried Calc in LO 22.214.171.124 under MS Windows 7 (Installed in VirtualBox over Ubuntu 12.10) and the bug exists under Windows 7.
indeed, I see the issue now! Thanks for clarifying.
Major is appropriate as there is apparent loss of data at least for those using version 4, furthermore regression.
Markus - want to take this one?
To me is major. I won't be able to upgrade from 3.5 until this issue is fixed, and I like very much the rest I see in LO 4. Thanks.
126.96.36.199 (Build ID: 2c0c17a6e4bee0ee28131ea4bdc47edc700d659) still has the bug
Please test in master/4.0.2
Loading the sheet in comment #12: https://bugs.freedesktop.org/attachment.cgi?id=74871 in master and 4.0.2rc1 shows no error bars :-)
Well - actually it seems to show Y error bars present (but not rendered) in a primarily x bar direction - so perhaps there is some minor X/Y confusion ?
So the big confusion here comes from having 2 independent issues in one bug report. Please use one bug report per issue.
The adding error bars bug has been fixed while there seems to be another issue with opening the file.
And looking into the test file the range is missing so the problem is expected.
If you can still produce these documents with 188.8.131.52/master please give me a step by step instruction.
But this has to be with a new and clean document and not with an already broken document.
I suppose we can close this bug now.
I have checked extensively LO v4.02 under Linux (and less extensively under Windows 7) and the bug seem completely fixed. So this bugzilla thread may certainly be closed. Many thanks.