Bug 151135 - Print Dialog Print Preview: Row missing in print preview (and print) after changing orientation
Summary: Print Dialog Print Preview: Row missing in print preview (and print) after ch...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Print
  Show dependency treegraph
 
Reported: 2022-09-22 15:13 UTC by Telesto
Modified: 2023-01-21 18:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file (8.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-09-22 15:13 UTC, Telesto
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2022-09-22 15:13:34 UTC
Description:
Print Dialog Print Preview: Row missing in print preview (and print) after changing orientation

Steps to Reproduce:
1. Open the attached file
2. Select A1:G23
3. CTRL+P
4. Change the rotation from automatic to Landscape

Actual Results:
yellow bar gone

Expected Results:
Should be visible in print preview (and actual print)


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 349e3af0c5dd5ed495ed61aab526f63c16f0e215
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded
Comment 1 Telesto 2022-09-22 15:13:53 UTC
Created attachment 182628 [details]
Example file
Comment 2 raal 2022-10-04 20:17:39 UTC
Confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: a0bc0cc81b597aa81189355a8125753d6b873cce
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

not in Version: 7.0.0.0.alpha1+
Build ID: 574c57090642347980d2395e1e183cc7b5c171ad
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 3 raal 2022-10-04 20:28:31 UTC
in linux-64-7.2 it works OK, in linux-64-7.3 doesn't works change portrait->landscape in print dialog, in linux-64-7.5 change portrait->landscape in print dialog works and bug occurs.
Comment 4 Stéphane Guillou (stragu) 2023-01-21 18:23:20 UTC
I see it as described in:

Version: 7.4.4.2 / LibreOffice Community
Build ID: 85569322deea74ec9134968a29af2df5663baa21
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

and:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 579d144290c1617fdb38d09b30900a6bbe390b8d
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Both print dialog and PDF printed to file show missing top row.

However, this is only because the Format > Page Style > Page > Page Format is set to portrait, and therefore the print ranges are in portrait. The missing rows are the top and bottom ones that don't fit when trying to fit a portrait page format on a landscape piece of paper. Same kind of "cropping" happens in Writer when trying to print a portrait page in landscape orientation (unless one is printing two portrait pages per landscape sheet).

Bit of history, according to my tests:

OOo 3.3, LO 6.1 and 6.2 had a different print dialog: changing the orientation could only be done in the printer properties. Changing it to landscape did update the preview, print range centered, top and bottom rows not visible. Printing results in same.

LO 6.3 to 7.1 showed correct landscape orientation in the preview, top row visible because the print range is not centered: it is top left-aligned. Prints in portrait orientation.

LO 7.2 and 7.3 (and oldest version in the linux-64-7.4 bibisect repo) do not update the orientation in the preview, like Raal noticed. Print to file still results in the page in portrait orientation, all data visible.

So we went through these stages:
1) correct orientation in preview and print, but data outside of paper
2) correct orientation in preview, top row visible because top left-aligned, but printed in wrong orientation
3) wrong orientation in preview and print (so all data is visible, because portrait mode)
4) correct orientation in preview and print, but data outside of paper.

We are now back at the original situation, so not a regression.
Versions 6.3 to 7.3 were clearly buggy in different ways.

I'd say this is "not a bug" as the page format could have been changed to landscape.
One could however argue that the print range should shrink to the space it has on paper so everything is still visible, or that it should be top-left aligned so the first data is always visible (like in LO 6.3 to 7.1), but probably better to open a new report for that. I couldn't find an existing one.