Bug 159939

Summary: Calc print dialog showing metric page size when system set to imperial sizes
Product: LibreOffice Reporter: bunkem <bunk3m>
Component: LibreOfficeAssignee: Not Assigned <libreoffice-bugs>
Status: UNCONFIRMED ---    
Severity: normal CC: armlopez, robert
Priority: medium    
Version: 24.2.0.3 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Style Page Style showing imperial measurments
Screensho showing printer dialog showing metric page size
Options-Preferences showing imperial measurement (inch)
English_UK_settings

Description bunkem 2024-02-28 15:25:54 UTC
Description:
When printing to PDF or printer, LO Calc's print dialog box is showing the correct page size (in this case Letter) but shows all measurements in metric rather than the imperial (inch) measurement system selected in LO and also the system default of imperial on Windows.

Steps to Reproduce:
1.Set system default to inches (imperial)
2.Set LO preferences/options to show inch in all options including LO Calc
3.Open an xlxs or ods spreadsheet in Calc
4.Press Printer button or File:Print with a spreadsheet open.
5.Note that the Page Layout dialog box shows Letter 216mm x 279mm.

Actual Results:
Page Layout dialog box shows Letter 216mm x 279mm.

Expected Results:
Page Layout dialog box shows Letter 8.5in x 11in.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 24.2.0.3 (X86_64) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded
Comment 1 Armondo Lopez 2024-04-16 03:34:02 UTC
I was unable to reproduce this behavior in

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

or

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 2 bunkem 2024-04-18 14:42:04 UTC
Created attachment 193744 [details]
Style Page Style showing imperial measurments
Comment 3 bunkem 2024-04-18 14:42:38 UTC
Created attachment 193745 [details]
Screensho showing printer dialog showing metric page size
Comment 4 bunkem 2024-04-18 14:44:51 UTC
Created attachment 193746 [details]
Options-Preferences showing imperial measurement (inch)
Comment 5 bunkem 2024-04-18 14:45:46 UTC
Not sure why you can't see this.  Please see attached screenshots.  The screenshots are with present version on Windows 11

Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded
Comment 6 Robert Großkopf 2024-04-19 06:48:02 UTC
@bunkem: How did you get page layout showing in inch? I only get cm here.

Might be this is a mesurement of your whole system, not of LibreOffice. This could only be shown in listboxes, which will reproduce this measurement. It won't be shown in a text content like the page layout information in print dialog.
Comment 7 bunkem 2024-04-21 18:57:25 UTC
@Robert: I'm not sure.  My system is set up to Imperial (inch) measurements and I've changed all the user settings for Writer, Calc, Impress, Base to be Imperial (inch) also.

In all the other dialog boxes in LO, the measurement system is inch.  So it was just very strange to find metric in the print dialog.
Comment 8 QA Administrators 2024-04-22 03:15:33 UTC Comment hidden (obsolete)
Comment 9 Steve271 2024-05-24 03:48:06 UTC
Created attachment 194320 [details]
English_UK_settings
Comment 10 Steve271 2024-05-24 03:51:18 UTC
I was able to replicate the metric page sizes shown in the 2nd screenshot by going to :

Tools > Options > Languages and Locales > General


I then set the following settings:

Language Of 
    User interface: English (UK)

Formats
    Locale setting: English (UK)

Default Languages for Documents
    Western: English (UK)


after confirming that I got the exact same print Letter 216mm x 279mm screen I changed those 3 settings to English (USA) and I got Letter 8.5in x 11in. 

bunkem check the settings to see if they are correct
Comment 11 bunkem 2024-05-24 21:15:45 UTC
Thank you for having a look @Steve271

I have the following settings in Locale & Languages

User interface: Default - English (USA)
Locale setting: English (Canada)
Default language for documents: Western English (Canada)

I suppose that brings up the likely issue.

For some reason people think that Canada locale is metric paper, which it isn't.  Canada uses metric mostly, but not for paper.  We also use three or four different ways of showing the date (top three are: US MM/DD/YY; DD-MM-YYYY; YYYY-MM-DD).  It kind of makes your head spin but you get used to it.  In any case, you will never, ever, find a ream of A4 paper in any stores except by special order.  OK, apparently the Canadian government is using A4 but I've never seen it.

===off topic rant===
I've noticed the same thing with NextCloud.  The settings for Canada are all screwed up and so importing the Canada holidays calendar into NextCloud doesn't work if you chose UK English because I don't use US date formats.  There is no setting for what we actually use.  Another bug report for Nextcloud.
===rant off===

In any case, my Mac has system setting to use imperial measurements for applications because we use letter paper (i.e. 8 1/2 x 11" ) in all apps.

Libreoffice should pick this up from the system and also show the letter paper size in the print dialog ... not some metric equivalent.   No one here will know what that metric size means.