Description: Position of number of day is not true. Steps to Reproduce: 1.Insert → Date (Ctrl+;) → Ctrl+1 2.I select Date Category and اسفند۳۱ Format, but into preview box shows ۳بهمن While بهمن۳ should be shown, that is, first the day and then the name of the month should be shown. 3. Actual Results: the number ۳ should be displayed on the right side of the cell and then the name of the month (بهمن). Expected Results: the name of month ۳ should is displayed on the right side of the cell and then the number of day (بهمن). Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fa-IR (en_US.UTF-8); UI: en-US Ubuntu package version: 4:7.6.2~rc1-0ubuntu0.22.04.1~lo1 Calc: threaded
Created attachment 190651 [details] Date format
Created attachment 190652 [details] What it should be
it works correctly in ar-DZ locale, so it looks like a Farsi specific bug.
I'm sorry for my mistake. Actual Results: The number of the day (۳) gets displayed on the left side of the name of the month (بهمن). Expected Results: The number of the day (۳) must get displayed on the right side of the name of the month (بهمن).
See also initial analysis at https://ask.libreoffice.org/t/date-position-into-cell/97797/8
(In reply to Eike Rathke from comment #5) > See also initial analysis at > https://ask.libreoffice.org/t/date-position-into-cell/97797/8 Arabic-Indic digits (used in Arabic) and Extended Arabic-Indic digits (used in Persian) have different BiDi properties, but it should matter hear only if the base text direction is LTR, compare these two: https://util.unicode.org/UnicodeJsps/bidi.jsp?a=%DB%B3+%D8%A8%D9%87%D9%85%D9%86%0D%0A%D9%A3+%D9%86%D9%88%D9%81%D9%85%D8%A8%D8%B1&p=RTL https://util.unicode.org/UnicodeJsps/bidi.jsp?a=%DB%B3+%D8%A8%D9%87%D9%85%D9%86%0D%0A%D9%A3+%D9%86%D9%88%D9%81%D9%85%D8%A8%D8%B1&p=LTR Which suggests that the cell direction is LTR. Indeed, if I enter the strings manually (not as dates) and make the cell direction RTL, both strings render with the digit at the right. But when they are dates, changing cell direction makes no difference.