Bug 153218 - Errors when entering fractions in Russian locale
Summary: Errors when entering fractions in Russian locale
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: User-Locale
  Show dependency treegraph
 
Reported: 2023-01-26 11:26 UTC by Mike Kaganski
Modified: 2023-01-26 13:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2023-01-26 11:26:58 UTC
Using Version: 7.5.0.2 (X86_64) / LibreOffice Community
Build ID: c0dd1bc3f1a385d110b88e26ece634da94921f58
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL threaded

so the UI is en-US, but the locale is ru-RU
I try to enter this:

2/3

and it accepts it as a *text*. This is the problem #1 (why? the entry doesn't conflict with the default date acceptance pattern of "D.M.Y;D.M.;D/M/").

Then I try

0 2/3

and get "2/3", as wanted. But if I try

0 123/4

I get unexpected "123" (while the cell is auto-formatted as "# ?/?"). This is the problem #2, which *maybe* relates to the space being thousands separator?

When I pre-format the cell to use en-US in its number formats, it works as expected (123/4, as well as 0 123/4, both give 30 3/4).
Comment 1 Stéphane Guillou (stragu) 2023-01-26 13:22:09 UTC
Reproduced as described, except for 123/4 in en-US number formatting: it also displays as a string ("123/4", left-aligned).

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: e125e6623fa1c0f39d927bb37547ca6d1e299cb1
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: ru-RU (en_AU.UTF-8); UI: en-US
Calc: threaded

Same in:

Version: 6.1.0.3
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; 
Locale: en-AU (en_AU.UTF-8); Calc: group threaded