[Libreoffice-bugs] [Bug 42673] With disconnected network printers, Calc hangs opening some files waiting on the Windows print spooler

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=42673

szz <gstr1234 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gstr1234 at gmail.com

--- Comment #17 from szz <gstr1234 at gmail.com> ---
I could fix an ods whcih hangs when network printer was unavailable.
There is a section in ods (renamed to zip and extract settings.xml file from
it) where the printer related option stored.

My netowork printer adreess was:  \\192.168.1.11\lp

If I delete printer related data section from settings.xml ods file opens like
a charm even the network printer is unavailable :)

So delete XML data tags: PrinterName and PrinterSetup (whole xml data tags)
(of course make a backup from ods 1st)

<config:config-item config:name="PrinterName"
config:type="string">\\192.168.1.11\lp</config:config-item><config:config-item
config:name="PrinterSetup"
config:type="base64Binary">ZQX+/1cvfgsdhdfzjdtzjdtzjdtzjfzhukgijhlAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAbbbbbbbbbbbbbbbbbbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAARXBzb24gRVNDL1AtUiBWNCBDbGFzcyBEcffffffffffffffffffffffffAAEAAhSAAAEdAAAM1ROVwAAAAAKAFwAXAAxADkAMgAuAfafasdffasdfalésfdAs,dfÉSAD,fgksdmfgasmdfgsdfgsdaaaaaaaaaaaaaaaaaaBAMG3AfgsdfgsdfgsdfgsdfgsdfgsdfgsdfgsdfgsdfgfffffffffffffffffffffffAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAQAAAAIAAAABAAAA/////0dJfgQAAAAAAAAAAAAAAAsdfgsdffffffffffffffffffffffffffffffffffAAAAAAAAAAAAAAAAAAAAkAAAAAAAAAAAAAAAEAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsdfgAAAAAAAAdsfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsdfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAdfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddgggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggsdfgg==</config:config-item>


In My case the printer was an usb printer connected to my NAS and it was used
by some Windows machines on home network.
When the NAS was turned off (or its LAN cable unplugged)
ods files freezed at opening.

In Calc File/Printer settings without deletion I could see the old network
printer IP, after deletion there I could see my current default printer (also a
network printer but connected to my router) however the settings.xml did not
have the deleted tags.

So the final fix should be using some timeout at opening or a popup window
about unavailable network printer and an option to delete old printer info from
ods.

LO version 5.3.4.2 x64 & WIN10 Pro

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170824/521799cc/attachment-0001.html>