Package: gnumeric Version: 1.10.17-1.1 Severity: important
Thank you very much for maintaining gnumeric.
If I ask you nicely, will you please see if you
can reproduce what seems to me to be a bug?
I'm a little tired, but I'll attach a small
spread sheet that shows what I'm worried about.
I'll also attach a screen shot of what it looks
like running on my computer.
The spread sheet has simple =if() formulas in two
cells.
They test whether two other cells are greater than
zero.
At least on my computer, one pair works, and the
other fails.
Specifically, I think cell E1 should say "T", much
like cell B1 does.
Unfortunately, I'm seeing "F".
I think this may be an important bug because it could
silently miscalculate.
When I edit the broken formula to refer to the
same zero holding cell as the working formula, it
starts working too.
I happened to notice that I'm unable to specify
the Sans font for the problematic "0" cell.
At least for me, selecting the problematic "0"
cell (D2), pressing ctrl-1 to format it, and
clicking on the "Font" tab shows no font was
selected.
When I tried to select "Sans", click on "OK" to
save it, close the formatting window and re-open
it by pressing ctrl-1 again, no font was selected.
Paradoxically, the font pull down menu toward the
upper left hand corner of gnumeric's main window
says the problematic "0" uses "Helvetica".
Jean at GimpNet's IRC channel #gnumeric wrote
"it would be more interesting to see if it's
still broken with HEAD"
I also filed bug #683228 at GNOME's Bugzilla.
Last, and maybe least, experimenting with copying
and centering the problematic "0" cell, and
pressing the F9 key to recompute, sometimes fixes
the problem.
So, that's what I think I know.
Thanks,
Kingsley
-- System Information:
Debian Release: wheezy/sid
APT prefers unstable
APT policy: (990, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 3.0.0-1-686-pae (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages gnumeric depends on:
ii debconf [de 1.5.41 Debian configuration management sy
ii gconf2 3.2.5-1 GNOME configuration database syste
ii gnumeric-co 1.10.17-1.1 spreadsheet application for GNOME
ii gsfonts 1:8.11+urwcyr1.0.7~pre44-4.2 Fonts for the Ghostscript interpre
ii libatk1.0-0 2.2.0-2 ATK accessibility toolkit
ii libc6 2.13-16 Embedded GNU C Library: Shared lib
ii libcairo2 1.10.2-6.1 The Cairo 2D vector graphics libra
ii libgdk-pixb 2.23.5-3 GDK Pixbuf library
ii libglib2.0- 2.32.1-1 GLib library of C routines
ii libgoffice- 0.8.17-1 Document centric objects library -
ii libgsf-1-11 1.14.21-1 Structured File Library - runtime
ii libgtk2.0-0 2.24.5-4 GTK+ graphical user interface libr
ii libpango1.0 1.29.4-2 Layout and rendering of internatio
ii libxml2 2.8.0+dfsg1-5 GNOME XML library
ii procps 1:3.2.8-11 /proc file system utilities
ii zlib1g 1:1.2.7.dfsg-13 compression library - runtime
Versions of packages gnumeric recommends:
ii evince 3.2.1-1 Document (PostScript, PDF) viewer
ii lp-solve 5.5.0.13-7 Solve (mixed integer) linear progr
Versions of packages gnumeric suggests:
pn epiphany-browser <none> (no description available)
ii gnumeric-doc 1.10.17-1 spreadsheet application for GNOME
pn gnumeric-plugins-extra <none> (no description available)
ii ttf-liberation 1.07.0-1 Fonts with the same metrics as Tim
-- debconf information:
* gnumeric/existing-process: true
gnumeric/existing-process-title:
bug.gnumeric
Description: GNU Zip compressed data
<<attachment: bug_screen_shot.png>>
