Description: in format cell higri calendar in calc is good but persian calendar don't correct in calc it just replace month number with month name Steps to Reproduce: 1.insert now() function in cell 2.right click and select format cell 3.select persian Actual Results: ۱۷ آبان ۲۰۲۱ Expected Results: ۲۵ مرداد ۱۴۰۰ Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: "آبان" is 8th month but now is 5th month
Created attachment 174338 [details] format cell
persian- jalali - or solar calendar https://en.wikipedia.org/wiki/Solar_Hijri_calendar
First, it should be said that the sample data for Persian in the 'Format Cell' dialog is wrong. Esfand is the last month of the Jalali calendar for each year, and it is either 29, or 30 (leap year). Thus, '۳۱ اسفند' which means '31 Esfand' is wrong in the first place. Other than that, choosing Persian in "Format Cell > Numbers" leads to a whole set of different wrong results. Either ###, or using the name of the 2nd month of Jalali instead of 2nd month of Gregorian calendar, or displaying the date from Gregorian calendar with Persian numerals. It should be noted that currently the Jalali calendar is not implemented in LibreOffice. This problem is reproducible with: LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735 OS: Linux 5.13; UI render: default; VCL: gen Version: 7.3.0.3 / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 237a5e5121a6f12981eb6e4c5a138fc8cfa1c3cf CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded