Ask Your Question

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



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

However: 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

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


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

Seen: 48 times

Last updated: Oct 26 '20