Connecting to printer on when opening Calc doc

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.

Version: 26.2.2.2 (X86_64)
Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded

So your install “seems” to ignore the setting…

You could try

  • Start in safe-mode. Then load your file via menu FILE>OPEN
  • Directly rename the folder with the profile (rename, so you can restore later)
  • Set your default printer to Microsofts own "print-to-pdf, as this should be always available.

If this is not solved by a renewed Profile, perhaps create a bug-report at bugzilla…

PS: Your file is saved as .ods or is it a MS .xlsx ?

Thanks for your reply. I really appreciate it.
.
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.