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:
Error saving the document loprob:
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 126.96.36.199 (Build ID: da8c1e6) , and requested I report it upstream, which I've now done.
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 188.8.131.52 (as from repo)
Ubuntu 12.10 x64
About: Version 184.108.40.206 (Build ID: 360m1(Build:2))
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.
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).
(for clarification: this means the bug was already present at least as early as e.g. in beta releases of 3.5.0)
(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-220.127.116.11) on Ubuntu 14.04.
(Got same error as OP)
> Page Preview comes up with a blank gray background rather than a preview.
Changing version -> 3.3.0(.4) release
** 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 (5.0.4 or later) https://www.libreoffice.org/download/
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: 2016-01-17
I still see this behavior with LibreOffice 4.3.3 as packaged for Debian Jessie x64.
I am unable to test with 5.0.4 as that's not supported for Jessie, and attempting
to install from jessie-backports is far too disruptive on other critical packages
on my system to risk for this purpose. Pity there isn't just a tarball I could
run the 5.0.4 binaries out of for testing.
I still consider this to be a major problem for me.
I do not understand where is the problem: the bugdoc does not have print range defined but for Sheet10 which is empty. Removing this print range allows to generate a pdf with a page for each sheet. If we keep the defined print range, LO generates a pdf with only one empty page for Sheet10. For me it works as expected.
Tested with master and LO 18.104.22.168.0+, both built at home under Ubuntu 16.04 x86-64.
Closing as worksforme. Please, feel free to reopen if you disagree
(In reply to Jean-Baptiste Faure from comment #8)
> I do not understand where is the problem: the bugdoc does not have print
> range defined but for Sheet10 which is empty. Removing this print range
> allows to generate a pdf with a page for each sheet.
I'm not sure what the print range has to do with it. I have never
heard of the term until now and have never explicitly set a print range
on any document I've created (to my knowledge). So I don't understand why
some documents get a "print range" which is the useful set of cells I've
edited, and some don't get one at all, and why the Export As PDF
error dialog has nothing to do with the print range. ISTM if nothing
else, a meaningful error dialog could be generated. It doesn't sound as
if the actual problem has to do with "The file could not be written."
based on what you're describing here.
(In reply to devrel from comment #9)
> I'm not sure what the print range has to do with it.
That define the area of a sheet of a spreadsheet to be printed. Please read the doc.
Before reopening, did you try with the current stable and fresh versions ?
Best regards. JBF
I'd like to report that this bug is also/anymore in LibreOffice V22.214.171.124 Build ID 1:5.1.4-0ubuntu1 using calc.(On Ubuntu 16.04 LTS, latest update)
Have a spreadsheet (mine has 25 Sheets) use file -> export as PDF ->
select "page" -> type Nr.-> Export -> type filename, press Enter.
Error message [Error saving the document name: WriteError.The file could not be written ] (Yes, I have the rights to write for the folder, the spreadsheet will be saved in the same folder)
Sorry that I can't add the spreadsheet as it's content is confidental.
Ernst: check the print ranges. https://help.libreoffice.org/Calc/Edit_Print_Ranges
If someone wants to open a report about the error message, go ahead. This is already too long.