GNOME Bugzilla – Bug 708556
keyboard shortcut to format with 2 decimal places does not work
Last modified: 2013-10-05 19:58:40 UTC
I'm running Gnumeric 1.12.6 on Ubuntu 13.10. According to the Gnumeric help page Keybinding Reference, the keyboard shortcut Ctrl+! formats the current selection as a number with 2 decimal places. But if I enter 1.2345 in a cell, select it and press Ctrl+!, I see just "1", formatted with 0 decimals. So either the documentation or the implementation is wrong.
ctrl-! triggers: static GNM_ACTION_DEF (cb_format_as_number) { GOFormat *fmt = go_format_new_from_XL ("0"); apply_number_format (wbcg, fmt, _("Format as Number")); go_format_unref (fmt); } So it looks like this may be a documentation issue rather than an implementation issue. Note that <control>dollar formats as currency with 2 decimals and 2 decimals is most likely used for currency values.
Agreed -- documentation problem.
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.