When I edit a spreadsheet in gnumeric, the cells will look like they are wide enough for the text that they hold. When I print preview or print, however, the text is wider than the cell and part gets cut off. I've tried this with the default sans font as well as others (Nimbus Roman No9 L, Bitstream Vera Sans, URW Palladio L), and the cell size is consistently wrong. If I change to a larger size font and auto-size the row height (with a double-click), that also comes out wrong: the row is shorter than the font height when previewing or printing. Reproducible: Always Steps to Reproduce: 1. create a spreadsheet, put text in the cells 2. use double-click to auto-size the width of the cells, or size by hand 3. print or print preview Actual Results: The text in each cell is truncated. The cells with more text are wider than the cells with less text, but each column is too narrow for its contents. Expected Results: The relationship between cell contents and cell size in editing mode should be the same as in print/print preview. If editing shows a cell or column as wide enough for its contents, the printed cell should include the whole contents. I initially ran into this problem with gnumeric 1.2.6. Last night I emerged gnumeric with ACCEPT_KEYWORDS="~x86", so I now have 1.2.12, and the problem persists. granite# emerge info gnumeric Portage 2.0.50-r6 (default-x86-2004.0, gcc-3.3.2, glibc-2.3.2-r9, 2.4.25-gentoo-r1) ================================================================= System uname: 2.4.25-gentoo-r1 i686 Intel(R) Pentium(R) 4 CPU 1.80GHz Gentoo Base System version 1.4.10 Autoconf: sys-devel/autoconf-2.58-r1 Automake: sys-devel/automake-1.8.3 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CFLAGS="-O2 -march=pentium4 -fomit-frame-pointer -pipe" CHOST="i686-pc-linux-gnu" COMPILER="gcc3" CONFIG_PROTECT="/etc /usr/X11R6/lib/X11/xkb /usr/kde/2/share/config /usr/kde/3.2/share/config /usr/kde/3/share/config /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/ /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-O2 -march=pentium4 -fomit-frame-pointer -pipe" DISFEATURES="autoaddcvs ccache sandbox" GENTOO_MIRRORS="http://gentoo.ccccom.com http://gentoo.binarycompass.org ftp://gentoo.ccccom.com http://mirror.datapipe.net/gentoo" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="" SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage" USE="X alsa apm arts avi berkdb cdr crypt cups encode esd foomaticdb gdbm gif gnome gtk gtk2 imagemagick imap imlib java jpeg kde ldap libg++ libwww mad mikmod motif mpeg ncurses nls oci8 oggvorbis opengl oss pam pdflib perl png python qt quicktime readline sdl slang smms spell ssl svga tcltk tcpd tetex truetype usb x86 xml2 xmms xv zlib" TDIR="/usr/portage/distfiles" granite# ACCEPT_KEYWORDS="~x86" equery uses =app-office/gnumeric-1.2.12 [ Colour Code : set unset ] [ Legend : (U) Col 1 - Current USE flags ] [ : (I) Col 2 - Installed With USE flags ] U I [ Found these USE variables in : app-office/gnumeric-1.2.12 ] - - libgda : Adds GNU Data Access (CORBA wrapper) support for gnumeric + + python : Adds support/bindings for the Python language - - bonobo : Adds support for gnome-base/bonobo (Gnome CORBA interfaces)
probably upstream.. we should try & reproduce and move it up.
I've got another system with Fedora Core 2 and gnumeric 1.2.8, and it doesn't have this problem, for what it's worth.
This is a well known gnumeric bug, see http://bugzilla.gnome.org/show_bug.cgi?id=62210 . The issue depends on the exact fonts used and how they scale for larger resolutions.
I wonder if changing the DPI settings in File: Preferences: Various: Internal will help you? Perhaps your system is not using 75 DPI. I have no idea why Gnumeric does not pull DPI information from the display itself.
Following the link in comment 3, this has been fixed upstream. http://bugzilla.gnome.org/show_bug.cgi?id=152939
