Sdk hyperlink function

Hi,

I’m learning to use the Java sdk (libreoffice and sdk version 5.2). I started with the SCalc.java example and tried to do some small modifications. I’m interested in being able to insert a hyperlink in a cell. I tried to insert the following formula ‘=HYPERLINK("#A1", “TEST”)’, the formula is inserted with no visible problem, but libreoffice gives an error 508 (Pair missing). If I try to do the same without the second argument of the HYPERLINK function, it works fine.
My Java code Looks like this:

xSheet.getCellByPosition(0,4).setFormula("=HYPERLINK(\"#A1\", \"TEST\")");

Any idea what I am doing wrong or is it a bug?
Thanks

Hallo
Use ; instead comma as Argumentseperator…

for me works(with python):

sel = XSCRIPTCONTEXT.getDocument().CurrentSelection
sel.Formula = "=HYPERLINK(\"#A1\"; \"TEST\")"

but python allows also outer quoting with single quotes:

sel = XSCRIPTCONTEXT.getDocument().CurrentSelection
sel.Formula = '=HYPERLINK("#A1"; "TEST")'

Thanks karolus, replacing the comma with a semicolon solved my problem.