Option is question is: Tools / Options / LibreOffice Calc / Sort Lists For croatian locale there are pre-defined sort lists and one of those is "short weekdays": pon, uto, sri, čet, pet, sub, ned If I: 1. Add custom sort list: PON, UTO, SRI, ČET, PET, SUB, NED 2. Enter into A1 cell: PON 3. Grab A1 cell by bottom right corner and pull in to A7. I will get this result: PON uto sri čet pet sub ned It always uses first predefined sort list.
Nobody confirmed this bug report independently. Set status back to UNCONFIRMED. Not sure that it is a bug. If sort lists were case sensitive you would have to create sort lists for each combination of maj/min. Best regards. JBF
It's a bug, as Excel supports lower-, title- and uppercase for custom lists.
Confirmed that this is a bug. Old version of LO and OOo allows both lists of days in Uppercase and lowercase. Can't remember when this change happened...
Should bug importance be changed from "enhancement" back to "normal" then, and maybe tag "regression" added? Is there a download page with old windows portable versions available? Would like to test, but don't want to fully install old versions.
Created attachment 107732 [details] Test with LibreOffice 3.3.0.4 Managed to find LibreOffice 3.3.0.4 portable version for windows. As far as I can tell, this version didn't support case sensitive sort lists also. Check picture. And to answer my own question, arhive with old versions, even portable ones: http://downloadarchive.documentfoundation.org/libreoffice/old/
Any divergence from Excel functionality is a serious bug, not an 'enhancement'.
Sahas committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ef6ddb36751f917cd4ddab4a7fc609d5cf212b1b tdf#79983 - Fix to make calc sort lists case sensitive It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7aba9dcf13ac464acfcfe3cba7b2e5918790ce0e a vector is unnecessary here, tdf#79983 follow-up It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thank you, seams fixed! Eike, can you please take a look at blocker bug and point me to whom I can send new default sort lists for my locale?
1. we don't have blocker bugs, you mean blocked bug ;-) 2. no need to hijack this bug, putting me on Cc of the other bug is sufficient
Zdeněk Crhonek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b75fde430a01fc165e69ccf437fbc262fcfc1926 uitest for bug tdf#79983 It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.