[Libreoffice-bugs] [Bug 101316] Macro Creates Formulas with Error 508

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #9 from Mike Kaganski <mikekaganski at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210519/1356bc3f/attachment.htm>