[Calc Macro] Case-Sensitive InStr not working

InStr call like

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


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.

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)

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

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


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

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


Thank you for help!