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