Wrong =HYPERLINK() syntax

[sneumann]

Hi,
when adding a term, Ontomaton will insert
=HYPERLINK("http://purl.obolibrary.org/obo/MS_1000702","micrOTOF")
which results in a parsing #ERROR complaint by google.
The correct content will be using a semicolon instead:
=HYPERLINK("http://purl.obolibrary.org/obo/MS_1000702";"micrOTOF")

Fixing will need changes in

OntoMaton/OntologyTagging.gs

Line 187 in ca7c340

sheet.getRange(row, selectedColumn).setFormula('=HYPERLINK("'+ ontologyObject.accession +'","' + ontologyObject.term + '")')

and

OntoMaton/OntologySearch.gs

Line 320 in ca7c340

sheet.getRange(row, selectedColumn).setFormula('=HYPERLINK("' + ontologyObject.url + '","' + ontologyObject.term + '")')

Yours,
Steffen

[sneumann]

Hm, when trying to find a reference for that issue and perceived change of behavior, I found
https://stackoverflow.com/questions/64773174/sharing-a-sheet-with-formulas-separated-by-commas-to-someone-in-a-region-that-us. Indeed, when switching the Locale to "Vereinigtes Königreich" :-) Ontomaton works as advertised.
From reading I am unsure if my PR #37 is the generic solution (yet), but https://stackoverflow.com/a/61283851 suggests it is.