ONLYOFFICE / documents-app-android

GNU Affero General Public License v3.0
121 stars 26 forks source link

In spreadsheets, number formats are incorrect for British English #359

Open emes81 opened 1 month ago

emes81 commented 1 month ago

Screenshot_20240921-103225

British English does not (in fact, most varieties of English do not) use the same formats as American English. Use of the American formats in British English contexts is confusing or even misleading (2/8/24 is 2 August in the UK, but February 8 in the US).

As a result, most of the number formats in this screenshot are incorrect in British English. In the example in the screenshot, they should read:

Saturday 21 September 2024 21/09/24 10:32:22 1,234.56 £4,567.89

For more information, see: https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom

The currency sign always goes before the number: https://en.wikipedia.org/wiki/Pound_sterling

The 12-hour am/pm clock is widely used in spoken language and some other contexts, but the 24-hour clock is appropriate in most written contexts. See, for instance, this BBC TV schedule and these Premier League fixtures: BBC TV: https://archive.is/YjnS4 PL: https://archive.is/sIOtU

Andrew-Dudov commented 1 week ago

Hello @emes81 Thank your for your request. I created ticket 71176 with your bug.