[Calc Macro] Case-Sensitive InStr not working

[StephaniumLupis]

InStr call like

msgbox InStr(0,"subSTRing","str",0)

or

msgbox InStr("subSTRing","str",0)

when run shows error message “Action not supported. Invalid procedure call.” Is it a bug? According to this page InStr Function [Runtime] - LibreOffice Help first call should work.

Version: 5.1.3.2
Build ID: 1:5.1.3-0ubuntu1
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; 
Locale: en-US (en_US.UTF-8)

[JohnSUN]

Maybe you mean msgbox InStr(1,"subSTRing","str",1) and msgbox InStr("subSTRing","str")?

[StephaniumLupis]

Both of your statements are equal and return 4. At least on my machine.

[PYS]

HI

msgbox InStr(1, "NotACollection","Coll")

Gives 5: you inspect a string, not a collection, so start is not 0 but 1

Regards

[StephaniumLupis]

Thank you for help!