Description: When sorting columns containing Persian (a.k.a Farsi) text in ascending order, the Persian letter Heh 'ه' is placed before letter Waw 'و', which is incorrect while in the correct order 'و' must be before 'ه'. The bug probably affects similar languages like Arabic because the same order of letters are there too. Steps to Reproduce: 1. Type the letter 'ه' in a cell. 2. Type the letter 'و' in the next cell in column. 3. Sort the column in ascending order. Actual Results: 'ه' is placed before 'و' Expected Results: 'ه' must be after 'و' Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.2.2 Build ID: 00(Build:2) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.0.2~rc2-0ubuntu0.20.04.2 Calc: threaded
Repro NixOS Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 67e47070a7580a17804adce812cc2f98bfe7b51f CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: x11 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded
Seen in Linux bibisect repos 6.3, 41max, 43all. Assuming inherited.
I know nothing about Persian or Arabic, but it seems from a Persian MS Office user [1] that Persian and Arabic indeed have slightly different alphabetical order, and MS Office exhibits a similar problem for Persian users. 1. https://answers.microsoft.com/en-us/msoffice/forum/all/persian-alphabet-or-arabic-alphabet/1930e610-6439-4858-94bc-833aad8c61b5
(In reply to Ming Hua from comment #3) > I know nothing about Persian or Arabic, but it seems from a Persian MS > Office user [1] that Persian and Arabic indeed have slightly different > alphabetical order, and MS Office exhibits a similar problem for Persian > users. > > 1. > https://answers.microsoft.com/en-us/msoffice/forum/all/persian-alphabet-or- > arabic-alphabet/1930e610-6439-4858-94bc-833aad8c61b5 I checked the Arabic alphabet and you are correct. In Arabic alphabet the letter 'و' comes after 'ه'. So this bug only affects Persian language.
Dear MohammadReza Hosseini, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
The bug is still present. Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 12; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3 Calc: threaded
Please attach a document with a list of example words that show the error when sorting, but do not actually sort it. Please use a daily build for testing, as there have been some recent improvements to the Sort dialog. When testing, make sure that you have selected "Persian" in the section Locale on tab Options of the Sort dialog. Do not use "Default - ...", because that is not written to the file. Please look at https://icu4c-demos.unicode.org/icu-bin/collation.html and test your list of words there.
Created attachment 203867 [details] test words in incorrect sorting order Attached is a list of words in incorrect sorting order.
Using "Sort" dialog and setting language to "Persian" on tab Options, the sorting order is correct. Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 12; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4 Calc: threaded
(In reply to MohammadReza Hosseini from comment #10) > Using "Sort" dialog and setting language to "Persian" on tab Options, the > sorting order is correct. > > > Version: 24.2.7.2 (X86_64) / LibreOffice Community > Build ID: 420(Build:2) > CPU threads: 12; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) > Locale: en-US (en_US.UTF-8); UI: en-US > Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4 > Calc: threaded So is there a problem even in 24.2? It's not clear from your reaction. If there is still a problem, please do as Regina says and use a fresh 26.2 build: https://wiki.documentfoundation.org/Installing_in_parallel/Linux#Automated_installation Or do it manually https://wiki.documentfoundation.org/Installing_in_parallel/Linux#Manual_installation https://dev-builds.libreoffice.org/daily/master/current.html