Anyone getting parse errors in HYPERLINK formulas in Google Sheets when they use a comma instead of a semi-colon?
My Google Sheets Add-on, Text2Link, is available in every region but I have been receiving feedback about a parse error regarding a lack of semi-colon usage when it comes to HYPERLINK formula usage.
In my code, I set a formula using a comma:
=HYPERLINK("URL", "CELL TEXT")
=HYPERLINK('URL"; "CELL TEXT")
And it works fine for me, however, if you go to the HYPERLINK documentation page and change the language, you will sometimes see comma in the example and sometimes a semicolon. Is this a bug between local versions of Google Sheets?
Hyperlink example (English): HYPERLINK("http://www.google.com/
Hyperlink example (German): HYPERLINK("http://www.google.com/
Hyperlink example (Japanese): HYPERLINK("http://www.google.com/
Hyperlink example (Nederlands): HYPERLINK("http://www.google.com/
You can change the language from English to another language by going here: https://support.google.com/docs/answer/3093313?hl=en
Sometimes the language changes the word =HYPERLINK to something different entirely. Is there a way to pretend/trick Google Sheets to load in a different locale for testing?https://chrome.google.com/webstore/detail/text2link/nmbohbjomdeefamnmbmicgmgomgddpea