https://bugs.documentfoundation.org/show_bug.cgi?id=171910
Bug ID: 171910
Summary: Connecting to printer on when opening Calc doc
Product: LibreOffice
Version: 26.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When I open a my spreadsheet with the hours I’ve worked for work, I get the
same message every time:
“Please wait for connection to printer or cancel connection.”
This started when I changed the default printer in Windows because I had to
print some PDFs ( I don’t have acrobat because it’s annoying ).
I Googled the issue and changed the Tools → Options → Load/Save → General →
Load printer settings with the document. This had no effect. I’ve updated
LibreOffice, I rebooted the system. I tried setting it to load printer settings
and then unchecking it again. If I go to File → Printer settings, it tells me
there’s no printer. Nothing seems to work.
If I open Calc without opening a document, I don’t get the message/prompt
unless I go to File → Print settings or File → Print. File-> Print preview
doesn’t result in the message/prompt.
It seems specific to an ODS file. But I can reproduce it on a newly created
file. It was suggested I reset the profile, that didn't work. I was able to
make it go away by setting my default printer to "Microsoft print to pdf" and I
was able to make it come back by setting the default printer back to the
"Brother network printer".
Restart in Safe-Mode: I went to Help → Restart in safe mode…
Of the 4 radio options (restore from backup, configure, extensions, and reset
to factory settings ) provided in the safe mode starting prompt I tried the
following combinations with “continue in safe mode” button: restore from backup
and configure without any check boxes; extensions with reset state of bundled
extensions; reset to factory settings with both ‘reset settings and user
interface modifications’ and ‘reset entire user profile’ as well as with only
“reset entire user profile”. I tried reset to factory settings with both
checkboxes with both the “continue to safe mode” and “apply changes and
restart” without any effect.
Opening my spreadsheet, and a newly created spreadsheet by right clicking in
Windows Explorer and going New → OpenDocument Spreadsheet then naming it to
test.ods. If I open that spreadsheet by double clicking, it opens without the
printer prompt. If I rename the initial “sheet 1” to “test” then save; close;
reopen document; then I get the “Connecting to printer” prompt. Same if I open
Calc then use File → Open, even in safe mode.
If I rename C:\Users<Username>\AppData\Roaming\LibreOffice\4\user to
C:\Users<Username>\AppData\Roaming\LibreOffice\4\NotAProfile, I get the same
results as if I use the “reset to factory settings” option with “apply changes
and restart” button in the safe mode starting dialog.
Setting my default printer in Windows to ‘Microsoft Print to PDF’ isn’t really
a solution as much as it’s a workaround and it didn’t work anyway - kinda.
However, there is still an odd behaviour. When I open the ‘hours worked’ ODS
spreadsheet, I still get the prompt. If I go to File → Print, the old default
printer is still selected. The first time I tried this I rebooted, but the
behaviour persisted between reboots - technically shutdown, wait, press power
button. If I open the newly created test ODS spreadsheet, I don’t get the
prompt and when I go to File → Print, ‘Microsoft Print to PDF’ is the selected
printer. test.ods still gets the prompt when I set the default printer back to
the network printer.
With that, I tried something not suggested. Given that it’s odd behaviour that
the printer, is tied to the document. With the default printer in Windows still
set to “Microsoft Print to PDF” I used File → Print, changed from the old
default to “Microsoft Print to PDF” and printed it to test.pdf. I saved the
document and reopened it. It didn’t give me the prompt of connecting to
printer. Once I changed the Windows default printer back to the networked
printer, the behaviour resumed. Then I remembered there’s a Tools → Options →
Load/Save → load printer settings with document. It was checked again, I
unchecked it but the behaviour persisted.
I have also documented it here:
https://ask.libreoffice.org/t/connecting-to-printer-on-when-opening-calc-doc/134312
Version: 26.2.2.2 (X86_64)
Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan;
VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded
Steps to Reproduce:
1. Set Windows default printer to network printer that is not available
2. Set "load printer settings with document" to off/unchecked
2. Open document that has been saved from within LibreOffice calc
Actual Results:
Dialog attempting to connect to printer appears when opening the document
Expected Results:
Document opens without attempting to connect to printer.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
I have screenshots of the setting disabled and the prompt appearing anyway. It
happened prior to 26.2.2.2 but I don't know what version I was on. I updated
to see if it would go away. Event Viewer logs don't go back far enough to see
the MsiInstaller for previous LibreOffice versions. It would have been a few
years ago, possibly as far back as June 2022 when I bought the laptop.
Version: 26.2.2.2 (X86_64)
Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan;
VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
