Re: [libreoffice-users] Re: Loading each document about 3 minutes
On 2014-06-21 10:19, Cigydd wrote: Alternatively, I just remembered Steve Edmonds pointed out in another recent thread that there's an option under Tools Options Load/Save General Load printer settings with the document. Turning that off (together with setting the default printer to one which is always available, such as PDFCreator) might help you, in a much more convenient way! Mark. Thumbs up for this one! Turning that setting off cut the delay back to 1min for some files and for others it removed the delay completely. ... And setting also PDF Creator as the default printer removed the delays completely for all my files! Worked like a charm. Thank you guys again for all your help. LibreOffice is working for me again. It has a living, helping and clever community. You did it. We did it. Yippee ;-) Pavel a. k. a. Cigydd Hi. Was a bug ever filed for this. I have had similar problems so filed a bug https://www.libreoffice.org/bugzilla/show_bug.cgi?id=80697 but it may be related. I just updated from LO 3.6 to 4.1.6 on OSX 10.68. 3.6 was working fine. If I go to open a file from LO and navigate to a network share no files show in the share. If I cancel LO hangs and has to be killed. I can see the files in OSX finder (file explorer). I can open a file from finder (open with LO). Once I have at least one file opened from the network share (via finder) I can then see files on the share from within LO file open dialogue. Save as works ok Just found if I disable load printer settings with file all is ok. Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Loading each document about 3 minutes
Thank you for your response, Cley. OK, I disabled Avast completely (just only didn't uninstall it, only disabled it) and even rebooted for the change to take effect. Oops, the problem presists even with the antivirus disabled. The other cause that was mentioned in the posts I found was a disconnected printer. LibreOffice checks the printers to get their properties upon document load and when a printer is disconnected and it can't contact it, it waits several minutes if the printer occasionally connects. I also remember there was written that that software that waits isn't LibreOffice itself but the Windows printing spooler. So is there any solution to my problem except having the two computers which share that two disconnected printers always turned on or switching them on each time I need to work with LibreOffice on the third computer (which is a notebook)? I know, this sounds crazy but this is Microsoft. I have a chance to reboot to Linux Mint on my notebook so it could be a workaround for me but I'm trying to get a solution also for the others who may face such a problem. So what else may be the actual cause of the delay? Is it the Windows printing spooler? - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-minutes-tp4113003p4113014.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Loading each document about 3 minutes
2014-06-20 13:46 GMT+02:00 Cigydd cig...@gmail.com: So is there any solution to my problem except having the two computers which share that two disconnected printers always turned on or switching them on each time I need to work with LibreOffice on the third computer (which is a notebook)? I know, this sounds crazy but this is Microsoft. I can't tell for sure if that's the culprit, but if it is, you might be able to mitigate the issue by installing a virtual printer like a pdf printer (if you don't have one already) AND setting it as the default system printer. This might help, as the default printer asked for properties should always be present now. Of course, if that's not the cause of the issue, I have no idea. Does this happen with every document, or just a handful/documents in specific folders? There's two things that comes to mind: either some document got exceedingly complex from the parser point of view (usually happen when switching back and forth between different formats), or some other windows magic is at work. (I don't exclude a possible bug in LO, but since it's a relatively rare problem, it's more likely due to some strange interaction than due to LO in itself.) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Loading each document about 3 minutes
Hi Cley and TomD, thank you for your replies. I have an interesting update. I uninstalled Avast completely and rebooted. I also installed PDF Creator and set it as the default printer. Printed a document in LO to PDF Creator so that it remembered PDF Creator as the last used one (and thus the default one). After that the delay has dropped down to about one minute and it shrinked its appearance to only ODS files. ODT and XLS files are opening immediately. Tested with two ODS files with a very long history. I edited them with OpenOffice.org, LibreOffice, on Linux, Windows, various machines and versions. I also discovered that the same one-minute delay appears when displaying the print dialog when trying to print these ODS spreadsheets. Trying to display the print dialog from the XLS files (which are basically parts of the ODS files saved to XLS) gives me no delay at all. I opened another ODS file now and it loaded immediately. So I am pretty sure now the problem shrinked only to the two problematic ODS spreadsheets. I'll try to reinstall Avast to see what changes. It may be another problem. One delay on the problematic files makes 1 minute and the remaining 2 minutes could be caused by the antivirus. I'll keep you informed. - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-minutes-tp4113003p4113038.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Loading each document about 3 minutes
Interesting news. I reinstalled Avast and the delay remains at 1 minute for the bad ODS files only. Other files, including another ODS, load immediately. So maybe the issue doesn't lie in the antivirus at all. --- Tato zpráva neobsahuje viry ani jiný škodlivý kód - avast! Antivirus je aktivní. http://www.avast.com - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-minutes-tp4113003p4113052.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Loading each document about 3 minutes
Other news. Displaying the print dialog delays 1min 20s or 1min 40s when the disconnected printer is set as default in the system and regardless of what document is loaded. When PDF Creator is set as the default, the print dialog displays without delay. But opening the bad ODS files still lasts about 1min 5s. Even with Avast installed. It's however better than the initial state of loading each document about 3 minutes. Maybe Avast needed to be reinstalled... So does somebody have an idea what's causing the remaining delay by loading the ODS spreadsheets? One of the files contains about 30 sheets, each of them 1-3 pages long. But it can't be the cause because the other file contains only 1 sheet with 4 rows. - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-minutes-tp4113003p4113056.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Loading each document about 3 minutes
I have other news. Setting the disconnected printer to default prolongs the loading delay to 2min 5s. Setting PDF Creator to default shortens the loading delay back to 1min 5s. Both loading the odd ODS files. ... Oh no. I am back on 3 min 10s with an ODS file that didn't have any delay before. And an ODT file started to delay 3:10. Another ODT file loads fine and the XLS files also load fine. Guys, this is starting to be very random. Maybe Avast returned to its old habits again. I'm going to test without it again. - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-minutes-tp4113003p4113063.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Loading each document about 3 minutes
2014-06-20 22:44 GMT+02:00 Cigydd cig...@gmail.com: So does somebody have an idea what's causing the remaining delay by loading the ODS spreadsheets? One of the files contains about 30 sheets, each of them 1-3 pages long. But it can't be the cause because the other file contains only 1 sheet with 4 rows. Knowing that the printer issue is still real (and fixable somehow) is good news. Now, as to why some specific files take longer to open, there's too many causes to rule out, and some of these causes might even be invisible. Maybe there's a lot of complex formula that gets calculated when loading, maybe there are macro that run when opening these files, or maybe it's something else (although I believe there is an option to not compute formula automatically... this might need to be tested). It might be impractical for the 30 sheets document, but you can try this: select all content from the 1-sheet document, and copy/paste it in a new calc file. Then, check how long this new file take to load... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Loading each document about 3 minutes
On Friday, June 20, 2014 04:46:41 AM Cigydd wrote: Thank you for your response, Cley. OK, I disabled Avast completely (just only didn't uninstall it, only disabled it) and even rebooted for the change to take effect. Oops, the problem presists even with the antivirus disabled. The other cause that was mentioned in the posts I found was a disconnected printer. LibreOffice checks the printers to get their properties upon document load and when a printer is disconnected and it can't contact it, it waits several minutes if the printer occasionally connects. I also remember there was written that that software that waits isn't LibreOffice itself but the Windows printing spooler. So is there any solution to my problem except having the two computers which share that two disconnected printers always turned on or switching them on each time I need to work with LibreOffice on the third computer (which is a notebook)? I know, this sounds crazy but this is Microsoft. I have a chance to reboot to Linux Mint on my notebook so it could be a workaround for me but I'm trying to get a solution also for the others who may face such a problem. So what else may be the actual cause of the delay? Is it the Windows printing spooler? Are you running any spam software. I know on my Linux version of LibreOffice, when I turn on spamassassin it slows the opening of Documents quite a bit. Russ - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-mi nutes-tp4113003p4113014.html Sent from the Users mailing list archive at Nabble.com. -- openSUSE 13.1(Linux 3.11.10-11-desktop x86_64| Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3| GeForce 8400GS (NVIDIA-Linux-x86_64-331.79)|KDE 4.13.2 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Loading each document about 3 minutes
Cigydd wrote: Other news. Displaying the print dialog delays 1min 20s or 1min 40s when the disconnected printer is set as default in the system and regardless of what document is loaded. When PDF Creator is set as the default, the print dialog displays without delay. But opening the bad ODS files still lasts about 1min 5s. Even with Avast installed. It's however better than the initial state of loading each document about 3 minutes. Maybe Avast needed to be reinstalled... So does somebody have an idea what's causing the remaining delay by loading the ODS spreadsheets? One of the files contains about 30 sheets, each of them 1-3 pages long. But it can't be the cause because the other file contains only 1 sheet with 4 rows. I think the last-used printer settings are saved within the file. For new files, or where the printer saved in the file isn't installed, I expect LO would use the default (PDF Creator in your case). If the last-used printer saved in the file is installed, but not currently reachable (from other posts, it looks like you're using networked printers?), there may be a delay while attempting to connect to that printer. I've seen this kind of delay with other software, not just LO, when an installed printer isn't available. Depending how much you're going to be re-opening the file in between printing, it might be worth making sure it's saved with an always-available printer (e.g. PDF Creator) as the last-used printer: - Open the file (may have to put up with the delay this once...) - File Print - Select PDFCreator - Click OK - Cancel in PDFCreator (unless you want a PDF copy right now) - Type a character and delete it again (so that the file is modified) - Save the file Next time you open the file or go to print it, the printer will be set to PDFCreator so avoids the delay. Of course, if you switch the printer on and print to it, the last-used printer will be set to that, so you might get the delay again next time if the printer is switched off - unless you either close the file without saving or do another dummy print to PDFCreator after printing it. Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Loading each document about 3 minutes
Mark Bourne wrote: I think the last-used printer settings are saved within the file. For new files, or where the printer saved in the file isn't installed, I expect LO would use the default (PDF Creator in your case). If the last-used printer saved in the file is installed, but not currently reachable (from other posts, it looks like you're using networked printers?), there may be a delay while attempting to connect to that printer. I've seen this kind of delay with other software, not just LO, when an installed printer isn't available. Depending how much you're going to be re-opening the file in between printing, it might be worth making sure it's saved with an always-available printer (e.g. PDF Creator) as the last-used printer: ... Alternatively, I just remembered Steve Edmonds pointed out in another recent thread that there's an option under Tools Options Load/Save General Load printer settings with the document. Turning that off (together with setting the default printer to one which is always available, such as PDFCreator) might help you, in a much more convenient way! Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Loading each document about 3 minutes
Thank you for your valuable responses, Cley, upscope and Mark. I figured out finally that Avast isn't the culprit. Tested without it, the problem remains, even the 3:10 delays. I don't run any antispam software, only the antivirus. So Avast is out of blame for now. I will concentrate on the printers. - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-minutes-tp4113003p4113070.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Loading each document about 3 minutes
Alternatively, I just remembered Steve Edmonds pointed out in another recent thread that there's an option under Tools Options Load/Save General Load printer settings with the document. Turning that off (together with setting the default printer to one which is always available, such as PDFCreator) might help you, in a much more convenient way! Mark. Thumbs up for this one! Turning that setting off cut the delay back to 1min for some files and for others it removed the delay completely. ... And setting also PDF Creator as the default printer removed the delays completely for all my files! Worked like a charm. Thank you guys again for all your help. LibreOffice is working for me again. It has a living, helping and clever community. You did it. We did it. Yippee ;-) Pavel a. k. a. Cigydd - Cigydd Bach -- View this message in context: http://nabble.documentfoundation.org/Loading-each-document-about-3-minutes-tp4113003p4113072.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted