Apache OpenOffice (AOO) Bugzilla – Issue 112863
Tabloid(11x17) Printing not working
Last modified: 2015-03-04 22:21:05 UTC
Tabloid is not recognized by printer or other software as 11x17. Printer uses 8.5x11 instead. Saving in a file format other than od* format does not recognize Tabloid as 11x17 either. For example create a spreadsheet saved as ods. Create a copy as xls using Save As... . (Or just save straight to xls. Either way) Opening the xls in Excel shows any pages set to Tabloid as having no page size when viewing the page settings. Setting "User" page size and manually entering 11x17 results in OpenOffice automatically changing it back to Tabloid. 11x17 worked in 3.2.0 , however I believe that there was a seperate 11x17 paper size option.
@ hi: Please have a look.
@OC: Please take over, Thanks.
@pl: Please have a look
Checked in Windows XP as well. 11x17 printing is not functioning as it should. Tabloid is not registering as 11x17 to printers or other programs.
please have a look
3 months later, any possibility of a confirm or a "It's working for me"? I am attaching 2 pdf's displaying the issue using Calc. In both prints the page setting on that tab is set for Tabloid, Landscape, and scale print area to fit 1 page. "Incorrect Paper Size.pdf" is the result. Print comes out on 8.5x11 and cut off. With "Paper Size Forced at Printer.pdf" I did just that and told it to print to stack bypass and forced it to use 11x17 paper. It just printed the 8.5x11 area on the sheet. In the end it may just be a naming thing. I dont know how the size is relayed to the printer (by dimensions or name), but I do know that Excel does not recognize "Tabloid" if the file is saved as .xls from Calc but it does know 11x17. If it's dimensions, I dont think they are recognizing the dimensions.
Created attachment 71795 [details] Incorrect size
Created attachment 71796 [details] Incorrect Dimensions
Just checked with OOo 3.3 RC8 and it still has the same issue. "Tabloid" paper size does not print as 11x17 and does not transfer when saved in MS Office format. I can understand not worrying about it transfering to MS Office but right now it's the only way I have to print a spreadsheet to 11x17 Landscape. Since OpenOffice will not print as 11x17 I am having to save the file as .xls and tell my Excel viewer to print 11x17 instead. (Which requires me to setup the pages again since Tabloid is not being recognized by Excel as 11x17 either.) Calling it "Tabloid" in the printing/page properties is fine. But how about we send "11x17" when going to a printer or exporting.
If I export such a page format to pdf, I get the correct page size in Acrobat Reader. Please try using the pdf export and print via Acrobat Reader. I haven't got a suitable printer to actually print. Do you have got a printer, which has Tabloid as inbuild paper sheet size? If not, can you set your printer to know Tabloid? What printer do you use? Do you set the paper sheet size in the printer properties in the printing dialog? Does the checkbox "Use printer metrics for text formatting" in Tools > Options > Calc > General influences the result?
You are correct. Exporting to PDF appears to maintain the page format. However this is a workaround to the issue, not a fix. I am already exporting to Excel and re-establishing the page format again to print from that program instead. Yes, I am in an office that has multiple printers with 11x17 paper format which we print to many times during the day for spreadsheets, PDF and AutoCAD drawings mostly. OpenOffice just started having this issue with the release of 3.2.1. I do not have the issue with any of the other programs. Tabloid can not be "learned" as that paper size is already in use by "11x17". No. I set the paper size in Page Style since I have some tabs that will print 8.5x11 Portrait and some that will print 11x17 Landscape. Just to try your suggestion I attempted to set the printing properties to 11x17 Landscape and it printed 8.5x11 Landscape. Although I have already tried this before. No, "Use printer metrics for text formatting" does not fix the issue. It does teem to adjust the text a little though. If you get a chance could you verify the issue please. A) Export a spreadsheet with Tabloid page size to .xls and observe if the page size disappears. You can use Excel or free Excel Viewer to check it. B) Attempt to print to Tabloid page size directly from OpenOffice. Is it the name "Tabloid" or the paper dimensions which are passed?
Changed OOo version to 3.3 My specific issue: 1) Canon business class printers (iR5050 and iR C3220) do not recognize "Tabloid" as a paper size. Prints 8.5x11 instead. 2) Microsoft Office products do not recognize "Tabloid" as a paper size. Exporting to a Microsoft format causes loss of page size information.
We can confirm the issue under Ubuntu 8.04 & 10.04. After manually altering the .PPD file for a Lexmark C920 by changing all instances of "ledger" to "tabloid" test prints were intermittently successful. After manually adding a new "17x11" page size to the .PPD and changing the existing entries for "tabloid" from "11x17" to "17x11", landscape test prints were intermittently successful. While the 11x17 adjustment is in place 17x11 prints are printed on Letter paper. While the 17x11 adjustment is in place 11x17 prints are printed on Letter paper. Neither of the adjustments are reliable, with results varying from printing correctly on the correct paper to printing on Letter instead of 11x17. The only current solution is to export to PDF and print the PDF, which automatically adjusts the rotation and prints on 11x17 from the correct printer drawer.
Hi Philip, please take over
@oc: that would aparently mean that a) you can reproduce the problem b) have a printer that prints tabloid c) I can use that printer ? "Please take over"
OTOH playing issue ping pong isn't going to help either. So I'll try the faked PPD thing and on Windows see what's happening in the XPS printer driver. Unfortunately then a possible fix will be not verfifiable. Setting platform to "All" since lfilak reported the problem also on Linux.
OC, What were you able to find when using the fake .PPD. If you would like to forward your adjustments we could certainly see what impact it has here (Ubuntu 8.04 & 10.04 / Lexmark C912). Overall it seems as if 11x17 paper can be referenced by two different names depending on orientation, and how a device/software/ppd refers to that name/orientation is causing a real problem.
Reset assignee on issues not touched by assignee in more than 2000 days.
This is still a bug 2000 days later in Version: 4.3.4.1 on Mac OS X 10.9. Setting page size to A3 (wider and shorter, but in "margin" of error), printing to PDF to view in Preview, and then printing to 11x17" is a work around. In all LibreOffice applications, setting page size to User should respect the width x height and not change the named page size. At least printers have a CHANCE of matching the page size.
@gnurob: If you want to report a bug for LibreOffice I suggest to use their bug tracking system. ;-) This one is for OpenOffice.
My bad. Embarrassing! :-)