Bug Hunting Session
Bug 92676 - Cannot change page orientation during SELECTION print in Calc (if page A4 and not Letter, until Page style changed)
Summary: Cannot change page orientation during SELECTION print in Calc (if page A4 and...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 92677 (view as bug list)
Depends on:
Blocks: Print-Dialog
  Show dependency treegraph
 
Reported: 2015-07-10 15:25 UTC by fabriadri
Modified: 2019-11-15 12:42 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
excel format file (83.84 KB, application/zip)
2015-07-10 15:25 UTC, fabriadri
Details

Note You need to log in before you can comment on or make changes to this bug.
Description fabriadri 2015-07-10 15:25:16 UTC
Created attachment 117173 [details]
excel format file

Setup the printer for an A4 horizontal.
Select cells from H66 to M76
Print the selection trying to print on an horizontal A4: there is no way to do it: the page format is always vertical.
see attached file.
Comment 1 Timur 2015-07-10 15:39:57 UTC
*** Bug 92677 has been marked as a duplicate of this bug. ***
Comment 2 Cor Nouws 2015-07-10 15:51:29 UTC Comment hidden (obsolete)
Comment 3 Timur 2015-07-10 17:39:56 UTC
Interesting. Report is rather slim. Thank you for making LO better, but please be more specific and make some tests when reporting bugs. 
Attachment here is not important, because each selection printing from Calc is the same: changing page format in printer is useless. That started from 4.1.
Before, changing page format in printer to landscape, let's say, yielded landscape page, but without correct print, so not a regression.

I checked MS: you can choose orientation during print, but even if you change page orientation for a printer, you get page orientation changed, so all settings in print dialog are integrated. 
Yes, setting the page style to landscape will print correct, but that's a workaround for a selection, so I consider this a bug and set to Minor.
Comment 4 Cor Nouws 2015-07-14 23:21:20 UTC
(In reply to Cor Nouws from comment #2)
> IMHO you just have to set the page style to landscape..

Or at the Tab Options check "Use only paper size from printer preferences" and then set the printer properties correct.

I set this as WorksForMe.
If you have detailed info about how this doesn't work, as requested by Timur too, please mention it and reopen.

Cor
Comment 5 Timur 2015-07-15 09:47:04 UTC
https://wiki.documentfoundation.org/ReleaseNotes/4.1 says:
Printer settings change tdf#61186 (Caolán McNamara)
    By default the printer settings (such as page size) are taken from the printer settings stored in the document (File ▸ Printer Settings ▸ Properties), not the Printer Properties (File ▸ Print ▸ Properties).
    To use the settings from the Printer Properties (previous behaviour), click the new "Use only paper size from printer preferences" checkbox on the "Options" tab.

So, that explain what the trick with "Use only paper size from printer preferences" seems to work for paper orientation.

But, printing DOESN'T WORK in terms of correct printing of selection.
Please try with some data in the cells. Using that option and setting to Landscape I get the paper oriented, but I don't get the selection printed.
Comment 6 Cor Nouws 2015-07-15 18:27:45 UTC
(In reply to Timur from comment #5)
> 
> But, printing DOESN'T WORK in terms of correct printing of selection.
> Please try with some data in the cells. Using that option and setting to
> Landscape I get the paper oriented, but I don't get the selection printed.

Hi Timur,

Thanks. Then that is a different issue: when printersettings Landscape is used and Page formatting not adjusted, the information is not printed correct. Is it?
Comment 7 Timur 2015-07-16 15:51:10 UTC
Basically, yes, but also for vice-versa: Landscape Page format printing to Portrait. 
And probably also the same problem for Writer.
Comment 8 Timur 2016-03-14 16:48:34 UTC
Looking at Bug 98114 and attachment 122911 [details] I noticed I can change page orientation there in Print dialog via printer properties. 
But only as long as it's Letter page. If I change to A4, I can't. 
Similar here with attachment 117173 [details], if I change to Letter, I can change page orientation in Print dialog.
Actually, it works for Letter, Legal, and it doesn't for A4, A3, B4..
Comment 9 Timur 2017-09-11 14:16:45 UTC
I think this is not Calc but LO. I had similar in Impress. Tried to print 6 slides per page (PDF export doesn't allow this). 
We have (pages and default orientation): 1 L, 2 P, 4 L, 6 P, 9 L, 16 L which is mostly OK.
But if I want to change 6 P to 6 L, I can't. Even if paper was Letter, it's changed to A4 then and orientation remains P. 
Repro in LO 6.0+.
Comment 11 Zineta 2017-11-10 12:09:50 UTC
I can not reproduce it  with 6.0.0 and earlier.
Comment 12 Timur 2017-11-10 13:14:48 UTC
I still repro this one. We may have diff. problems:
- user must know about "Use only paper size from printer preferences" checkbox on the "Options" tab if (s)he wants to change paper orientation just for print
- even with that, selection print in Calc/Writer is not correct
- there's no preview for selection print, so Page formatting is not and cannot be adjusted in Calc/Writer (or for pages per sheet layout in Impress, that may be another bug)
Comment 13 QA Administrators 2018-11-11 03:47:28 UTC Comment hidden (obsolete)
Comment 14 Timur 2018-11-12 08:50:56 UTC Comment hidden (obsolete)
Comment 15 QA Administrators 2019-11-13 03:32:30 UTC Comment hidden (obsolete)
Comment 16 Timur 2019-11-14 17:39:34 UTC
Looks like comment 8 for Calc is still repro in LO 6.5+.
Note: there's no more ""Use only paper size from printer preferences".
Comment 9 for Impress is no repro since new print dialog. Adapting Title.