When making a chart with constant value error bars, the error bars can only be of integer length. Decimal values are rounded to the nearest integer when entered. It should be possible to use decimal values. To reproduce this bug: 1. Make a chart 2. Insert->X Error Bars... (or Y Error Bars...) 3. Click 'Constant Value' for Error Category 4. Under Parameters and Positive, type '0.5'. 5. Try to enter a value for Negative. 6. The Positive value should now have changed to '1' (I'm using Debian's LibreOffice 4.1.5-2+b1 package)
For anyone else experiencing this problem, until this bug is fixed there is a workaround. 1. Fill a column with the desired decimal errors. 2. Under the error bars menu, select "Cell Range". 3. Enter the range of cells you just created (e.g. $Sheet1.$A$1:$A$10 ) 4. LibreOffice should make the error bars the decimal length.
*** Bug 70313 has been marked as a duplicate of this bug. ***
*** Bug 78044 has been marked as a duplicate of this bug. ***
See bug 78044 for a test document and clear description of this behavior. Kind regards, Joren
Katarina Behrens committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1e2107e76b9dbd1213b811960c86f8eae57457e5 fdo#77319: set spinbox value AFTER adjusting no. of decimal places 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.
Is it possible to backport the fix in the 4.3 branch?
(In reply to bruno.binet from comment #6) > Is it possible to backport the fix in the 4.3 branch? It is - I've just requested a code review. But it doesn't really help you w/ the other bug 78048
Now cherry-picked to -4-3: http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-3&id=38f6065b0272ae4bc80f5f35866012b4ea0bc38b