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.
