Bug 55966

Summary:	Calc can't print, export to PDF, or print preview
Product:	LibreOffice	Reporter:	devrel
Component:	Printing and PDF export	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	christopher.m.penalver, devrel, fdbugs, qubit
Version:	3.3.0 release
Hardware:	x86 (IA32)
OS:	All
See Also:	https://launchpad.net/bugs/1066423
Whiteboard:
i915 platform:		i915 features:
Attachments:	LibreOffice Calc spreadsheet demonstrating problems with print/page preview/export PDF Another example (from Impress)

Description devrel 2012-10-14 08:01:36 UTC

Created attachment 68549 [details]
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.

Comment 1 Stephan Zietsman 2013-02-08 09:18:48 UTC

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))

Comment 2 Rubem 2013-08-05 14:41:25 UTC

Created attachment 83667 [details]
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.

Comment 3 Björn Michaelsen 2014-05-27 13:42:41 UTC

Checking the original bug report (attachment 68549 [details]), 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).

Comment 4 Björn Michaelsen 2014-05-27 13:48:59 UTC

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

Comment 5 Robinson Tryon (qubit) 2014-11-06 00:17:38 UTC

(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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.