Ask Your Question
0

Using Swedish as Custom sort order LibreOffice Spreadsheet sort some characters in the wrong order.

asked 2020-10-26 12:18:42 +0200

RolBos gravatar image

LibreOffice does not seem to understand that characters V and W is regarded as the same character in the Swedish alphabet. For example the string 'Wa' is supposed to come before 'Vo' after sorting.

edit retag flag offensive close merge delete

Comments

2

This sounds like an information but not like a question. Are you trying to report a bug? If yes - report here: https://bugs.documentfoundation.org/

However: https://sv.wikipedia.org/wiki/Svenska_alfabetet tells: W ansågs allmänt som en variant av V fram till 2006 då Svenska Akademien i den trettonde upplagan av Svenska Akademiens ordlista över svenska språket började sortera W som enskild bokstav.

Opaque gravatar imageOpaque ( 2020-10-26 12:29:31 +0200 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2020-10-26 13:57:58 +0200

keme gravatar image

updated 2020-10-26 14:11:13 +0200

"Svenska Akademiens ordlista över svenska språket", which AFAIK is the authoritative reference for the Swedish language, separated V and W in the 2006 edition. I should think that this implies a new rule. V is before W, not equivalent.

To force the old sorting on a table, you can make a helper column where you replace every occurrence of W with V, and sort on that.

If the sort column is A, try =SUBSTITUTE(UPPER(A1);"W";"V") and copy down.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-10-26 12:18:42 +0200

Seen: 48 times

Last updated: Oct 26 '20