Problem description: Error bars cannot be easily inserted and disappear after save and close.
Steps to reproduce:
1. Create Bar Chart
2. Right click and select Insert Y error bars/Cell Range
3. Click field icon to right, nothing happens. If written in by hand, error bars disappear after saving, closing and reopening.
Current behavior: Error bars do not insert and disappear on saving.
Expected behavior: Error bars are inserted and persist on saving.
Operating System: Mac OS X
Version: 220.127.116.11 release
Thanks for your time reporting.
I know there were problems related to error bars, and Markus (a core developer) did great job squashing as much bugs as possible. Therefore I'm going to ask you if you see the possibility to retest using our Release Candidate of LibreOffice 4.0.2(.1) that you can download here: http://www.libreoffice.org/download/pre-releases/
Is this behavior still reproducible using this version?
Thanks in advance for your feedback,
*** Bug 62390 has been marked as a duplicate of this bug. ***
Seems to work in master so please check with 18.104.22.168
Oddly,hey still disappear in 22.214.171.124 prerelease, but only when the file is saved as .xls. When the file is a .ods they save normally.
126.96.36.199 prerelease also fails to save error bars when saved as .xls or .xlsx spreadsheets. Error bars save properly in .ods, but not .xls or .xlsx.
Serious issue, as people relied upon this for spreadsheet compatibility.
Sharky: Please leave version on 188.8.131.52 since that is the version the bug first appeared. Comments are used to state that the bug is still valid in newer version.
Is it possible to attach an example document so it's easier for others to test and verify as well?
Created attachment 77230 [details]
Example spreadsheet added. Attempting to add the "Error" column as Y error bars to the columbs in chart works only until reopening file. Closing spreadsheet results in loss of error bars. This is true for .xls and .xlsx files.
Ok, I'll check it and hopefully with the error bar rework from the last days it is a bit easier to implement it.
Looking at the export code this was not implemented for OOXML export. I haven't looked into XLS but my motivation for fixing the XLS case is not that big.
*** Bug 64018 has been marked as a duplicate of this bug. ***
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
export for error bars to OOXML, fdo#62312
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:
Affected users are encouraged to test the fix and report feedback.
Marking FIXED per comment 11