Description: Hello. If you are an Excel user, you can convert the Gregorian date to the Iranian date (Jalali Calendar or Iranian Calendar) with just the following snippet of formula. [$-fa-IR,96] yyy/mm/dd Please add this feature to the LibreOffice spreadsheet as well. Actual Results: . Expected Results: . Reproducible: Always User Profile Reset: No Additional Info: .
If I understand it correctly, *and* if Wikipedia has it correctly, there is no such specific thing as "the Iranian Calendar", but a group of different "Iranian Calendars" [1]. Jalali was one of them [2], and it was *not* implemented in Excel, but Solar Hijri calendar [3] - another calendar, different from Jalali - was [4] (which was mixed with Jalali in the article/question). In LibreOffice, there is support for various calendars [5]; it lists "Hijri", but AFAIK, it is the Lunar Hijri (Islamic calendar) [6]. So the questions here are: 1. Which specific calendar should be supported out of the different calendars? What I wrote was just an outsider's speculations based on some googling. A reference to the exact authoritative algorithm how it is calculated would be great. 2. Should the MS syntax for the extended codes be adopted? 3. Correct existing mentions of Hijri in out documentation to refer to Lunar Hijri. [1] https://en.wikipedia.org/wiki/Iranian_calendars [2] https://en.wikipedia.org/wiki/Jalali_calendar [3] https://en.wikipedia.org/wiki/Solar_Hijri_calendar [4] https://answers.microsoft.com/en-us/outlook_com/forum/all/how-to-set-jalali-shamsi-as-defaultalternative/8a893d5d-f80d-4082-9dde-40572bd6bd79 [5] https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html?DbPAR=SHARED#hd_id3149929 [6] https://en.wikipedia.org/wiki/Islamic_calendar
This is a valid request, but before it can be implemented, Jalali calendar should be supported in LibreOffice, which is filed as bug #147660. For clarification, the Wikipedia article cited above as citation [1] tried to capture history of all the calendars used in Iran, but to be precise, Iran's official calendar is Solar Hijri. It should be noted that in the Iranian calendar, there are several holidays and events that are from Lunar Hijri and Gregorian calendar.