Bug 78048 - FORMATTING: "constant value" error bars can't be arbitrary small or big
Summary: FORMATTING: "constant value" error bars can't be arbitrary small or big
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Chart
  Show dependency treegraph
Reported: 2014-04-28 20:53 UTC by bruno.binet
Modified: 2020-09-16 12:11 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

simple XY chart with error bars (standard deviation) (48.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-28 20:53 UTC, bruno.binet

Note You need to log in before you can comment on or make changes to this bug.
Description bruno.binet 2014-04-28 20:53:28 UTC
Created attachment 98141 [details]
simple XY chart with error bars (standard deviation)

In science charts, values can be very small or large on an axis. For a "constant value" error bar, it is impossible to enter a value of 2E26 or 3E-5, for example (nothing is displayed).

In the attachment file, there is a graph with standard deviation error bars. If you edit the Y error bar and choose the "constant value" category (error bar tab) with a value of 2E26, it should work (but it doesn't). For the X error bars, you can't specify 5E-4 (or even 0,0005).

So in brief, scientific notation numbers never works for constant error bars and even decimal numbers in some cases.
Comment 1 Jorendc 2014-05-16 21:05:07 UTC
Thanks again for your clear bug report!

I can confirm this behavior, tested using Windows 8.1 with LibreOffice Version: Build ID: 48eccfb812284f43ba24c3be3903537ce954944d
TinderBox: Win-x86@39, Branch:master, Time: 2014-05-16_00:35:19

Kind regards,
Comment 2 bruno.binet 2015-03-24 00:55:24 UTC
Bug still present in LO

Even if bug 77319 (related) has been solved, the present issue remains.
Comment 3 tommy27 2016-04-16 07:28:04 UTC Comment hidden (obsolete)
Comment 4 bruno.binet 2016-06-07 19:08:21 UTC
The bug is still present in the 5.0 branch (tested here on linux mint 17.3).
Comment 5 bruno.binet 2017-03-08 00:31:31 UTC
Still present in 5.2.5
Comment 6 QA Administrators 2018-03-09 03:46:11 UTC Comment hidden (obsolete)
Comment 7 Puja kumari 2020-09-16 12:11:02 UTC
thank you for bug details.
https://www.bloglovin.com/@pujakumari79 visit here for comploaint letter