Created attachment 121884 [details] Spreadsheet with first tab in portrait mode and second tab in landscape mode. Open the attached spreadsheet. Print the tab marked "Bracket" - it should print in portrait mode, as specified by Format -> Page. Now print the tab marked "Bouts" (you need print only page 1), and it prints correctly in landscape mode, as specified by Format -> Page. Now go back to the "Bracket" tab and print again -- and it still thinks it's in landscape mode.
Thanks for reporting, I can't reproduce. Win10x64 Version: 5.0.4.2 (x64) Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78
Using 5.0.4.2 on Linux makes the problem even worse -- now I cannot change the page orientation at all when printing. See this video: https://youtu.be/GUtOJLyzmTY (Sorry, it's a bit blurry when expanded to full screen size, but you will see what I mean.)
For the latest report with the video: Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78
A simple, single page, with Format -> Page set to Landscape also does not print correctly when created and printed from Linux. If the dialog Print -> Options tab is followed and button "use only paper size from printer preferences" is clicked then return to General tab and paper orientation can be changed. To no avail - setting paper orientation "portrait" causes the document to be printed in portrait orientation although it is a landscape document. Setting paper orientation to "landscape" prints a blank page. If a landscape xlsx spreadsheet is opened and the above followed, then it prints in portrait mode regardless of setting for paper orientation. Appears to be a Linux (CUPS ?) issue. Print dialog in Windows 8.1 is slightly different. No need to check "use only paper size from printer preferences" Properties -> Layout shows "Orientation" set as Landscape and job prints correctly as landscape
If a sheet having landscape page format is "exported to PDF" from Libreoffice in Linux then PDF viewer Okular displays it correctly as a landscape image. Okular version 0.24.0 also prints it correctly as a landscape page, without altering print settings. I can't be certain bug is in Libreoffice. I am using (mostly) version 5.0.2.2 in openSUSE Leap 42.1. All available updates applied. Results vary with printer: Brother MFC-J6910DW using latest available driver packages ver 3.0.0-1 from Brother gives results described above and by other reporters. Brother MFC-9120CN using latest available driver packages ver 1.1.2 from Brother prints a landscape page correctly from Libreoffice, without changing page orientation settings. This is a postscript 3 compatible printer. Dataproducts Typhoon 8 using basic Postscript-level 2 from Openprinting project prints a landscape page correctly from Libreoffice, without changing page orientation settings.
I've added this comment to Bug 50511 too, which appears to still be active, and covers similar problems. I'm using currently supported LO 5.0.2.2 on up-to-date openSUSE Leap 42.1. Brother MFC-J6nnnDW series are A3 capable and as for most such printers feed A4 as well as A3 short-edge first ie Portrait orientation in Print -> Properties -> Paper dialog. Latest driver package ver 3.0.0-1 from Brother has PS parameter "*VariablePaperSize: False". I work around this by having separate queues for A3 & A4, but these factors create some weird outcomes with LO. If a new landscape document is set to Format -> Page -> Format: A4, Orientation: Landscape then LO dialogs for Print -> Properties -> Paper differ depending on whether selected from File -> Print or File -> Printer Settings. The latter shows (greyed-out) paper orientation Portrait (which according to https://en.opensuse.org/SDB:Landscape_Printing, is correct practice). The former shows (greyed-out) paper orientation Landscape. Outcome on paper is equally incorrect, with part of the work only in centre of portrait oriented paper. If same landscape document is then set to Format -> Page -> Format: A3, Orientation: Landscape, ie all that is changed is paper size, then LO still shows A4 paper in Print & Print Settings dialogs, although an A3 queue has been selected. Job then prints out incorrectly in portrait page orientation but scaled up to A3 size. I've checked /etc/cups/ppd and the PPD file for A3 queue definitely has page size set to A3.
Sorry for not testing, but is this then a duplicate of Bug 50511?
Set to NEEDINFO. Change back to UNCONFIRMED, if you think your bug is not a duplicate. Change to RESOLVED DUPLICATE of Bug 50511, if you think it is.
This appears to be a printer driver problem; when I use the generic postscript driver, the spreadsheet prints properly. Unfortunately, it prints at approximately one third the speed of the Brother driver, but that's another thing entirely.
Oops. I mean a generic PCL6 driver (the printer doesn't support PostScript)
Closing as dupe, then. *** This bug has been marked as a duplicate of bug 50511 ***