Bug 42614

Summary: Print preview / export as PDF not working on some documents
Product: LibreOffice Reporter: Török Edwin <edwin+bugs>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium    
Version: 3.4.3 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: buggy x.ods
working xok.ods
screenshot of non-working print preview
test case: preview works on sheet1 but fails on sheet2

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 
4ca392c-760cc4d-f39cf3d-1b2857e-60db978
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:

Version: 4.1.0.4
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

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.