Description: When I type numbers with slash / in Right To Left direction like date, The numbers appears from left to right. This behavior is wrong because we are read the date or any numbers with slash from right to left in Arabic this bug tested in: Version: 5.4.5.1 Build ID: 79c9829dd5d8054ec39a82dc51cd9eff340dbee8 CPU threads: 4; OS: Windows 6.1; UI render: default; Locale: en-US (en_US); Calc: group Version: 6.0.4.2 (x64) Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 4; OS: Windows 6.1; UI render: default; Locale: ar-JO (en_US); Calc: group Version: 6.1.0.0.beta1 (x64) Build ID: 8c76dfe1284e211954c30f219b3a38dcdd82f8a0 CPU threads: 4; OS: Windows 6.1; UI render: default; Locale: ar-SY (en_US); Calc: group Steps to Reproduce: 1.tools - language settings - languages - set locale setting: Arabic ,then ok and restart office 2.press Ctrl+Shift+D OR Right-to-left icon to set RTL direction. 3.type 13/6/2018 or any numbers with slash Actual Results: the numbers appears from left to right Expected Results: numbers must appears from right to left Reproducible: Always User Profile Reset: Yes Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
Created attachment 142694 [details] screenshot for the correct and wrong direction
I tested this bug in kubuntu linux 18.4 & kde neon. because that I change operating system from Windows to all
That is the expected, by the spec, behavior of the slash characters with numbers. It might be unfortunate, but that what the Unicode Bidirectional Text algorithm mandates. MS Office is known to not follow the spec here.
thank you khaled
>>MS Office is known to not follow the spec here. It is the right thing to do BTW.
(In reply to Fahad Al-Saidi from comment #5) > >>MS Office is known to not follow the spec here. > > It is the right thing to do BTW. The good thing about specs is that everyone follows them, otherwise copying text from another application (e.g. your web browser or text editor) is suddenly rendered differently. It is not that hard to type the date in the order you want, BTW: ١٢/٣/١٩٧٨ is no easier than ١٩٧٨/٣/١٢.
(In reply to Khaled Hosny (inactive) from comment #3) > That is the expected, by the spec, behavior of the slash characters with > numbers. It might be unfortunate, but that what the Unicode Bidirectional > Text algorithm mandates. MS Office is known to not follow the spec here. What about when you just have a slash after a few digits with no other digits afterwards? i.e. the line is set to RTL, and let's say I even entered some strongly-RTL characters; then a space; then some digits; and now I type a slash. What does the UBA say about where that slash is supposed to appear?
(In reply to Eyal Rozenberg from comment #7) > (In reply to Khaled Hosny (inactive) from comment #3) > > That is the expected, by the spec, behavior of the slash characters with > > numbers. It might be unfortunate, but that what the Unicode Bidirectional > > Text algorithm mandates. MS Office is known to not follow the spec here. > > What about when you just have a slash after a few digits with no other > digits afterwards? i.e. the line is set to RTL, and let's say I even entered > some strongly-RTL characters; then a space; then some digits; and now I type > a slash. What does the UBA say about where that slash is supposed to appear? You can try it yourself here https://unicode.org/cldr/utility/bidi.jsp.