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 127410 - bad number of decimals shown in this .xls file
bad number of decimals shown in this .xls file
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.2.x
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2003-11-19 17:24 UTC by Frederic Parrenin
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
The .xls file showing the problem (13.50 KB, application/msexcel)
2003-11-19 17:25 UTC, Frederic Parrenin
Details
Look at the second column. There is maximum two digits. (47.22 KB, image/png)
2003-11-20 15:20 UTC, Frederic Parrenin
Details

Description Frederic Parrenin 2003-11-19 17:24:58 UTC
In the file I will attach, in the second column, there are two decimals
shown in XL2k but three in gnumeric.
Comment 1 Frederic Parrenin 2003-11-19 17:25:39 UTC
Created attachment 21628 [details]
The .xls file showing the problem
Comment 2 Frederic Parrenin 2003-11-19 17:27:46 UTC
Sorry, it was in fact the contrary: two decimals in gnumeric and three
in XL2k.
Comment 3 Morten Welinder 2003-11-20 14:34:02 UTC
What cell(s) are you talking about?  In gnumeric, I see three decimals
in for example B11, not in B4 and five in A5.
Comment 4 Morten Welinder 2003-11-20 14:36:05 UTC
...and it looks exactly the same in excel for me.
Comment 5 Frederic Parrenin 2003-11-20 15:14:38 UTC
Gnumeric shows maximum two digits for me.
See the screenshot.
Comment 6 Frederic Parrenin 2003-11-20 15:20:43 UTC
Created attachment 21654 [details]
Look at the second column. There is maximum two digits.
Comment 7 Frederic Parrenin 2003-11-20 15:31:49 UTC
I just want to see where the problem comes from. If you expand column
B, the third digit appears.
It looks strange for me, because there seems to be enough place to
show this third digit.
I realize it also comes from the fact that I don't have the Geneva
font installed on my system. Thus, gnumeric uses "Sans" instead.
Comment 8 Jody Goldberg 2003-12-22 18:45:47 UTC
We were being a bit too pesimistic in our width calculations.  Patched
in CVS.  I won't say fixed, but it is patched.  The real solution is
to get the real font info down into the format engine.