Apache OpenOffice (AOO) Bugzilla – Issue 82290
Calc - empty first sheet in workbook does not allow printing from preview
Last modified: 2013-08-07 15:14:24 UTC
repro steps 1. Using 2.3 or higher start Calc. 2. On Sheet 3 type anything, click File - Page Preview, then File - Print - OK. You get error message "There is nothing to print. The selected print range or sheet is empty", which is clearly wrong. 3. Close Page Preview and click File - Print - OK - file prints just fine. Issue http://www.openoffice.org/issues/show_bug.cgi?id=82016 seems relevant.
Step 2 worked in 2.2.1 and earlier, so setting keyword regression.
Hi, I can confirm this issue. The new default option "Print only selected sheets" seems to have strange behaviour from "Print Preview" window ( all ok in "normal view"). From Print Preview, it works only if you're on the first sheet of the work book. I will send you an attachment as example. - You're on second sheet ( a data pilot, 2 pages printing). - Click "Print preview" - Click Print => error message "Nothing to print bla bla bla ..." - Quit print preview mode. Click on first sheet to select it - Click "Print preview" then click "Print" ... it works !. Then, quit preview mode ... click on the second sheet and move it in first position. Click "print preview", then "print" ... it works ! Perhaps a problem relative a bad page counting method in print preview ? Oh...other thing to try .. -Restore the initial sheets position. -From the second sheet, click "Print Preview" - In print preview mode, using toolbar buttons preview pages from the first sheet - Click print ... Something print, but I don't know exactly what .. Attachment following.
Created attachment 48788 [details] Sample worksheet for print preview bug
More ways to repro the problem: 1. Start 2.3 Calc. 2. Enter random data to fill first 100 of lines. 3. Open print preview, scroll to the second page and click "Print file directly" icon - you get error message.
Hi Thomas, using File - Print works, but using the Print Button on the toolbar gives the error message Nothing to print. Please have a look at this one. Frank
I fail to understand why this regression is not targeted for nearest bugfix release.
Hi Kyrill, was targeted to 2.4 as I thought that there is a simple workaround using the File-Print Menu and Thomas have a tight schedule. Had another look and found out that the workaround does not work, therefore re-targeted to 2.3.1 . Frank
Frank, Thomas, I understand "tight schedule" reason, but I also understand that many thousands (if not millions) of our users could gave been affected for 3 more months. I also afraid that developers are unlikely to have more time after 2.3.1, so I appreciate targeting this for 2.3.1. Thank you very much! WBR, KP.
accepted
fixed on CWS dr59 The following files are affected: sc/source/ui/view/prevwsh.cxx
Thomas, great job! Could you tell non-developer types what was wrong? Thank you very much! WBR, KP.
TBE->KPALAGIN: The reason for this issue is the following. When printing from the Page Preview with the 'Print only selected sheets' option enabled, only the sheet which belongs to the currently visible page should be printed. The bug in the code was simply, that the page number instead of the sheet number was taken. Therefore if a document contained only sheets with one print page everything worked fine, but as soon as a document contained a sheet with more than one print page, either the correct sheet, the wrong sheet or nothing was printed.
TBE->FST: Please verify on CWS dr59.
found fixed on cws dr59 using Linux, Solaris and Windows build
found integrated on master m239 using Linux, Solaris and Windows build
*** Issue 84916 has been marked as a duplicate of this issue. ***