ISA-tools
Wrong =HYPERLINK() syntax
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 https://github.com/ISA-tools/OntoMaton/blob/ca7c3402c868d1440181f75c2970d4b022f18670/OntologyTagging.gs#L187 and https://github.com/ISA-tools/OntoMaton/blob/ca7c3402c868d1440181f75c2970d4b022f18670/OntologySearch.gs#L320
Yours, Steffen
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.