gnumeric doesn't do print preview or pdf printing

[Erwin Olario]

Binary package hint: gnumeric

Gnumeric is running from a clean install of 64-bit Ubuntu 9.10. I couldn't print preview my spreadsheets, nor could I generate them as PDF/PS/SVG files by printing.

No error messages are displayed. I didn't experience this in Ubuntu 9.04.

ProblemType: Bug
Architecture: amd64
Date: Mon Nov 9 09:07:01 2009
DistroRelease: Ubuntu 9.10
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release amd64 (20091027)
Package: gnumeric 1.9.9-1ubuntu2
ProcEnviron:
 LANG=en_PH.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-14.48-generic
SourcePackage: gnumeric
Uname: Linux 2.6.31-14-generic x86_64

[Jim Tarvid (tarvid)]

gnumeric and dependencies from Sid fixes this problem for me.

[Erwin Olario (gowin)]

Care to add details on how you went about to fixing it? How blood was it? ;-)

[Jim Tarvid (tarvid)]

Download the following packages from http://packages.debian.org/sid/amd64/ - make sure the architecture matches. Put in them in a directory by themselves

gnumeric_1.9.15-1_amd64.deb libgoffice-0-8-common_0.7.15-1_all.deb
gnumeric-common_1.9.15-1_all.deb libgsf-1-114_1.14.16-1_amd64.deb
gnumeric-doc_1.9.15-1_all.deb libgsf-1-common_1.14.16-1_all.deb
libgoffice-0-8_0.7.15-1_amd64.deb

sudo dpkg -i *

An hour or so.

[Charlie Kravetz (cjkgeek)]

Thank you for your bug report. This bug has been reported to the developers of the software. You can track it and make comments at: https://bugzilla.gnome.org/show_bug.cgi?id=533795

[Andreas J Guelzow (aguelzow)]

Regarding Charlie's comment: The upstream bug report https://bugzilla.gnome.org/show_bug.cgi?id=533795 is a MS Windows specific bug that has nothing to do with what you experience.

Note the error messages:
(gnumeric:4654): Gtk-WARNING **: no pages to print
(gnumeric:4849): Gtk-WARNING **: no pages to print
(gnumeric:4849): Gtk-WARNING **: no pages to print
(gnumeric:4849): Gtk-WARNING **: no pages to print
(gnumeric:4849): Gtk-WARNING **: no pages to print

so I would be wondering whether you have an invalid printarea set. Check "insert->names->define". To see the specification for the printarea.

In any case according to "Jim" this works fine in a recent version of Gnumeric.

(I am one of the upstream developers of Gnumeric.)

[Andreas J Guelzow (aguelzow)]

According to the NEWS file for 1.9.10:
Morten:
     Fix problem with print area.

[Charlie Kravetz (cjkgeek)]

Thank you, Andreas. I would expect to see this is fixed in lucid, then, which has gnumeric 1.9.17 now. It would help us greatly if you could test with it so we can work on getting it fixed in the next release of Ubuntu. You can find out more about the development release at http://www.ubuntu.com/testing/ . Thanks again and we appreciate your help.

[Charlie Kravetz (cjkgeek)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. However, I am closing it because the bug has been fixed in the latest development version of Ubuntu - Lucid Lynx. It won't be fixed in previous versions of Ubuntu because the package doesn't fit the requirements for backporting. See https://help.ubuntu.com/community/UbuntuBackports for more information.

[Wojciech Bober (wojciech-bober)]

The problem still persists in LucidLynx

[Wojciech Bober (wojciech-bober)]

The preview does not show up. I was successful, however, when running gumeric as super user. I have tried to change data directory, but it didn't help.

[Andreas J Guelzow (aguelzow)]

wojciech,

what is the content of your .gtkrc-2.0 and/or .gtkrc.mine files?

[Wojciech Bober (wojciech-bober)]

I don't have any of these. I've checked my ~ folder and did a system wide search.

[Andreas J Guelzow (aguelzow)]

Wojciech, can you create a print preview from evolution? Do you have evince installed? [The print preview in gnumeric is effectively handled by gtk, which uses evince. This is the same setup as in evolution (and most likely any other recent gtk application.)

[Wojciech Bober (wojciech-bober)]

Yes I can do a print preview from evolution and I have evince installed. As I mentioned before, the problem does not show up when I run gnumeric as super user i.e. sudo gnumeric

[Andreas J Guelzow (aguelzow)]

The xsession error file above contains
"(gnumeric:4849): Gtk-WARNING **: no pages to print"
this usually means that the intersection of sheet content and printarea is empty.

Wojciech, assuming that you are using the same file for trying to preview as root and as you, this should be some sort of permission issue instead. DO you get any messages when you start gnumeric in a terminal window and try to preview?

[Wojciech Bober (wojciech-bober)]

Nothing. Is there a way to turn on same sort of verbose output?

[Bruce Miller (brm0423)]

I am experiencing this bug as well when I try to print. As it happens, I had started gnumeric from a command line:

I was careful within Gnumeric to set a print area.

bruce@Xenophon:~/PDF$ gnumeric ~/Documents/fin/erik-2010.gnumeric &
[1] 6576
bruce@Xenophon:~/PDF$
(gnumeric:6576): Gtk-WARNING **: no pages to print

(gnumeric:6576): Gtk-WARNING **: no pages to print

(gnumeric:6576): Gtk-WARNING **: no pages to print

(gnumeric:6576): Gtk-WARNING **: no pages to print

(gnumeric:6576): Gtk-WARNING **: no pages to print

(gnumeric:6576): Gtk-WARNING **: no pages to print

(gnumeric:6576): Gtk-WARNING **: no pages to print

(gnumeric:6576): Gtk-WARNING **: no pages to print

[1]+ Done gnumeric ~/Documents/fin/erik-2010.gnumeric
bruce@Xenophon:~/PDF$

[Andreas J Guelzow (aguelzow)]

Bruce, does this happen with every file? (I am unable to replicate in ubuntu 10.4 even trying to make no pages print.)

[Charlie Kravetz (cjkgeek)]

We'd like to figure out what's causing this bug for you, but we haven't heard back from you in a while. Could you please provide the requested information? Thanks!

[Erwin Olario (gowin)]

I'm still experiencing the same problem in 64-bit Lucid Lynx. Couldn't preview spreadsheets, no error messages.

Starting gnumeric from the command line I got the following:
** (gnumeric:3904): WARNING **: Unknown namespace uri = 'http://www.w3.org/2003/g/data-view#'

** (gnumeric:3904): WARNING **: Unknown namespace uri = 'http://www.w3.org/1999/xhtml'

** (gnumeric:3904): WARNING **: Unknown namespace uri = 'http://www.w3.org/2003/g/data-view#'

** (gnumeric:3904): WARNING **: Unknown namespace uri = 'http://openoffice.org/2009/table'

** (gnumeric:3904): WARNING **: Unknown namespace uri = 'http://www.w3.org/1999/xhtml'

** (gnumeric:3904): WARNING **: Unknown namespace uri = 'http://www.w3.org/2003/g/data-view#'

** (gnumeric:3904): WARNING **: Unknown namespace uri = 'http://openoffice.org/2009/table'

(gnumeric:3904): Gtk-WARNING **: no pages to print

[Bruce Miller (brm0423)]

Problem persists in fully updated maverick beta 64-bit.

bruce@Xenophon:~$ gnumeric Documents/fin/erik-2010.gnumeric

(gnumeric:20890): Gtk-WARNING **: no pages to print

(gnumeric:20890): Gtk-WARNING **: no pages to print

(gnumeric:20890): Gtk-WARNING **: no pages to print
bruce@Xenophon:~$ uname -a
Linux Xenophon 2.6.35-22-generic #33-Ubuntu SMP Sun Sep 19 20:32:27 UTC 2010
x86_64 GNU/Linux
bruce@Xenophon:~$ dpkg -l gnumeric
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version
         Description
+++-==========================================-==========================================-====================================================================================================

ii gnumeric 1.10.8-1ubuntu1
         spreadsheet application for GNOME - main program
bruce@Xenophon:~$

[Bruce Miller (brm0423)]

Tried print preview and print with two other Gnumeric spreadsheets, using 64-bit maverick.

Problem remains as described above

[Andreas J Guelzow (aguelzow)]

Bruce, would you be able to attach screenshots of the first 3 tabs of the print dialog and the first and last tab of the pagesetup dialog for a failing attempt to print?

Thanks

[Charlie Kravetz (cjkgeek)]

We'd like to figure out what's causing this bug for you, but we haven't heard back from you in a while. Could you please provide the requested information?
Thanks!

[Charlie Kravetz (cjkgeek)]

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!