[Upstream] Calc can't print, export to PDF, or print preview

[oddhack]

1) lsb_release -rd
Description: Ubuntu 12.10
Release: 12.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.6.2~rc2-0ubuntu3
  Candidate: 1:3.6.2~rc2-0ubuntu3
  Version table:
 *** 1:3.6.2~rc2-0ubuntu3 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages
        100 /var/lib/dpkg/status

3) What is expected to happen in Calc via a terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1066423/+attachment/3397788/+files/loprob.ods && localc --nologo loprob.ods

Export to PDF, Print Preview, or print and it does so.

4) What happens when you:

+ Export to PDF is one gets a pop up noting:
LibreOffice 3.6
Error saving the document loprob:
Write Error.
The file could not be written.

+ Page Preview it comes up with a blank gray background rather than a preview.

Original Report Comments:
+ print Nothing was printed, but libreoffice displayed the string 'gtk printer' on the xterm console from which it was invoked, and left a directory and file '/tmp/luppt6wq.tmp/luppt6ws.tmp' behind. The .tmp file is an exact copy of the .ods spreadsheet with which LO was invoked.
The CUPS printer manager and logs in /var/log/cups do not show a job corresponding to my attempt to print and I have no problem printing via other apps such as Firefox. I do not believe this is a CUPS issue.

The behavior is highly sensitive to the contents of the spreadsheet. I have attached the offending document and it repeatably demonstrates the print/page preview problem described. However, if the final sheet ("Sheet10") of the document is deleted, the problem goes away and print/page preview function properly once again.

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice-calc 1:3.5.4-0ubuntu1.1
ProcVersionSignature: Ubuntu 3.2.0-32.51-generic-pae 3.2.30
Uname: Linux 3.2.0-32-generic-pae i686
ApportVersion: 2.0.1-0ubuntu14
Architecture: i386
Date: Sat Oct 13 17:51:40 2012
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release i386 (20120423)
ProcEnviron:
 TERM=xterm
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/tcsh
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

[penalvch (penalvch)]

oddhack, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions verbatim at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance.

Marking Triaged. As well, problem reproducible in Windows Vista 32x, LO 3.6.2.2 (Build ID: da8c1e6) .

[oddhack (developer-oddhack)]

Created attachment 68549
LibreOffice Calc spreadsheet demonstrating problems with print/page preview/export PDF

What is expected to happen: starting libreoffice with the attached spreadsheet from an xterm (libreoffice loprob.ods) will successfully print, page preview, and export to PDF.

What happens when you:

Export to PDF generates a popup error:
LibreOffice 3.6
Error saving the document loprob:
Write Error.
The file could not be written.

Page Preview comes up with a blank gray background rather than a preview.

Print nothing is printed, but the string "gtk printer" is shown on the invoking xterm console and a file is left behind in a temporary directory named something like "/tmp/luq5npeh.tmp/luq5npej.tmp". The .tmp file is an exact copy of the input file.

The behavior is highly sensitive to the contents of the spreadsheet. I have attached the offending document and it repeatably demonstrates the print/page preview problem described. However, if the final sheet ("Sheet10") of the document is deleted, the problem goes away and print/page preview function properly once again.

The problem was initially found by me in LO 3.5.4 on Ubuntu 12.04 and reported in launchpad at https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1066423 . The Ubuntu team then triaged it as reproducible on LO 3.6.2~rc2 under Ubuntu 12.10 as well as on Windows Vista 32x, LO 3.6.2.2 (Build ID: da8c1e6) , and requested I report it upstream, which I've now done.

[oddhack (developer-oddhack)]

I have reported this upstream at

https://bugs.freedesktop.org/show_bug.cgi?id=55966

Thanks for the quick triage!

[Sziets (sziets)]

I almost filed a report on PDF export which would certainly be marked as a duplicate. I also had trouble exporting to PDF from calc (the other components seem to be unaffected).

An error occurs when attempting to export a spreadsheet as PDF.

--== Steps to reproduce ==--

Create new spreadsheet (File -> New -> Spreadsheet)
Enter some text (E.g. 'Hello world')
Export as PDF (File -> export as PDF... -> Export -> Enter filename 'TestCalc' -> Save)

Expected behaviour: TestCalc.pdf is created.
Actual behaviour: Error saving the document Untitled1: Write Error. The file could not be written.

--== End of reproduction ==--

I followed the steps above a few times with consitent errors. However, when I closed and reopened LO, it exported correctly and did not give errors. It appears to be inconsistent; not sure what caused it. I did play around with exporting pdf with embedded OpenDocument (mainly in writer) before the error, if that helps.

--
Running LibreOffice 3.6.2.2 (as from repo)
Ubuntu 12.10 x64
About: Version 3.6.2.2 (Build ID: 360m1(Build:2))

[cuichi (lucas-we)]

For me that only happens if I have the LibreOffice Window on an external screen. Placing it on the built in screen of my laptop recovers the functions. Could that be related?

[oddhack (developer-oddhack)]

cuichi - I originally found the problem on a single-screen desktop system so can't
check on then behavior you see.

Unfortunately the upstream bug has had no attention from the LO developers since
submission in October. I don't know if there's a way to bump something so it appears
on the radar of whomever does triaging there?

[Pechansky (pechansky)]

Created attachment 83667
Another example (from Impress)

With the attached file, selecting one or both pages and setting 'Range' to 'Selection' in the PDF Export page generates the error. Exporting all pages, or filling out the Pages field, does not seem to generate any errors.

[Björn Michaelsen (bjoern-michaelsen)]

Checking the original bug report (attachment 68549), this already fails in the oldest version in bibisect (source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932). If this ever worked, please name the last known version working correctly and mark this as a regression.

Also checked to still fail on LibreOffice 4.3.0~beta1 (source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e).

[Björn Michaelsen (bjoern-michaelsen)]

Original report suggested this to be a possible regression-update from LibreOffice 3.5.4 upstream bibisecting rejects this: https://bugs.freedesktop.org/show_bug.cgi?id=55966#c3

_If_ this is a regression-release, it was triggered by an update in one of LibreOffices dependencies, but not LibreOffice itself.

[Björn Michaelsen (bjoern-michaelsen)]

(for clarification: this means the bug was already present at least as early as e.g. in beta releases of 3.5.0)

[Qubit (qubit)]

(In reply to devrel from comment #0)
> Created attachment 68549 [details]
>
> What is expected to happen: starting libreoffice with the attached
> spreadsheet from an xterm (libreoffice loprob.ods) will successfully print,
> page preview, and export to PDF.
>
> What happens when you:
>
> Export to PDF generates a popup error:

CONFIRMED with LibreOffice 3.3.0 (OOO330m19 (Build:6) tag libreoffice-3.3.0.4) on Ubuntu 14.04.

(Got same error as OP)

> Page Preview comes up with a blank gray background rather than a preview.
>

Confirmed

Changing version -> 3.3.0(.4) release

[Dariusz Cieślak (dcieslak)]

I've just encountered the same issue. It was not possible to print single spreadsheet tab to PDF.

I have fixed it by defining print range properly (select cells / Format / Print Range / Set).

[penalvch (penalvch)]

oddhack, 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.

This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please perform as much as possible of the SRU Procedure [1] to bring the need to a developer's attention.

[1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure