Searh issues with "Umlaute"

Posted by: henri.volk on 10 April 2018, 9:24 pm EST

  • 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
  • Replied 15 April 2018, 8:22 pm EST

    Hi Henri,

    I am not able to replicate this issue at my end. It searches fine for "lÖwentage" with no issues with SearchCol method. I used following code:



    Private Sub Command1_Click()
    Dim ret As Long

    ' Search for exact match unless partial match specified
    If Check1.Value = False Then
    ret = fpSpread1.SearchCol(1, 0, -1, Text1.Text, SearchFlagsNone)
    Else
    ret = fpSpread1.SearchCol(1, 0, -1, Text1.Text, SearchFlagsPartialMatch)
    End If
    ' Move cell with search text into upper left, if found
    If ret <> -1 Then
    fpSpread1.ShowCell 1, ret, PositionUpperLeft
    fpSpread1.SetActiveCell 1, ret
    End If


    End Sub

    Private Sub Form_Load()


    fpSpread1.Col = 1
    fpSpread1.Row = 2
    fpSpread1.Text = "Löwentage"

    Text1.Text = "lÖwentage"

    End Sub



    I have also attached the sample application for your reference, please have a look.

    Thanks,
    Deepak SharmaSpreadSearchCol.zip
  • Replied 18 April 2018, 1:28 am EST

    Thanks Deepak,

    also in your code the search does not work if partial match is activated! (what we need).

    ret = fpSpread1.SearchCol(1, 0, -1, Text1.Text, SearchFlagsPartialMatch)

    returns -1

    Thanks
    Henri
  • Replied 18 April 2018, 10:23 pm EST

    Hi Henri,

    With the application I sent in my last response, I am not able to replicate this issue.
    It has a checkbox which decides whether or not perform the search with 'SearchFlagsPartialMatch'.
    'ret' returned with ' ret = fpSpread1.SearchCol(1, 0, -1, Text1.Text, SearchFlagsPartialMatch)' is '0' and not '-1'.
    I would request you to please test the issue with the given sample application and let me know if you can still replicate this issue. I have used Spread COM v8.0.28.


    Thanks,
    Deepak Sharma
  • Replied 19 April 2018, 3:20 am EST

    Hi thats what i said. It does not work with your application at our end. What would be the cause? Regional settings or something like that?

    Henri
  • Replied 22 April 2018, 4:58 pm EST

    Hi Henri,

    I tested it with English regional settings on a Windows XP machine. Please let me know your environment.

    Thanks,
    Deepak Sharma
  • Replied 22 April 2018, 9:10 pm EST

    Hi Deepak,

    as Henri currently has a few days off I will give an answer to your question:
    We are mainly using Windows 7 and Windows 10 with a German Windows installation and German regional settings. And we don't use Windows XP anymore.

    Thanks for your support!

    Cheers
    Oliver
  • Replied 26 April 2018, 10:38 pm EST

    Hello,

    I am not able to replicate this issue on a Windows 7 machine with German regional settings. Please refer to the attached sample application and video.
    Could you please check it on an English machine and let me know?

    Thanks,
    Deepak SharmaSearchColWin7GermanSettings.zip
    SpreadSearchCol_Updated.zip
  • Replied 2 May 2018, 8:13 pm EST

    Hi Deepak,

    same on an English version for me. Any additional idea which setting could cause the issue?

    Here is a link to a gif showing it: https://amily-my.sharepoint.com/:i:/g/personal/henri_amily_onmicrosoft_com/EatWy73XEIdOuoD0JJ1KPRgBRPfm7ecefojvI-WxPft_AQ?e=Dq2l2W

    Best
    Henri
  • Replied 3 May 2018, 8:37 pm EST

    Hi Henri,

    Could you please check this issue on some other machine and let me know if the results are still the same? I have tested it on a Windows 7 and Windows XP machine and it works fine here at my end as shown in the video.


    Thanks,
    Deepak Sharma
  • Replied 3 May 2018, 8:40 pm EST

    Hello,

    You can also check the code in the sample application I gave to see if the code runs fine for Partial match search too by putting a break point.

    Thanks,
    Deepak Sharma
  • Replied 3 May 2018, 9:22 pm EST

    Hi Deepak,

    that's just what we did in the first place but to no avail.

    Setting a break point on
    ret = fpSpread1.SearchCol(1, 0, -1, Text1.Text, SearchFlagsPartialMatch)
    and then stepping over this line of code gets us
    -1
    as result ("ret = -1").

    Best regards
    Oliver
  • Replied 9 May 2018, 12:13 am EST

    Hi Oliver,

    In that case I would request you to test it on an English machine, and let me know. It looks more specific to the German OS installed on your machine.


    Thanks,
    Deepak Sharma
  • Replied 13 May 2018, 8:29 pm EST

    Hi Deepak,

    we have tested it on an English machine (see my comment from May 3rd).

    Any kind of debug log we could create for you?

    Best
    Henri
  • Replied 14 May 2018, 11:52 pm EST

    Hi Henri,

    I will further check with our team if it can be checked on a German machine and let you know.

    Thanks,
    Deepak Sharma
  • Replied 14 May 2018, 11:59 pm EST

    The tracking id for this issue is 258305.


    Thanks,
    Deepak Sharma
  • Replied 14 June 2018, 6:01 pm EST

    Hi Deepak, are there any news?
    What can I do with the tracking ID? :-)
    Best
    Henri
  • Replied 17 June 2018, 11:04 pm EST

    Hi Henri,

    This issue is still with the development team. I will let you know as soon as I get an update on thi.

    Thanks,
    Deepak Sharma
  • Replied 21 August 2018, 7:13 pm EST

    Hi, any news? Customer is banging our doors...
  • Replied 22 August 2018, 11:34 pm EST

    Hi Henri,

    I have asked for an update on this issue from the concerned team. I will let you know as soon as I get any news on it.

    Thanks,
    Deepak Sharma
  • Replied 23 October 2018, 12:05 am EST

    Hi, can we have _any_ update please?
    Thanks
    Henri
  • Replied 23 October 2018, 5:19 pm EST

    Hi Henri,

    We apologize for the long delay, I have asked the development team to look into this on high priority. I will inform you as soon as I hear anything on it.

    Thanks,
    Deepak Sharma
  • Replied 3 December 2018, 9:39 pm EST

    Am I right that we will never receive a reply about the issue? Can we have the a statement for our customer please?
  • Replied 4 December 2018, 11:24 pm EST

    Hello,

    It seems the dev team has not reached the final conclusion on this. I have asked for the same. I will inform you immediately once I hear from them.

    Thanks,
    Deepak Sharma
  • Replied 24 January 2019, 11:05 pm EST

    This is a common issue. I especially face this issue whenever error codes occur on my laptop. Shall I fix it with https://errorcode0x.com/error-code-0x80071a90/ and then try it again?
  • Marked as Answer

    Replied 27 January 2019, 10:23 pm EST

    Hi,

    You can try the solutions suggested in the posts you shared. However I am yet to receive an update from development team about the escalated case.
    I have pinged the developer and asked for the same I will inform you as soon as I hear anything on this.


    Thanks,
    Deepak Sharma
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels