Hello,
in Spanish, sorting a list, words starting with are supposed to follow words starting with N; for instance Nina is followed by ina
Yet, when I sort a list box, words starting with precede words starting with N: ina is followed by Nina.
Any suggestion how to fix the problem? Thanks.
Here is my CompareRows event:
[code]Function CompareRows(row1 as Integer, row2 as Integer, column as Integer, ByRef result as Integer) As Boolean
soft declare function CFStringCompare lib “Carbon.framework” ( s1 as CFStringRef, s2 as CFStringRef, opt as UInt32 ) as integer
dim options as UInt32 = 193//800//1 + 128 + 512 //kCFCompareCaseInsensitive || kCFCompareDiacriticInsensitive || kCFCompareForcedOrdering
result = CFStringCompare(me.cell(row1,column), me.cell(row2,column), options )
Return True
End Function
[/code]
No, the problem was the same and the answer too as you discovered: you had to make the sort Case sensitive.
(watch in your comments: kCFCompareCaseInsensitive || kCFCompareDiacriticInsensitive)
The main information here is you found your answer.