Hi, the current collation rules for Catalan languages are wrong. LibO Calc sorts "ch" and "ll" as different letters, that is not correct in Catalan. How to reproduce (with Catalan language defined) 1.- Input this cells in LibO Calc: cà çà ca ça cdà cda chà cha cià cia dà da là la l·là l·la llà lla lmà lma 2.- Sort this cells by ascending order (in Catalan) 3.- Expected results: ca ça cà çà cda cdà cha chà cia cià da dà la là lla l·la llà l·là lma lmà 4.- Current results: cà ca ça çà cda cdà cia cià cha <--- wrong chà <--- wrong da dà la là lma lmà l·la <-- wrong lla <--- wrong l·là <--- wrong llà < --- wrong
Sorry, some references: Current ICU 4.6 Catalan collation rules http://demo.icu-project.org/icu-bin/locexp?_=ca&d_=ca&x=col Official rules for sorting from IEC (Catalan Academy)in Catalan, second page. http://www.iecat.net/institucio/seccions/Filologica/gramatica/default.asp
This works well in ICU version 4.6, but not in version 4.0.1 which is the internal one. So I guess the options are: 1. Update ICU to 4.6 2. Patch the current internal version.
The current source/data/coll/ca.txt file in our internal ICU should be updated with this newer version: http://source.icu-project.org/repos/icu/icu/trunk/source/data/coll/ca.txt
It can be fixed in http://opengrok.go-oo.org/xref/libs-gui/i18npool/source/collator/data/, too. It would also work with older system ICU libraries.
Fixed in master branch: http://cgit.freedesktop.org/libreoffice/libs-gui/commit/?id=affa15b894b66b3d12d00ab1ad3c567ade88800e