Subject says it all. You simply cannot print to printer with Tabloid size paper. Steps to reproduce: 1. Install any version of Libreoffice or AOO on a Windows machine 2. Connect to a printer that supports Tabloid size paper 3. Format a document to Tabloid size (Page > Format) Current behavior: Print Dialog (preview) shows it is trying to print to Letter size paper (and indeed does if you continue with the print job). Expected behavior: Print Dialog (preview) should show Tabloid size paper, and print to it. This happens on both Windows XP (32 bit) and Windows 7 (64 bit), and after troubleshooting with my SOS tech rep, he determined it happens on 3 different printers: Canon, Sharp and Ricoh. Operating System: Windows (other) Version: unspecified
This bug is inherited from Openoffice and is at least 3 years old, but I suspect it is much older. AOO bug filed in July of 2010 is here: https://issues.apache.org/ooo/show_bug.cgi?id=112863
And by the way... for anyone who needs to print Tabloid documents (anyone who uses large spreadsheets for one), this is a SHOWSTOPPER bug.
I am seeing the exact same thing in Mac OS X 10.8.4 and LibreOffice Version 4.0.3.3 for OS X as well as OpenOffice 3.4.1. My workaround is to create a PDF and then use Preview to print it on my Brother MFC-J4510DW.
Changing importance to HIGH and CRITICAL, because as I said, this is a SHOWSTOPPER BUG for anyone who needs to be able to print Tabloid (11x17) sized documents. Help!
Just an FYI- I cannot replicate this behavior in Linux. When I use LO and choose a tabloid page size, it shows tabloid in the preview and I can select tabloid paper size and print just fine to tabloid on any of our printers that have tabloid paper. Perhaps it is MS-Windows specific (as marked). I was pointed here by a comment in https://bugs.freedesktop.org/show_bug.cgi?id=67903 and I don't see how they are related.
Ok, I found an annoying workaround that is impractical for companies using (or trying to use( Libreoffice as their primary Office platform. File > Print > Options Then check the box "Use only paper size from printer preferences" The problem is I cannot for the life of me figure out how to get this pref to 'stick'. Guess I need to go open a new bug for that one too...
This bug is very simple. Every Copier/Printer I've checked that is capable of printing to Letter, Legal and Tabloid size paper refer to these sizes as: Letter (8.50 x 11.00) Legal (8.50 x 14.00) and 11x17 (11.00 x 17.00) LibreOffice/AOO both refer to these sizes as: Letter (8.50 x 11.00) Legal (8.50 x 14.00) and Tabloid (11.00 x 17.00) This is the exact cause of this problem - since the Paper Size Name of 'Tabloid' doesn't exist on the target printer, Libreoffice falls back to the default of 'Letter'. So, as far as I can see, there are only two ways to fix this: 1. Change the Paper Size Name from 'Tabloid' to '11x17', or 2. Create an alternate/secondary name that has the exact same paper size that Libreoffice falls back to if 'Tabloid' is unavailable on the target printer. Would some kind soul *please please please* fix this? It can't be that hard can it? I mean, it should just be a string change or something...
(In reply to comment #6) > Ok, I found an annoying workaround that is impractical for companies using > (or trying to use( Libreoffice as their primary Office platform. > > File > Print > Options > > Then check the box "Use only paper size from printer preferences" > > The problem is I cannot for the life of me figure out how to get this pref > to 'stick'. > > Guess I need to go open a new bug for that one too... Done: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=79077
This is not a critical bug - please don't change priorities
(In reply to comment #7) > 2. Create an alternate/secondary name that has the exact same paper size > that Libreoffice falls back to if 'Tabloid' is unavailable on the target > printer. Like here? http://opengrok.libreoffice.org/xref/core/i18nutil/source/utility/paper.cxx#76 Also I have found it is defined as PAPER_USER here: http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xlpage.cxx#82 But it seems that the fallback doesn't work. > Would some kind soul *please please please* fix this? It can't be that hard > can it? I mean, it should just be a string change or something... This is open source project - if you want something done, do it yourself and contribute a patch ;). You can do a string change and compile own build. Easy peasy.
Perhaps bug 81065 is related. There seems to be a problem with libreoffice accepting the paper size/orientation from the printer preferences.
Hi Chuck, I guess you could say it is related because it is also a print issue, but that is about all. This bug is about a very easy to reproduce, persistent problem - it is IMPOSSIBLE to print to an 11x17 (Tabloid) size paper on Windows. The only workaround I've been able to find is print Letter to PDF, then print the PDF, and change the paper size to Tabloid, which works every time.
Well, crap, now this workaround stopped working... Joel - you say this isn't a critical bug? Say that in a company with 50+_ employees, all of whom at different times work with very large spreadsheets and need to actually be able to print to Tabloid sized paper available on their expensive copiers. You'll quickly find how arrogant your personal assessment is. This is an absolute BLOCKER for us, and has caused our boss to ask me to start rolling out Microsoft Office. The sad thing is, the lack of response to this bug really gives me ZERO argument against it. Word, Excel and Powerpoint all have been printing just fine on Tabloid this entire time. (In reply to comment #6) > Ok, I found an annoying workaround that is impractical for companies using > (or trying to use( Libreoffice as their primary Office platform. > > File > Print > Options > > Then check the box "Use only paper size from printer preferences" > > The problem is I cannot for the life of me figure out how to get this pref > to 'stick'. > > Guess I need to go open a new bug for that one too...
A couple things here: 1. Our assessment (QA) does not imply that devs will fix the problem. We do not push bugs onto devs, they volunteer to accept them. Even if this was set to blocker -> highest it would not guarantee (or even imply) that it would get more attention. 2. If you are using this for enterprise use, then well, perhaps you could consider giving back to the community and paying for support to have this "blocker" bug fixed. 50+ computers using LibreOffice, I would imagine you have the funds to help us help you. I could give you the names of several companies that offer paid support. 3. Arrogant....well, there's nothing I enjoy better than waking up, volunteering hundreds of hours of my time, and being called names. On that note, I'm removing myself from cc
(In reply to comment #13) > Joel - you say this isn't a critical bug? Say that in a company with 50+_ > employees, all of whom at different times work with very large spreadsheets > and need to actually be able to print to Tabloid sized paper available on > their expensive copiers. > You'll quickly find how arrogant your personal assessment is. > This is an absolute BLOCKER for us, and has caused our boss to ask me to > start rolling out Microsoft Office. > The sad thing is, the lack of response to this bug really gives me ZERO > argument against it. > Word, Excel and Powerpoint all have been printing just fine on Tabloid this > entire time. Joel is not arrogant, it is general policy of this project: https://wiki.documentfoundation.org/QA/BugTriage#Step_6._Prioritize_Bug Also see what was recently added at https://wiki.documentfoundation.org/BugReport#After_you_submit_a_bug. If this bug is blocker for you - then stop complaining demanding a fix - fix it yourself or persuade your boss to be LibreOffice donator and pay for a fix in true open source spirit... That is the reality. The list of certified LibreOffice developers: http://www.documentfoundation.org/certification/developers/
I was able to find a workaround for our Xerox printer. I could not print to tabloid with the PostScript Driver that was installed, but by installing another instance of this printer with the PCL5 driver, I can now print to tabloid from LibreOffice.
Arrogant was a poor choice of words, but the fact is, responses like 'why don't you just pay someone to fix it' for fundamental flaws in software that is advertised on the main Libreoffice Home Page as: "LibreOffice 4.3: today, you can’t own a better office suite" is just ridiculous. Maybe there should be disclaimers on the web page like: "Oh... wait... you mean you want to actually be able to print to standard size paper sizes like Tabloid (11x17)? Oh... wait... you mean you want to actually be able to use the newer versions *and* be able to paste into your Input fields, like you were able to do since Openoffice 1.0, but that was broken in the 4.2 series? Well, then, you need to stop whining and pony up..." Sorry - it is much easier to just stop fighting and let the boss buy Microsoft Office licenses... which he has already apparently decided to do, so this is really a moot point I guess. Sad, really... It's been a long road since we started using Openoffice (1.0), with ups and downs, but just too many downs in the last few years. The major problems started with poor compatibility with the new OOXML file formats - NOT the Libreoffice developers fault, and I totally understand this, but it didn't change the fact that we started getting more and more documents over time that would actually crash Libreoffice consistently. The crashes eventually stopped, and the compatibility got better, but combined with these showstopper (for us) bugs - one having been present for YEARS (this bug) and the other a major regression that has existed during the entire lifecycle of one major release (4.2) and still exists in the first release of 4.3 (the inability to paste into Input fields in 4.2+ versions) - well, it is just a last straw kind of thing...
I'm sorry you had a bad experience.
Thanks Michael. In fact I really am sorry that I sometimes let my frustrations get the better of me. If I was independently wealthy and/or a software developer, I would absolutely participate directly, adopting probably 10 or 20 of my pet bugs in every FLOSS project I use, and sponsor new features, etc... but alas, I am not, so all I can do is beg, and sometimes say "thank you!". So... thank you, Libreoffice devs, for Libreoffice - it isn't perfect (nothing is), and works, and works well for most things and in most cases, and really does seem to be getting much better as time goes on... :)
Whatever the Priority is, this bug creates a dead end for users requiring tabloid printing (myself included). Printing to A0 works. I'm curious if adding Ledger size (17" x 11") would survive the printer stack (users could correct orientation with Landscape vs Portrait). Also, paper Size User should never revert back to ANY named paper size: it should simply pass this to the printer and give the printer driver a CHANCE to determine page size. This problem can be reproduced on 4.3.4.1 on Mac OS X. At least assign it to someone. It has existed since OpenOffice, most office have ANSI D paper sizes, and, on that note, paper size names should be consistent. Metric and other paper sizes are named, and North American sizes are sized or nicknamed; not ANSI A/B/C/D/E. Might as well add Arch A/B/C/D/E while you're at it.
LibreOffice development currently prioritizes bugs with the so called MAB (most annoying bugs). As this bug has not run through that process (including writing a short rationale for this bug being a candidate and other who are watching the tracker bug silently approving that rationale etc), its priority is set to high. Note this is effectively no change in the urgency assigned to this bug, as we are currently not making a difference between high and highest and severity is untouched. You can find out more about MABs and how the process works by contacting the QA Team on IRC: http://webchat.freenode.net/?channels=libreoffice-qa The QA wiki page also gives you hints on how to get in contact with the team (if IRC fails you, your next best choice is the mailing list): https://wiki.documentfoundation.org/QA
This is a most annoying bug. I'm surprised it has lasted this long.
> I'm surprised it has lasted this long This is down to no-one being motivated enough to fix it =) who could that person be - as the National Lottery says: "it could be you" ?
That's a common response: why don't you fix it? Well then, non-programmers should really move on to other suites.
> Well then, non-programmers should really move on ... to become programmers =) All existing programmers started off as non-programmers. There is nothing magical or mysterious about software. I'm happy to help -anyone- learn that wants to get involved and fix this thing: with code-pointers, help building etc. It is entirely possible for a technically-literate (ie. knows what bugzilla is and how to create an account ;-) person to invest a week of their time on this and get a far better understanding of exactly this code and make the fix I think. Anyone that wants to make a positive contribution here is far more than welcome to contact me. What doesn't work is attacking developers and/or the project to make them think your bug is more important =)
(In reply to Charles from comment #1) > This bug is inherited from Openoffice and is at least 3 years old, but I > suspect it is much older. > > AOO bug filed in July of 2010 is here: > > https://issues.apache.org/ooo/show_bug.cgi?id=112863 adjusted version field
@bhofman (In reply to bfoman (afk) from comment #10) > Like here? > http://opengrok.libreoffice.org/xref/core/i18nutil/source/utility/paper. > cxx#76 > > Also I have found it is defined as PAPER_USER here: > http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xlpage. > cxx#82 (line #81 currently) > > But it seems that the fallback doesn't work. You mean that you would expect that when one enters 11 and 17 inch, that the Format would indicate 'User' ?
Please, could you try to check the third option in the Option tab of the print dialog : "Use only paper size from printer preferences" ? Set status to NEEDINFO. Best regards. JBF
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170328
Set back to NEW as this bug has already been confirmed. Best regards. JBF
I have two network printers that I print from...one for letter (8-1/2" x 11") size and one for tabloid (11" x 17") size. When I try to print a document in tabloid size, I am given the option to print 11" x 17" on the printer that can only print in letter size, however on the printer that prints in tabloid size the dialog box keeps reverting to letter size for printing. Go figure.
*** Bug 115271 has been marked as a duplicate of this bug. ***
The bug exists on a Mac (10.9.5). Workaround: create a PDF file and print from it. However, it is very annoying...
(In reply to haim kilov from comment #33) > The bug exists on a Mac (10.9.5). > > Workaround: create a PDF file and print from it. > > However, it is very annoying... Looks the same as me trying to print a landscape format on Linux. Nope... PDF helps. So more similar or related issues..
These bugs are more common in, the current behaviour of the printer began to change because of this you can try https://hpetechnicalsupportnumber.com/blog/fix-hp-printer-error-state-problems/ that make your all problems solve and manage the print accurately.
*** Bug 122182 has been marked as a duplicate of this bug. ***
So this bug ...; 1. Has a workaround, and 2. Is inherited from OO, and 3. Applies ONLY to the Calc component of LO (and OO). FIX the spreadsheet ..., 1. Find and replace "Tabloid" in the printer section of Calc, or 2. Replace the Calc printer code with that from Writer.... PLEASE!
Still, as of today, the latest version of LO Calc fails to work with a large spreadsheet and 11" x 17" paper in EITHER Portrait or Landscape mode. Looking at previous comments about this, I sense there is no great urgency to fix this problem on the part of the developers/maintainers. Even though the fix appears to be an easy one. One comment asked for a reason to fix the problem.... Here it is! IF the problem is not fixed, neither LO nor OO will maintain any traction in the corporate world against MS Office. EVERY time a spreadsheet user gets upset that their document didn't print is another nail in the coffin of LO & OO. I am no longer in the business world,so my needs are fewer now.
Created attachment 149300 [details] list of code pointers ... For anyone frustrated by this, who wants to become an expert in exactly this feature - I think it would take a few hours of reading, research and note taking for the average user to read through the code pointers I just attached using a web browser and gitweb and try to reason why the Tabloid page size is wrong. Anyone with a reasonably credible suggestion as to why the page size is wrong in this situation in terms of specific bits of code will be taken very seriously.
Comment on attachment 149300 [details] list of code pointers ... I am not a programmer,but.... Looking at the printer setup in WordPerfect, I find, US B (11 x 17in) Super B (13 x 19in) for my printer, an Epson Artisan 1430. Similar info should be available in MS Office for similar wide format printers. Looking at the 'Index of Code Pointers' I see Tabloid and Ledger. Neither are legitimate paper sizes and as used here Ledger is the LANDSCAPE version of Tabloid. That is wrong. Any paper size can be printed on in either portrait or landscape by software interpretation can it not?
Hmm - the step that says "connect to a printer that supports Tabloid size" - is that necessary ? or can this be reproduced when exporting to PDF ? - knowing that would help to isolate where the issue is: ie. our built-in paper sizes, or what Windows is reporting for its printer / paper sizes.
Actually, I just checked, and this is now working for me! I have the page set to Tabloid in Libreoffice (6.1.4.2, Windows 10 x64). I would really like a 'Fit To Page' auto-zoom option in the Print Dialog, but other than that, it printed perfectly. Tom - not sure why you said what you did about Ledger/Tabloid, they are perfectly acceptable and legitimate paper sizes: https://www.engineeringtoolbox.com/office-paper-sizes-d_213.html
I am setting this to Fixed, since it is now fixed (for me). I'm not sure what version fixed it, because I got tired of testing it a long time ago. I decided to try again because of these recent emails saying it isn't working.
Oh - and a huge THANK YOU to whoever did end up fixing this!
Sorry for reverting, I can't test now, but duplicates also need to be checked. If all correct, not Fixed but WorksForMe.
(In reply to Charles from comment #42) > Actually, I just checked, and this is now working for me! > > I have the page set to Tabloid in Libreoffice (6.1.4.2, Windows 10 x64). > > I would really like a 'Fit To Page' auto-zoom option in the Print Dialog, > but other than that, it printed perfectly. > > Tom - not sure why you said what you did about Ledger/Tabloid, they are > perfectly acceptable and legitimate paper sizes: > > https://www.engineeringtoolbox.com/office-paper-sizes-d_213.html Most printers are not made to be US specific, but for worldwide use. So why would a printer manufacturer want to use Tabloid/Ledger when it is obvious to them that they are both 11x17. Portrait vs Landscape works on 11x17 just like it does for the other sizes. Both Irfranview and Adobe Acrobat refer to printers as US B (11x17) and Super B (13x19) which is EXACTLY how my Epson Artisan 1439 Refers to those sizes. Sometimes the US standard is just plain stupid.
(In reply to Timur from comment #45) > Sorry for reverting, I can't test now, but duplicates also need to be > checked. > If all correct, not Fixed but WorksForMe. It might also be that some duplicates are in the end not exactly the same, so need special attention/more refined description.. We'll see ;)
As one of the dupes is for Linux, I will include this note from Dave of Largo: "On Linux, if you are using LibreOffice and the Tabloid paper size does not appear, it's because that size is not in the PPD file. In our case, HP did not have that paper size in the file. I hacked in the paper size and metrics and it's working."
Charter Communications’ Spectrum, the highest pay-TV provider in Southern California, and AT&T, the state’s biggest internet support provider, are currently notifying consumers that refunds no longer will be offered if service is removed before the end of the billing cycle. In the past, each company’s bills were prorated, which indicates you paid only for the services you practiced. If you cancel, you’d get a check behind for the remaining portion. https://www.livesupportaid.com/spectrum-pay-my-bill-online/
This blog has increased the level of information sharing. I just simply loved this blog. It has helped me a lot. A great and learning blog. I am very satisfied after reading this.For More Info :- https://www.bitts.ca/programs/Health-Services_Food-Service-Worker/ https://www.bitts.ca/programs/Business_Office-Administrative-Course/ https://www.bitts.ca/programs/Health-Services_Food-Handler-Certificate/ https://www.bitts.ca/ielts/testcentre-dates-venues/
I experienced the something similar when trying to print an 8.5x13 paper size document. Even after I set the document size to 8.5x13 on the print properties, it shows that it is set to "German Legal Fanfold 8.50in x 13.00in, but when I try to print it goes back to Letter size or when I open "Properties" again. Am I missing a "Save Settings" button or something? I am printing to a network printer (EPSON L1455), it has two cassettes (Cassette 1 is set to Letter size and Cassette 2 is set to 8.5x13). I tried opening the file on Office Word and printing from there, it worked normally. I recently updated to 7.1.1.2 but I don't know if this was a problem in previous versions, I usually save to PDF before printing anything but I was trying to print something out quickly and found this problem. I copy pasted this comment from 115481 because I realized it was possibly a duplicate of this. Version: 7.1.1.2 (x64) / LibreOffice Community Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded