Description: In print preview, in the landscape view, the header & footer are missing and the top 3 table rows are omitted. On printing, the same happens. This occurs in both .ods and .xslx files Portrait view is fine. Steps to Reproduce: 1.Create a calc file with many lines e.g. a column of numbers 1-120 in order. 2. Save as .ods or as .xlsx 3.Select Print, then orientation: Landscape 4.(optional) Print Actual Results: In the preview, the sheet name and page number do not appear as header and footer. several rows of the table are missing at the top (and bottom?) of the page. On printing the same appears. Expected Results: In both preview and on the printed pages, I should see the sheet name at the top of the page as a header, and the page number at the bottom as a footer. On page 1, I should see all the table rows, starting at row 1. On page 2, I should see all the rows that continue directly after the rows on page 1. etc. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument Version: 7.4.5.1 (x64) / LibreOffice Community Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL This version of LibreOffice was installed today (updated from 7.3). HP envy laptop HP Deskjet 3050A printer
Created attachment 185510 [details] Test case for landscape bug in Calc
Created attachment 185516 [details] Screens landscape mode. Looks fine for me. Version: 7.5.1.1 (X86_64) / LibreOffice Community Build ID: bd819218336a5be54a11b986ea4dd2db2efb120e CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Created attachment 185530 [details] Landscape view - page style not corresponding to print format
Created attachment 185531 [details] Landscape view - page style set to landscape, print automatic or landscape
Created attachment 185532 [details] Portrait view - page style not corresponding to print format
Created attachment 185533 [details] Portrait view - page style set to portrait, print automatic or portrait
Further testing shows that there is a lack of correspondence between Format > Page style settings (whether from main menu or Print Preview), and the Print popup. So, when the Page Style setting Orientation is set to Landscape, and then Orientation is either automatic or Landscape in Print popup, all is fine. Likewise for Portrait in Page Style and in Print popup. However, if Page Style setting Orientation is set to Landscape, then changed in Print popup to Portrait, the style does not update properly, it does not display as expected in Print popup, nor print as desired. Likewise, if Page Style setting Orientation is set to Portrait, then changed in Print popup to Landscape, the style does not update properly, it does not display as expected in Print popup, nor print as desired. Examples of the errors are different. When Landscape is mis-formatted, it lacks header and footer and misses a few rows top and bottom. When Portrait is mis-formatted, it displays header and footer at landscape separation, and loses display of ALL rows. This behaviour is also described in bug ID 135687 I would expect Print popup to correctly determine the selected orientation, and print accordingly. I will now try this in LibreOffice version 7.5.0.3 (x86_64) To see if this behaviour is still present. I don't have version 7.5.1.1
Defective Orientation Behaviour in Print popup and printing persists in 7.5.0.3 Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: c21113d003cd3efa8c53188764377a8272d9d6de CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL threaded
(In reply to m.a.riosv from comment #2) > Created attachment 185516 [details] > Screens landscape mode. > > Looks fine for me. > Version: 7.5.1.1 (X86_64) / LibreOffice Community > Build ID: bd819218336a5be54a11b986ea4dd2db2efb120e > CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: > win > Locale: es-ES (es_ES); UI: en-US Calc: CL threaded You are testing with Print Preview. The bug reporter is testing using Print (File - Print) and from there change Page Layout to Landscape. Confirm with Version: 7.5.0.1 (X86_64) / LibreOffice Community Build ID: 77cd3d7ad4445740a0c6cf977992dafd8ebad8df CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
(In reply to BogdanB from comment #9) > You are testing with Print Preview. The bug reporter is testing using Print > (File - Print) and from there change Page Layout to Landscape. The confusion is understandable, giving the initial description. Only the screenshots attached later on allow a better understanding of where the problem resides. I changed the Subject/Title of the report in order to make it clearer, but it might not be enough, at least until the screenshots, or until comment 9.
Why, modifying in the print view, should modify the page style? https://help.libreoffice.org/latest/en-US/text/scalc/guide/print_landscape.html?DbPAR=CALC#bm_id3153418 In my opinion, it is not a bug. The print dialog it is not the place to change a style.
*** Bug 135687 has been marked as a duplicate of this bug. ***
(In reply to m.a.riosv from comment #11) > Why, modifying in the print view, should modify the page style? > https://help.libreoffice.org/latest/en-US/text/scalc/guide/print_landscape. > html?DbPAR=CALC#bm_id3153418 > > In my opinion, it is not a bug. The print dialog it is not the place to > change a style. The default/defined page style should only influence the Automatic orientation. It isn't necessary to update the default/defined page style. However, if the orientation is selected in the Print dialog, specifically for the current print, the chosen orientation should be displayed correctly and the chosen orientation should be printed correctly - exactly as it would have been if the orientation had been changed on the page style. This is the bug.
I confirmed this bug. I repro with Version: 7.5.0.1 (X86_64) / LibreOffice Community Build ID: 77cd3d7ad4445740a0c6cf977992dafd8ebad8df CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
*** Bug 162210 has been marked as a duplicate of this bug. ***