After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 68866 - Format numbers to fixed significant digits
Format numbers to fixed significant digits
Status: RESOLVED WONTFIX
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Low enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 510286 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2002-01-16 17:44 UTC by Adrian Custer
Modified: 2013-04-16 00:52 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Adrian Custer 2002-01-16 17:44:18 UTC
It would be useful to be able to format numbers to a fixed level of
significance. Just as we can now format a number to have a certain level of
precision (figures after the decimal point), it would be relevant to format
cells with a certain level of significant digits. Say you had the following
numbers:

12.34567789
1.99999999
101.456789
14.5555555

format to fixed precision (say 2 decimal places) currently gives:
12.35
2.00
101.46
14.56

(Note these have different sizes so in a table we need to accomodate all
cells to have the spacing of the largest number.)

format with fixed significant digits (say four) would give:
12.35
2.000
101.5
14.56

( and all cells would have the same size. )

For science, sig.figs are more relevant than fixed precision.

If we wanted to get *CRAZY* we could make gnumeric able to track
significant digits through a calcualtion so any cell would only contain the
significance level of the lowest value that it depended on. Say:

A1 is 12.34
A2 is 32
B1 is =A1/A2
C1 is 134.2234433
D1 is =B1*C1 formated with dependent sig.figs would give: 52 i.e. the value
of the calculation rounded to the lowest number of sig.figs in the
calculation. 

another crazy idea for the extend period. :-)

--adrian
Comment 1 Andreas J. Guelzow 2002-01-16 19:26:41 UTC
Of course in the last example the `2' is not significant any more and
an honest implementation should show 50. 
Comment 2 Jody Goldberg 2002-01-16 19:52:19 UTC
We'll add this just as soon as we support arbitrary precision calculations.
Its a nice idea, but the engine will require a heck of alot of cleanup before
we can even begin to think of this.
Comment 3 Andreas J. Guelzow 2010-07-14 17:36:01 UTC
*** Bug 510286 has been marked as a duplicate of this bug. ***
Comment 4 Morten Welinder 2013-04-16 00:52:43 UTC
A nice idea, but it clearly isn't meant to happen.  No action in 11 years
is a hint.

It also would make it harder to share spreadsheets between Gnumeric and
other spreadsheets.

Therefore -->WONTFIX.  The workaround is to use formulas to round as
desired.  (But such rounded results should probably not be used as input
to other expressions.)