Bug: Date formats in English: Onlyoffice does not respect OS locale settings

emes81 commented 1 year ago

This issue is unique.

[X] I have used the search tool and did not find an issue describing my bug.

Operating System

Windows 10 / 8.1 / 7

Version information

7.4.1.36

Expected Behavior

This is mainly an issue when using comments in text documents.

When the OS language is Australian English, British English, Irish English etc., dates on comments on OnlyOffice should respect that locale setting and appear as DD/MM/YYYY (e.g. today is 25/09/2023), with the 24h clock.

Actual Behavior

When the Onlyoffice interface language is set to English, the user's OS locale settings are ignored and US formats are used: dates in comments appear as MM/DD/YYYY, and time in AM/PM which either:

gives what is in most varieties of English a nonsense/impossible date: 09/25/2023 (there is no 25th month of the year!)
for the first 12 days of the month gives a a date like "03/07/2023" will seem correct to the user but will be read it as 3 July, when OO was actually trying to say March 7.

Reproduction Steps

Set OS language to non-US variety of English Set Onlyoffice interface language to English Write a comment: date of the comment will be shown with a date that is impossible or incorrect in the context of the user's OS language settings

Additional information

No response

TatianaKirillova commented 1 year ago

Hello, @emes81 .Thank you for report! Please check if the problem persists in version 7.5.1. I checked that the date format in the comments is displayed correctly, that is, for example, for Australian English the date format will be displayed as MM/DD/YYYY.

emes81 commented 1 year ago

I'll check when the version on the AUR for Arch Linux is updated (currently on 7.5.0-1).

Please note, MM/DD/YYYY is not the correct form for Australia (see: https://en.wikipedia.org/wiki/Date_and_time_notation_in_Australia). MM/DD/YYYY is correct only in American English - the issue is that the US format is incorrectly being used for other forms of English.

The correct format for Australian, British, Irish English etc. is DD/MM/YYYY.

TatianaKirillova commented 1 year ago

@emes81 Yes you are right! I created issue #65032 with your proposal

emes81 commented 8 months ago

I am currently on 8.0.1.31 (https://aur.archlinux.org/packages/onlyoffice-bin). OnlyOffice is still displaying dates incorrectly:

My system is set to British English. The date and time should read 15/01/24, 16:14.

emes81 commented 8 months ago

This is also still an issue in spreadsheets:

The input "4 jan 24" was correctly interpreted as a date, and is shown per the user-specified date format in the spreadsheet. However, in the entry bar, the date is shown as "1/4/2024", which for most users of English (native and non-native) means 1 April.

ONLYOFFICE / DesktopEditors