Forum Discussion
Solved
Reliable way to determine the argument separator of Excel formulas
Hello, When we develop Excel add-ins by JavaScript API, we need to determine the argument separator of Excel formulas. For some environments it is `,` (comma); for some environments it is `;` (se...
You might get the decimal separator:
const systemDecimalSeparator = context.application.cultureInfo.numberFormat.numberDecimalSeparator;If it is a point, the list (argument) separator will be comma; if it is a comma, the list separator will be semi-colon.
"If it is a point, the list (argument) separator will be comma; if it is a comma, the list separator will be semi-colon." ==> are you really sure that it is always the case?
I've never seen an exception.