CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-sheetslocalegoogle-sheets-formula
user_87625129
user_87625129

Reputation: 89

How do I get the formula separator in a script?

I have a basic Google Sheets script and as part of the HTML sidebar I show the user the formula to type in; e.g. =myformula("bob", "ross"). This works for people in the U.S. and a lot of other countries but there are quite a few countries that use ; instead, so the formula looks like =myformula("bob"; "ross"). I know I can probably get the locale of the spreadsheet via a script but is there a way to get whether I should put a , or a ;? Thanks!

Upvotes: 3

Views: 232

Answers (1)

TheMaster
TheMaster

Reputation: 50697

; is universally accepted(except in case of array literals). It'll automatically be parsed to , in the US and other locales.

Upvotes: 5

Related Questions