GNOME Bugzilla – Bug 510252
inc/dec decimal toolbar do nothing for 'General' formats
Last modified: 2008-04-06 00:39:37 UTC
pressing the increase or decrease decimals buttons gives no action
Seems to work for me: 1. Enter 42 in A1. 2. Format as number with two decimals. 3. Press the "+" button and observe three decimals. Please be more specific, see http://www.gnome.org/projects/gnumeric/how-to-help.shtml
More specific: new sheet in A1 enter "3" select A1 press one of the buttons. nothing changes. The buttons don't seem to like the "General" format. If you change the cell format to a number format, things work fine.
This is not windows specific. The problem is twofold 1) There is no feedback that General is ignored 2) XL and OOo do convert from General -> number
*** Bug 521544 has been marked as a duplicate of this bug. ***
Fixed in trunk. Please test for expectations before I backport.
*** Bug 525262 has been marked as a duplicate of this bug. ***
Patch committed to stable branch.
The buttons now works but in an odd way. When a cell is formatted as General, an infinite decimal (such as 2/3) is shown with 14 decimal cases. Pressing consequently the - button I would expect it to decrease to 13 decimal cases, then 12, etc But what happens is it jumps from 14 to 7... Inversely pressing the + button jumps from 14 to 9 (which is coherent) Excel decreases the number of decimals shown. If a cell width only allows to display 4 decimal cases then pressing - decreases to 3 and pressing + increases to 5 and automatically increases the column width. I think this is more intuitive.
I don't think that increasing the column width is a good idea! This can mess up any setup for printing.
Andreas, Gnumeric does it already! Type =2/3 in a cell to see what it does. At least under Windows (I'm using gnumeric-1.9.0-win32-20080312.exe compiled by Jody) it automatically expands the column to fit the whole 14 decimals cases. I think that if you deliberately increase the number of decimals it's because you want them to be visible, so automatically increasing the column width is logical.
Pedro: If a column still has its default cell width than it is being adjusted. If its width has been modified (the case I was thinking of) it is not changed if you enter =2/3!
So , why not apply the same rule when increasing decimal cases? My point is that when you press the decrease or increase decimal cases it should modify what is displayed independently of the number of decimal cases saved.