Ordering Spreadsheet Functions in the PT version of LO. How to achieve it?

l10n
#1

Hello friends

I wonder if someone can help me out, since maybe this relates to
programming/developing.
I am translating the Help files for the Portuguese (PT) version of
LibreOffice, and I noticed we can't sort alphabetically some pages
with function lists.
For a short example, the "Spreadsheet Functions" Help page shows in
the English version the following natural order:

ADDRESS
AREAS
DDE
ERRORTYPE
INDEX
INDIRECT
...

While the Portuguese version reads after translation:
ENDEREÇO
ÁREAS
DDE
TIPO.ERRO
ÍNDICE
INDIRETO
...

Obviously, the intended presentation in PT language should be its own
natural alphabetical order, as follows:
ÁREAS
DDE
ENDEREÇO
ÍNDICE
INDIRETO
TIPO.ERRO
...

Now my question: how can we achieve this natural order?
Should I change anything in the <bookmarks_value> tags? Is it
something to do with some internal xml tags, such as name="..." or
<node...>, etc?

Do you know how can I force the Help page to display everything in the
proper alphabetical order in my language?

Should I reorder the whole lines in the relevant PO file? I am afraid
to do that, since I might break the build. :slight_smile:

Thanks a lot in advance for any expert help.

regards
Carlos Moreira
LibreOffice PT translation team

#2

Hello Carlos,

2011.07.04. 13:43 keltezéssel, Carlos Moreira írta:

Now my question: how can we achieve this natural order?
Should I change anything in the <bookmarks_value> tags? Is it
something to do with some internal xml tags, such as name="..." or
<node...>, etc?

Do you know how can I force the Help page to display everything in the
proper alphabetical order in my language?

Should I reorder the whole lines in the relevant PO file? I am afraid
to do that, since I might break the build. :slight_smile:

It is not possible to sort these entries. It would be possible to write
a program that sorts these in build time. By the way in English the list
is also not in alphabetical order. You cited only the first 6 entries
which are.

ADDRESS
AREAS
DDE
ERRORTYPE
INDEX
INDIRECT

then:
COLUMN
COLUMNS
VLOOKUP
SHEET
SHEETS
MATCH
OFFSET
LOOKUP
STYLE
....

Best regards,
Andras