When right-clicking on a point on a graph in Spreadsheet, you are given the option to insert Y Error Bars, however, no option to insert X Error Bars. Such a feature would make data ranges easier to handle in Physics classes, Chemistry classes, or any other class which requires the student to work with uncertainties.
Created attachment 52466 [details]
This is a workaround, but does not actually fix the issue.
The file was copied from the OOO bug page, all credit goes to sztejkat.
A trick how to emulate X and Y error bars.
This is a trick showing how one can emulate X and Y error bars in OpenOffice
Calc. Not nicely looking and to very easy but works automatically.
Bold cells are inputs. X+/X- Y+/Y- are values of error ranges, in this example
calculated by simple formulas. All other are copies of input values arranged in
such an order that chart looks like if it would have x and y values. There is
even a possibility to insert regression formulas as errors will nullify itself,
with one exception - the R2 (fit coefficient) will be incorrect.
Hope it will be useful,
Please, don't change version! See rules here:
(In reply to comment #2)
> Please, don't change version! See rules here:
Ah, well this issue has been around since OOo 1.1.3 in 2005, I didn't know what to put.
You can leave the first version of LibO (not OOo) that *you* have directly observed the behavior.
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
The feature request still hasn't been fixed in 3.5.0 Beta2.
Reverting back to "NEW".
*** Bug 47780 has been marked as a duplicate of this bug. ***
Just a +1 from me, it's an important feature to have if LibreOffice should ever be usable in a scientific field.
These conversations appear to show patches for this bug, however it is not clear if they are confirmed as committed which would allow this bug to be solved. If a solution has been found that would be great as this feature has often been requested.
Part of the patchs are already merged to the master but still not a complete solution, trying to finish the last details for the upcoming 3.6 release.
This feature is available in 3.6 for calc and importing/exporting xls,ods.
*** Bug 51156 has been marked as a duplicate of this bug. ***