Sort order in alphabetical index in localized LibreOffice

Hi

I removed a previous version and installed LibreOffice version 4.0.2.2 on Linux Ubuntu 10.04 from ppa:libreoffice/libreoffice-4-0. I also installed the Esperanto language pack (libreoffice-l10n-eo). The spell checker works for Esperanto. In ordinary tables the sort order (Tools > Sort...) works correctly.

I am editing a translation of the user guide GS4002-SettingUpLibreOffice.odt. I created an alphabetical index at the end of the document to check that I had translated all the anchors and cross-references. It sorts the entries into a wrong order. The document language is set to Esperanto and the language of the index is set to Esperanto. Here is an extract from the last part of the index. Note that ĝ should go after g, ŝ after s. Why do they, and presumably other accented letters, go between v and x?

tiparo

anstataŭigoj 13

aspekto 8

historio 8

tondejo 9

vortarojn instali 25

ĝenerale

apriora dosiera formato

ODF-formato, versio de 21

OpenDocument Format 21

Optimumigi la grandon 21

Ĉiam konservi kiel 21

Apriora dosiera formato kaj ODF-agordoj 21

AŭtomataRiparo 21

Konservi informon pri Aŭtomata Riparo post ĉiu__Minutoj 21

Konservi URL-ojn relative al dosiera sistemo / Interreto 21

Redakti dokumentajn atributojn antaŭ konservado 20

Ĉiam krei restaŭran kopion 21

Ŝargi presilajn agordaĵojn kun la dokumento 20

Ŝargi proprajn agordaĵojn kun la dokumento 20

Ŝargi/Konservi

Konservi originan Basic-kodon 22

Microsoft Office-dosierokonvertado 22

Rulebla kodo 22

Tiparaj grandoj 24

VBA-atributoj, ŝargi/konservi 22

Ŝargi Basic-kodon 22

XML-dosieroj

Do other languages have this problem?
Is it to do with the locale definition? (If so why does it sort ordinary tables correctly?)

Regards
Donald Rogers

Just checked with plain calc sheet, entered whole croatian alphabet and sorting is ok except "dž" (number 7) should be before "đ" (number 8).

1 a
2 b
3 c
4 č
5 ć
6 d
8 đ
7 dž
9 e
10 f
11 g
12 h
13 i
14 j
15 k
16 l
17 lj
18 m
19 n
20 nj
21 o
22 p
23 r
24 s
25 š
26 t
27 u
28 v
29 z
30 ž

Didn't understand second part of your message, so didn't check that. :slight_smile:

Best regards,
Mihovil

Dana 19.5.2013. 4:31, Donald Rogers je napisao:

Hi Donald,

I am editing a translation of the user guide
GS4002-SettingUpLibreOffice.odt. I created an alphabetical index at
the end of the document to check that I had translated all the
anchors and cross-references. It sorts the entries into a wrong
order. The document language is set to Esperanto and the language of
the index is set to Esperanto. Here is an extract from the last part
of the index. Note that ĝ should go after g, ŝ after s. Why do they,
and presumably other accented letters, go between v and x?

For Writer's index tables a special sequence is considered, the locale
data's IndexKey element. In i18npool/source/localedata/data/eo.xml that
is

    <IndexKey unoid="alphanumeric" default="true" phonetic="false">ABCĈDEFGĜHĤIJĴKLMNOPRSŜTUŬVZ</IndexKey>

to me the order looks correct according to your statement (btw, does
Esperanto not have the letters W, X and Y?). If it worked before in
earlier versions it would be a regression, could you check that? But it
might be that it never worked for Esperanto. Please file a bug and set
me on Cc.

Thanks
  Eike

Hi,

I noticed that in Slovenian LO, will check again and report here, in
Slovenian the problem was that special letters č, š and ž get at the
end of alphabet (and not č after c, š after s and ž after z). If this
is true then maybe sorting for more non-English languages is not
working ...

Lp, m.

Hi Martin,

I noticed that in Slovenian LO, will check again and report here, in
Slovenian the problem was that special letters č, š and ž get at the
end of alphabet (and not č after c, š after s and ž after z). If this
is true then maybe sorting for more non-English languages is not
working ...

Hum.. that should not happen.. sl_SI.xml:

    <IndexKey phonetic="false" default="true" unoid="alphanumeric">A-C Č Ć D Đ E-S Š T-Z Ž</IndexKey>

Just to make sure, we are talking about Writer's index feature here, not
general sorting, yes?

  Eike

Yes. It's what you get on the menu in Writer:
Insert > Indexes and tables > Indexes and tables > Type = Alphabetical index

Donald