https://bugs.documentfoundation.org/show_bug.cgi?id=148428
Bug ID: 148428 Summary: LibreOffice Calc Vs MS Excel Dhivehi Calendar Issues Product: LibreOffice Version: 7.3.2.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: minor Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: adam7...@gmail.com Description: First of all, I congratulate and commend LibreOffice’s performances and contributions to the Opensource community. And I don't honestly believe this to be a bug but amiss of including some locale definitions. I've made a huge sheet which calculates durations based on dates and it uses DATEDIF(), DAYS() and simple arithmetic operators to get the results. I started it on MS Excel and it works fine. However, after coming across LibreOffice I'm trying to completely switch from MS to LibreOffice. However, one thing is stopping me which is why I'm writing this. All my MS Excel calculations are correctly displayed in LibreOffice Calc, except the displaying of month names in English and not in Dhivehi although LibreOffice can detect the Maldives language Dhivehi. It seems that the Dhivehi names of weekdays and months of Gregorian calendar in Thaana script are not included. Also, need to include the Hijri calendar particulars for same as the Maldives is the only 100% Muslim country after Saudi Arabia in the world. Steps to Reproduce: 1. Include the Dhivehi names of weekdays and months of Gregorian calendar in Thaana script. 2. Include the Dhivehi names of weekdays and months of Hijri calendar in Thaana script. Actual Results: 1. In MS Excel blank sheet, enter a date in any language. 2. Copy the same date to another cell. 3. Set the first date's locale to Dhivehi and calendar type to Gregorian by going to the Format Cells dialog box. 4. Set the second date's locale to Dhivehi and calendar type to Hijri by going to the Format Cells dialog box. 5. Save the MS Excel file and exit MS Excel. 6. Open the saved MS Excel file in LibreOffice and see if your dates are correctly displayed in the set locales and with the latest set calendar type. 7. Sure, as it can be, you won't see it. And that why this little work is important to be done. Expected Results: The user would expect the same locale and calendar type to be intact no matter which spreadsheet application the user is opening his/her work. Reproducible: Sometimes User Profile Reset: Yes OpenGL enabled: Yes Additional Info: If you require any more information or contributions I shall be willing to respond to the best of my ability. Please reach me via: adam7...@gmail.com I've already prepared a PDF of the confusions this issue may produce in a comparative display of the results in the two applications. -- You are receiving this mail because: You are the assignee for the bug.