Posted 10 April 2018, 9:24 pm EST
We are using “Unicode Spread ADO 8.0.28 (OLDEDB)” and having issues that search with “Umlaute” and case intensitivity is not working correctly.
The call is: "fpSpread1.SearchCol(ByVal lCol As Long, ByVal lRowStart As Long, ByVal lRowEnd As Long, ByVal Text As String, ByVal SearchFlags As SearchFlagsConstants) "
e.g.
The string that exists is: “Löwentage”.
lRow = objSpread.SearchCol(12, lRow, -1, “löwentage”, 2) => found!
lRow = objSpread.SearchCol(12, lRow, -1, “LöwenTage”, 2) => found!
lRow = objSpread.SearchCol(12, lRow, -1, “lÖwentage”, 2) => not found!
In other words: search for Umlaute only works if the Umlaut is exactly written the way it exists, case insensitivity is not working.
Best
Henri