<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:gstr1234@gmail.com" title="szz <gstr1234@gmail.com>"> <span class="fn">szz</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - With disconnected network printers, Calc hangs opening some files waiting on the Windows print spooler"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=42673">bug 42673</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>gstr1234@gmail.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - With disconnected network printers, Calc hangs opening some files waiting on the Windows print spooler"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=42673#c17">Comment # 17</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - With disconnected network printers, Calc hangs opening some files waiting on the Windows print spooler"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=42673">bug 42673</a>
from <span class="vcard"><a class="email" href="mailto:gstr1234@gmail.com" title="szz <gstr1234@gmail.com>"> <span class="fn">szz</span></a>
</span></b>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>