Bug 153218

Summary: Errors when entering fractions in Russian locale
Product: LibreOffice Reporter: Mike Kaganski <mikekaganski>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: erack, stephane.guillou
Priority: medium    
Version: 6.1.0.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 111942    

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