Description: Open test.xlsx file. It is set up to be a landscape page (See Format - Page Style) Print to virtual printer like PDFCreator, different times. Sometimes will be printed as portrait. Steps to Reproduce: 1. Open the test.xlsx file and print it different times to a virtual printer. Actual Results: Sometimes is landscape, sometimes is portrait Expected Results: Always is landscape like it was set up Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: ro-RO (en_US); UI: en-US Calc: threaded
Created attachment 197848 [details] test file
Created attachment 197849 [details] how it should look always
Created attachment 197850 [details] how is looking sometimes In my case now in the third try I was getting a portrait version of the landscape file.
Printer to 'Microsoft Print to PDF' about ten times, always landscape. Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
I want to test on Tuesday morning at work, if I omitted to reset the user profile. I reset from 24.8.1 to 24.8.2, but I am not sure if I did the same between 24.8.2 and 24.8.3.
Works as expected (landscape worksheet rotated by 90° to fit on portrait page) on macOS Version: 24.8.2.1 (AARCH64) / LibreOffice Community Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 CPU threads: 8; OS: macOS 15.1.1; UI render: default; VCL: osx Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded Comment: I've always found the default behaviour of LO 'page layout' counter-intuitive. Changing the Page settings doesn't just affect the active worksheet, it seems to redefine the default style and hence every worksheet. I get round this by defining 'Landscape A4' and 'Portrait A4' custom page styles and applying these to each worksheet as appropriate. but I'm not sure whether this an orthodox method.
About your last comment, I played now a little bit, and I think the current behavior is correct. If I have 100 sheets, similar content, I want all of them to be the same. If I need a landscape setup, I just change the page style for certain sheets.
I tested now on Linux. The same problem. If I export directly as PDF is perfect. But, if I go to File - Print - and choose a virtual printer, or on Linux: print to file, and I save as PDF, the result is portrait. Version: 25.2.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 34a63a22df48ee5aef35fde502aa59d5207fbdd9 CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Created attachment 197879 [details] video testing the bug
In fact, I played a little more: just switching printers and the landscape/portrait is changing. By default, I have a printer: the preview is landscape. Choose "print to file": the preview is still landscape, but some settings in the page are changing, for example "Paper size" is gone, nothing displayed. Now, change again to default printer: the preview is portrait.
I'm confirmed. test with repro Version: 25.2.0.1 (X86_64) / LibreOffice Community Build ID: ddb2a7ea3a8857aae619555f1a8743e430e146c9 CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: ja-JP (ja_JP); UI: en-US Calc: CL threaded not repro Version: 24.8.4.2 (X86_64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: en-US Calc: CL threaded bisected Maybe this is the branch point. https://git.libreoffice.org/core/+/f736e3a0c23acf908462bfd184e1224c78244224%5E%21
Forget comment 11, that's a different bug. repro Version: 24.8.4.2 (X86_64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: threaded not repro Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: ee3885777aa7032db5a9b65deec9457448a91162 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: threaded bibisected https://git.libreoffice.org/core/+/a67cd7b3cf03163f87811f7080cabc49750c4fd5%5E%21
Tibor, can you take a look?
*** Bug 165926 has been marked as a duplicate of this bug. ***
*** Bug 166515 has been marked as a duplicate of this bug. ***