Found an answer to at least ONE of my questions, se further down:
Johnny Andersson <[EMAIL PROTECTED]> skrev den Fri, 25 Mar 2005 21:32:35 +0100:
Hi!
I am not sure about if I should send a bug report or not. Here's the story:
A while ago, maybe when the latest OOo was 1.1.1 or something, I noticed that Scandinavian letters were sorted incorrectly. They were sorted something like this:
aäåæbcdefghijklmnoöpqrstuvwxyz, so I said to myself that it's obvious that the person who did this thought that åäö are aao with dots and rings added and should be sorted like the dots and rings are not there. That is, however, wrong. ÅÄö etc are real letters and they are at the end of the Scandinavian alphabets, like this:
Swedish/Finnish: ...xyzåäö Norwegian/Danish: ...xyzæøå
I filed an issue report and when the next version, probably 1.1.2, was released I made the test again. First I tried with the laguage set to Swedish, filled some cells in Calc with some rubbish and sorted. Yes! ...XYZÅÄÖ, perfect! Then I switched to Danish and resorted: ...XYZÄÖÅ! Perfect!
Now I run 1.1.4 and something happened. It still works perfect in Swedish, I get the same sorting order in Danish as in Swedish...
Hm... Strange sentence... should be "...BUT I get the same..."
However, I experimented some more with it and suddenly the sorting order was Danish, even when Swedish were selected. More experimenting gave me the fact that I have to restart OOo when I switch languages before the new sorting order is active. I don't remember that I hade to do that with 1.1.2!
I wonder why that is. Could it have anything to do with that I hade some kind of a danish dictionary installed in 1.1.2, which I don't have now? When I selected Danish the currency immediately switched to DKK which is correct, so somehow OOo seems to know what Danish is...
Well, since I am Swedish I could just don't care about it and wait until someone from Norway or Denmark find the same thing and file an issue about it, so over to my next obervation:
Yes, because I found the reason for the strange behaviour above, so don't bother about that anymore. However the following is still relevant, I think:
I made the following macro, just to see how strings can be compared for sorting purposes (I am a macro beginner):
Sub CompStrings Dim A,B As String A="Ärlig" B="Åke" If A>B Then Print B+", "+A Else Print A+", "+B End If End Sub
Then I manually changed the values of A and B, just to verify that the sorting order is correct. Do you think it was? Of course not... ;D
So in BASIC it seems to be ...XYZÄÅÖ. I don't think I have ever seen that one before... I am just about to file an issue about it, but now I don't know... I mean that I filed that SWE/FIN + DEN/NOR issue some years ago and it was corrected, but now DEN/NOR is wrong again but not in the same way as it was wrong before... so is there really a point to file issues? I guess I can do it and just see what happens. I least I did what I could do...
Johnny
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
