Calc wants to print wrong document and exits with unsaved changes to the document

[Thomas Mayer]

How to reproduce:

- open testcase.odt writer document
- open testcase.odt calc document
- Press STRG+P in calc
=> Result: Writer document is shown in printing preview
- Press OK
=> Result:
===> Using 1:5.0.3~rc2-0ubuntu1~trusty2 from ppa, the writer document is printed
===> Using 1:4.2.8-0ubuntu3 from trusty-updates, there comes an error box with no text. When pressed ok, no document is printed and all libreoffice windows are closed with no chance to save changes to the documents. Any changes to the documents are lost.

[Thomas Mayer (thomas303)]

This is a screenshot taken from 1:5.0.3~rc2-0ubuntu1~trusty2. What you can see is that when printing in calc, the text from writer is shown in the preview while being different from the document in calc.

This is pretty much the same in 1:4.2.8-0ubuntu3.

The behaviour is reproducable, meaning it occurs every time I try it.

[Thomas Mayer (thomas303)]

The problem can be worked around by not opening testcase.odt. However, if the user accidently does not apply this workaround, he or she is faced with the problem as soon as he or she presses STRG+P (or uses the printing dialog from the menu).

As already mentioned, I was faced with data loss in libreoffice 1:4.2.8-0ubuntu3 concerning unsaved changes in ALL opened libreoffice documents. This version of libreoffice is supported by ubuntu trusty which is why this issue should get some sort of priority.

[Thomas-mayer (thomas-mayer)]

Created attachment 121992
testcase.odt, testcase.ods, screenshot

Affected versions: at least
- 1:4.2.8-0ubuntu3 from trusty-updates
- 1:5.0.3~rc2-0ubuntu1~trusty2 from ppa
- I did not test against other distros/OSes and LO versions. Maybe this issue is older and also affects more distros/OSes than just ubuntu.

How to reproduce:

- open testcase.odt writer document (file is attached)
- open testcase.odt calc document (file is attached)
- Press STRG+P in calc
=> Result: Writer document is shown in printing preview
- Press OK
=> Result:
===> Using 1:5.0.3~rc2-0ubuntu1~trusty2 from ppa, the writer document is printed
===> Using 1:4.2.8-0ubuntu3 from trusty-updates, there an error box with no text occurs. When pressed OK, no document is printed and all libreoffice windows are closed with no chance to save changes to the documents. Any changes to the documents are lost.

The behaviour is reproducable, meaning it occurs every time I try it out.

Severity is critical because users potentially loose data in the form of unsaved changes.

Suggested fix:
- LO should print the active document (which has the focus/active window).
- LO should not crash and loose unsaved changes of all opened LO documents.

Additional information:
- testcase.odt and testcase.ods are attached (both of them were originally created using libreoffice 4.2).
- attached is also a screenshot which obviously should never occur (applies to both 4.2 and 5.0)
- Launchpad bug report available at https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1534927

[Thomas-mayer (thomas-mayer)]

Tried to reproduce this issue with a fresh install of ubuntu 15.10 (in KVM):

- Performed all updates available via apt-get (this is pretty much the only thing I was doing)
- Libreoffice version is 5.0.2.2, build-id 00m0 (from repository)

Result: Cannot reproduce this issue in ubuntu 15.10. I also tried
- Unity Desktop with LO Quickstarter disabled (default)
- Unity Desktop with LO Quickstarter enabled
- Gnome Flashback with LO Quickstarter enabled
- Gnome Flashback with LO Quickstarter disabled

[Thomas-mayer (thomas-mayer)]

Same applies for ubuntu 15.10 using LO 5.0.3.2 build 1:5.0.3~rc2-0ubuntu1:

Cannot reproduce this issue with ubuntu 15.10 and LO 5.0.3.2

[Thomas-mayer (thomas-mayer)]

Tried to reproduce this issue with a clean install of ubuntu 14.04:

- Installed ubuntu desktop 14.04.1 from original media (in KVM machine)
- update (via apt-get update && apt-get upgrade && apt-get dist-upgrade
- reboot
- install same printer (as used in all previous attemps: Kyocera FS-1020d)
- open testcase.odt
- open testcase.ods and press STRG+P => Printing dialog shows up the preview of the calc document which is the wanted behaviour.

=> Can't reproduce this issue using a fresh and up-to-date install of ubuntu 14.04 (Kernel 3.13.0-74), which comes along with LO 4.2.8.2, Build-ID 420m0(Build:2)

[Thomas-mayer (thomas-mayer)]

I further tracked it down to see why the system which has the problem differs from the behaviour of a fresh install.

And I found the difference: I had a third party LO extension installed: LibreOffice E-Porto 1.0.3 from https://www.deutschepost.de/de/i/internetmarke-porto-drucken/e-porto-add-in.html#downloads .

After disabling the extension in LO, this issue was fixed: Now I can print testcase.ods even when testcase.odt is already open.

I assume the bug is in the E-Porto plugin, at least this should be very likely.

So there is no bug in LO or in ubuntu, the bug seems to be in the extension. Issue can be closed then.

[Thomas Mayer (thomas303)]

I further tracked it down to see why the system which has the problem differs from the behaviour of a fresh install.

And I found the difference: I had a third party LO extension installed: LibreOffice E-Porto 1.0.3 from https://www.deutschepost.de/de/i/internetmarke-porto-drucken/e-porto-add-in.html#downloads .

After disabling the extension in LO, this issue was fixed: Now I can print testcase.ods even when testcase.odt is already open.

I assume the bug is in the E-Porto plugin, at least this should be very likely.

So there is no bug in LO or in ubuntu packages, the bug seems to be in the extension. Issue can be closed then.

[Cno (cno)]

Thanks for reporting back, Thomas!