https://bugs.documentfoundation.org/show_bug.cgi?id=101316

Mike Kaganski <mikekagan...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |er...@redhat.com

--- Comment #9 from Mike Kaganski <mikekagan...@hotmail.com> ---
(In reply to ghborrmann from comment #8)

Calc displays formulas to users using whatever modification options set in the
program - taking into account the localized defaults for locales (like commas
as argument separators in en-US), and user overrides in Options->Calc->Formula.
It would use R1C1 notation, or Excel A1 notation, if user sets so. And that's
all just a *display* thing; internally, there's only one "API" syntax that is
accepted by oCell.Formula - namely, those defined in ODF standard (e.g., for
function parameters, see its OpenFormula sect. 5.6 [1]). In other words,
answering to

> Where does is state that using ';' for function argument separators is 
> standard?

the answer is: in ODF international standard. Using locale-independent strings
when programming is essential for any programmer, to avoid gotchas when your
program stops working on your neighbor just because they changed their display
preferences.

[1]
http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#FunctionsFunctionsParameters

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to