my current cell’s formula is “=SUM(F4,F6)”

and the result of basic code

“ThisComponent.getCurrentSelection.formula” is “=SUM(F4;F6)”.

why comma is replaced with semicolon?

In quite a number of languages other than English decimal points are separated with comma, such as 0,5 (stands for English 0.5). Now imagine you want to write a similar equation to sum 0,4 and 0,6, but writing `=SUM(0,4, 0,6)`

would give you 10 instead of 1. Therefore localized LibreOffice uses different argument separators inside functions.

So the two following equations are exact equivalents:

```
=SUM(0.4, 0.6)
=SUM(0,4; 0,6)
```

So, is there any way to return the basic code’s result based on the localized argument separator?

The easiest way is to switch your locale to English, see Tools → Settings → Language settings and also Tools → Settings → Calc → Formula → Separators.

The “right” way would be to make your code work with both notations, see

http://listarchives.libreoffice.org/global/users/msg28363.html

and also

http://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=40890