Bug 19612 – Can't change the precision after the dot in numbers in gnumeric-1.0.12

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Eric 2003-04-19 09:43:14 UTC]

Can't change the precision after the dot in numbers in gnumeric-1.0.12, it
diplay strange things like letters or symbols.

Reproducible: Always
Steps to Reproduce:
1.Enter a number with a dot in a cell exemple : 1.234
2. Try to decrease de the precision after the dot Format---> cells---->choose
the "number" tab and change it there to 2


Actual Results:  
The cell now display : "0,<3"

Expected Results:  
The cell should display "1.23"

I have try to emerge version 1.0.13 and the same thing appens.

My system is up to date in the stable gentoo.
My languge is set to fr_FR by gnome.....and the same problem occur when i choose
english language.

[Comment 1 Alastair Tse (RETIRED) 2003-04-21 15:17:20 UTC]

For me, if I start gnumeric-1.0.12 using :

LANG="fr_FR" gnumeric

it doesn't even convert 1.234 to 1.23. But it doesn't create that weird output. On the other hand:

LANG="en_GB" gnumeric

works as expected. This also doesn't work on 1.1.16. I've forwarded this upstream to see what the Gnumeric guys think.

http://bugzilla.gnome.org/show_bug.cgi?id=111294

[Comment 2 Alastair Tse (RETIRED) 2003-04-21 18:11:21 UTC]

well, apparently i forgot that in france, people use "," for decimal point rather than a "." :/

with that said, i can't reproduce the problem with displaying strange symbols. are you using UTF-8 or some unicode variant? as far as I know, gtk+1's gnumeric doesn't handle UTF-8 very well.

[Comment 3 Alastair Tse (RETIRED) 2003-05-25 06:58:32 UTC]

can't really go any further without more info from the bug reporter .. 

[Comment 4 Eric 2003-05-25 09:22:23 UTC]

I found on the french forum someone having the same problem than me the topic is here but in french :
http://forums.gentoo.org/viewtopic.php?t=31211

I still have the same problem and it do the same with the gtk2 version. Gnumeric was working well before on my computer and i change nothing exept emerge the version 1.0.12. Now any version won' t work. 

For the font that i use, all the fonts are the one from sytstem default exept that i had add some windows fonts in a directory. 

what other information do you need ?

[Comment 5 Eric 2003-05-25 09:38:23 UTC]

here is a screenshot of the problem : http://www.multimania.com/eddrick/gnumeric.png.

Tha cell B1 do : A1/2 and give a good result even if the number is very strange. But if i print or save this file in text file, it print 0;;2 (it should print or display 1,123)

[Comment 6 Alastair Tse (RETIRED) 2003-05-25 13:48:02 UTC]

have you reported this to bugzilla.gnome.org ?

and you also paste the output of "emerge info"?

[Comment 7 Eric 2003-05-25 19:35:54 UTC]

I will report the bug on gnome.org

here is the "emerge info" of my system :

Portage 2.0.48 (default-x86-1.4, gcc-3.2.2, glibc-2.3.1-r4)
=================================================================
System uname: 2.4.20-gentoo-r2 i686 Intel(R) Pentium(R) 4 CPU 2.00GHz
GENTOO_MIRRORS="http://gentoo.oregonstate.edu http://distro.ibiblio.org/pub/Linux/distributions/gentoo"
CONFIG_PROTECT="/etc /var/qmail/control /usr/share/config /usr/kde/2/share/config /usr/X11R6/lib/X11/xkb /usr/kde/3/share/config"
CONFIG_PROTECT_MASK="/etc/gconf /etc/env.d"
PORTDIR="/usr/portage"
DISTDIR="/usr/portage/distfiles"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR_OVERLAY=""
USE="x86 oss 3dnow apm avi crypt cups encode gif jpeg libg++ mikmod mmx mpeg ncurses nls pdflib png quicktime spell truetype xml2 xmms xv zlib gdbm berkdb slang readline arts tetex svga java guile X sdl gpm tcpd pam libwww ssl perl python esd imlib oggvorbis gnome gtk qt kde motif opengl mozilla cdr scanner sse sse2 dvd"
COMPILER="gcc3"
CHOST="i686-pc-linux-gnu"
CFLAGS="-march=pentium4 -O3 -pipe -fomit-frame-pointer"
CXXFLAGS="-march=pentium4 -O3 -pipe -fomit-frame-pointer"
ACCEPT_KEYWORDS="x86"
MAKEOPTS="-j2"
AUTOCLEAN="yes"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
FEATURES="sandbox ccache"

[Comment 8 Alastair Tse (RETIRED) 2003-05-26 05:27:12 UTC]

-march=pentium4 may cause problems with gcc-3.2.2. there's a big message about it in /etc/make.conf. please try recompiling gnumeric with -march=pentium3.

[Comment 9 foser (RETIRED) 2003-06-08 10:23:07 UTC]

i can't reproduce this problem, reporter have you already filed this bug upstream ? if so please provide us with a link to the correct bug.

[Comment 10 Eric 2003-06-23 18:34:05 UTC]

The problem i till unresolved. I have intalled version 1.1.19 and i got the same problem. I have open a bug on gnome.org : http://bugzilla.gnome.org/show_bug.cgi?id=115830

[Comment 11 Andreas 2003-06-24 21:45:29 UTC]

We (the gnumeric developers) believe that this bug is due to libcups incorrrect handling of locales. We have worked around that problem for gnumeric .1.20 to be released soon. If hte problem reoccurs with that version, or on systems not running cups as a printing system please reopen or refile this bug at bugzilla.gnome.org.

Thank you

[Comment 12 foser (RETIRED) 2003-09-14 13:54:51 UTC]

1.1.20 and 1.1.90 have been in portage for a while, those should hopefully solve this problem.

reopen if needed.