Problem description: I'm working with a spreadsheet that has more than 400 sheets. Sending print job to printers is slow. There is no problem if the spreadsheet has only one sheet. Steps to reproduce: 1. Open an .ods file that has more then 400 sheets. 2. Click on the Print button. Current behavior: It takes about 20-30 seconds before the job is sent to the printer. LO just hangs in the meantime. Tested on Windows XP and Ubuntu 12.04 (with i3 CPU). Expected behavior: Job is sent immediately. Operating System: Windows XP Version: 4.1.1.2 release
Hi Adam, Wow, 50-75 milliseconds per sheet. Seems a high and critical bug, maybe immediately is too much time.:)
(In reply to comment #1) > Hi Adam, > > Wow, 50-75 milliseconds per sheet. > > Seems a high and critical bug, maybe immediately is too much time.:) Please mariosv be nice. People are coming here to report their problem as we want to. Adam: Thank you for reporting this, however it is not a high priority issue so it is correctly set back. This is a hard problem to track, as the problem is probably related to the needed transfer of the data. As far as I see the problem probably is that the LO-gui hangs when it is printing, that could be improved. Would you be ok if I changed the bug to a request solving the hanging of the LO-interface.
Hi Admam, forgive me if you feel I was not too nice in my comment. If I am right, you are asking for compose the output for 400 sheets, even with just a page per sheet, in my opinion it is a lot of work to be done immediately, and I do not think LibreOffice hangs it is only doing the job. Comment #2: Rob, sorry, but by now I can not see the problem. IMO not too much common, an output of this size.
I'm not sure what you're talking about. As far as I know LO can't print more than one worksheets at a time. So if you were to print 400 sheets and all of takes 30 seconds it's more than 3 hours of hanging! Why does LO process 400 sheets of data when it can only print the sheet that has focus anyway? Or is there a way to print multiple sheets?
Hi Adam, as I know you can print all sheets at time in same file. In Menu/File/Print, there are several options for print: - All sheets. - Selected sheets. - Selected cells. In Menu/File/Export as pdf: - All - Pages - Selection and I have just verified it works for me. Win7x64Ultimate Version: 4.1.3.0.0+ Build ID: 952c5fe20d5975c8a2c9f5093d05472ca0fc78f
Mariosv: Thanks, I will test that tomorrow. However, if the default behaviour of the print button is to print the currently focused worksheet then LO should not spend time to process every sheet. I think only the one that will be printed should be processed. What do you think?
Adam, I don't know, I'm not a developer, maybe there are some operations what it is needed to do as part of a complete document. Can the case for calculate the scale to print?.
No file to test this. Is this bug still valid / reproducible with the latest LO release? Currently 4.2.0.4: http://www.libreoffice.org/download/ Please also try resetting your user profile and let us know if that helps: https://wiki.documentfoundation.org/UserProfile Should this be still reproducible for you with the latest LO release please set this bug back to UNCONFIRMED.
It's actually fixed in 4.2.0.4. I couldn't reproduce it, printing started immediately after pressing the print button. Great, thanks! Btw, isn't there a test file used by the developers that's big, has lots of tabs, has every feature the Calc has to offer? Why am I required to provide a file that has 400+ tabs? Why don't the devs have one like this?