GNOME Bugzilla – Bug 129706
engineering notation broken
Last modified: 2006-04-04 19:19:40 UTC
Engineering notation is a scientific notation varient where the exponent is restricted to a multiple-of-3. This used to be achievable in gnumeric (and excel) using the custom cell format ##0.0E+0 however that now produces the same output as conventional scientific notation. for example, enter 0.01 into a cell format->number->custom->##0.0E+0 preview is +1.0E-02 but should be +10.0E-03 checked on recent gnumerics, including 1.2.2
*** Bug 324174 has been marked as a duplicate of this bug. ***
Created attachment 62591 [details] [review] Implementation of engineering notation Here's a patch that fixes this issue, but non only. It also adds an engineering notation check box in format dialog. And it adds a new scientific format with superscript via pango markup, with its corresponding superscripted checkbox in format dialog. UI is disabled by default, but can be enabled with go_format_sel_new_full. Use case for this format is nice axis labeling in graphs.
Comment on attachment 62591 [details] [review] Implementation of engineering notation Looks good, except for two details. 1. The check button for engineering notation needs a tooltip. 2. The glade file needs to be edited by hand and have the following killed. (Alternatively, run glade with gtk+ 2.6) (gnumeric:15327): libglade-WARNING **: unknown property `urgency_hint' for class `GtkWindow'
Created attachment 62751 [details] [review] Improved patch I've commited this improved version of my previous patch.
It doesn't look like this actually got committed.
It's in now.