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 555519 - Formula bar show formatted input instead of raw input
Formula bar show formatted input instead of raw input
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: GUI
git master
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
: 577866 670550 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2008-10-08 10:11 UTC by Reggie Chan
Modified: 2012-02-22 01:08 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Reggie Chan 2008-10-08 10:11:17 UTC 
IMPORTANT: step 1 and step 2 cannot be swapped, format must be set before keying in value in order to reproduce the bug.

Steps to reproduce:
1. Change A1's number format to Number | 0 decimal places.
2. Key in "123.45" in A1.
3. Focus cursor at A1.

Expected result:

A1 displays "123", but formula bar shows "123.45".

Actual result:

A1 displays "123" and formula bar displays "123".

It looks like the problem is related to the cell->value's value_fmt.
A1's value_fmt = 0 in the reproduce procedure.
If we swap step 1 and step 2, value_fmt = NULL.
Comment 1 Andreas J. Guelzow 2008-10-08 12:56:39 UTC 
The cell contains "123.45" not "123". I would want the formula bar to show the true value.

Could you explain why you would want the formula bar to show a value other than the one you would need to edit if yo were going to change that value?
Comment 2 Morten Welinder 2008-10-08 15:01:40 UTC 
What you have as "expect result" is what I actually see.
In other words, I see "123.45" in the edit bar.  This is also what
I expect to see.

Could you please confirm that "actual results" in comment 1?
Comment 3 Morten Welinder 2008-10-08 15:30:47 UTC 
Hmm...  I see you actual results too in some cases.

specifically, it matter whether the cell is pre-formatted to zero
decimals or whether the format is added later.
Comment 4 Andreas J. Guelzow 2008-10-08 16:05:00 UTC 
I guess I should learn to read. I mixed up your expected and actual. I am of course agreeing with what you expect.
Comment 5 Andreas J. Guelzow 2009-10-08 16:55:22 UTC 
*** Bug 577866 has been marked as a duplicate of this bug. ***
Comment 6 Andreas J. Guelzow 2012-02-21 17:19:12 UTC 
*** Bug 670550 has been marked as a duplicate of this bug. ***
Comment 7 Andreas J. Guelzow 2012-02-22 01:08:53 UTC 
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.