Bug 42614 - Print preview / export as PDF not working on some documents
Summary: Print preview / export as PDF not working on some documents
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.3 release
Hardware: Other All
: medium major
Assignee: Not Assigned
Depends on:
Reported: 2011-11-05 01:40 UTC by Török Edwin
Modified: 2015-04-23 19:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

buggy x.ods (9.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-11-05 01:40 UTC, Török Edwin
working xok.ods (7.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-11-05 01:40 UTC, Török Edwin
screenshot of non-working print preview (56.18 KB, image/png)
2011-11-05 01:42 UTC, Török Edwin
test case: preview works on sheet1 but fails on sheet2 (8.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-09-18 21:35 UTC, Thiemo Nagel

Note You need to log in before you can comment on or make changes to this bug.
Description Török Edwin 2011-11-05 01:40:14 UTC
Created attachment 53168 [details]
buggy x.ods

A spreadsheet was created on Ubuntu 11.10 with Libreoffice-Calc 3.4.3, with locale set to HU. At first it was possible to print preview the document.
Then several changes were made to the document and now print preview shows nothing
(see attached screenshot).

I copied the document to Debian unstable, and print preview doesn't work there either. If I delete everything on the worksheet, and enter just the word "test",
then print preview is still not working.

Of course if I create a new document, and enter "test" then print preview _is_ working. 
Also if I copy all the data from the original document and paste it in a new one, then print preview is working there.

Attached are two files:
 - x.ods which is the original document, with everything deleted and replaced with the word 'test', print preview not working here
 - xok.ods, which is a new document with the same word 'test' in it

I guess some setting was changed in x.ods that is causing this behaviour, but I couldn't figure out what.

The same issue that happens with print preview also happens with export to PDF on x.ods: "Error saving document x: Write Error. The file could not be written".
There is plenty of space on the drive, and exporting xok.ods works.
Comment 1 Török Edwin 2011-11-05 01:40:38 UTC
Created attachment 53169 [details]
working xok.ods
Comment 2 Török Edwin 2011-11-05 01:41:11 UTC
Another workaround to get print preview working: save x.ods as Excel (.xls), 
and print preview works then. But I don't want to use .xls format to store my documents, I'd much prefer to use .ods.
Comment 3 Török Edwin 2011-11-05 01:42:39 UTC
Created attachment 53170 [details]
screenshot of non-working print preview

Just a grey area, it doesn't show the page at all!
Comment 4 rgdavis-tx 2011-11-30 10:19:01 UTC
I have run into this before.  I have seen this way back in OO 2.x if I remember correctly.  The print ranges on all but the last tab are getting set to none.  You can select the sheet tab and reset the print range (Format->Print Ranges->Edit) or the save to excel and resave to ods work also.  Don't know what causes it but it always happens when I have more sheet tabs.
Comment 5 tester8 2012-01-05 15:22:23 UTC
Reproduced with

LOdev 3.5.0beta2 
Ubuntu 10.04.3 x86
Linux 2.6.32-37-generic Russian UI
Comment 6 tommaso massimi 2012-01-30 01:51:40 UTC
I have also this problem, 
Libreoffice 3.4.3 running on windows.

There is some test I can do to help the bugfixing?
Comment 7 Connie 2012-03-01 05:17:19 UTC
Confirm this bug.
Libreoffice 3.5.0rc3
windows xp sp2
Comment 8 Roman Eisele 2012-05-03 09:28:53 UTC
This is a Calc issue, therefore changed 'Component' field accordingly. Therefore we can abbreviate the Summary a little bit.

Changed Version field back to 3.4.3, according to original description. Please note that the Version field should contain the FIRST version in which the problem is known to exist and NOT the last one!

Increased the importance a little bit.
Comment 9 Thiemo Nagel 2013-09-18 21:34:03 UTC
I can confirm this for the latest wheezy-backports build:

Build ID: 410m0(Build:4)

I'm attaching another testcase...
Comment 10 Thiemo Nagel 2013-09-18 21:35:25 UTC
Created attachment 86110 [details]
test case: preview works on sheet1 but fails on sheet2
Comment 11 QA Administrators 2015-04-01 14:41:41 UTC
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

   *Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later)

   *If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
   *If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

   *Update the version field
   *Reply via email (please reply directly on the bug tracker)
   *Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 

1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)


2. Test your bug 
3. Leave a comment with your results. 
4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 
4b. If the bug was not present in 3.3 - add "regression" to keyword

Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2015-04-01
Comment 12 Buovjaga 2015-04-23 19:08:18 UTC
Confirmed with the test cases, but after I cleared the print ranges, saved & reopened, created several more sheets with content, saved & reopened - the problem did not appear.
Thus I'm setting to WFM and if you guys still have this with the latest version, you can set back to NEW.

Win 7 Pro 64-bit Version: (x64)
Build ID: f3375fa07f27bd2ade519af3c07d69040d10eaa9
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-04-22_23:38:50
Locale: fi_FI