[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

--- Comment #8 from ghborrmann <ghborrmann at gmail.com> ---
(In reply to Mike Kaganski from comment #7)
> oCell.Formula takes *standard* (language-independent) syntax of formulas
> (using ';' for function argument separators, among other things), so
> "=IF(A2="",B1,B2)" is of course an invalid input resulting in error from
> parsing the formula text. This is not a bug.

Where does is state that using ';' for function argument separators is
standard?  LO itself acknowledges that the comma is standard, in two ways:
1.  When entering a formula from the keyboard, LO shows a template of the
function.  This template uses commas, not semicolons.
2.  When a formula is created by a macro, using semicolons results in no error
but clicking on the cell shows that the formula now in the cell uses commas.

My point: this bug, while trivial for experienced LO macro writers, can give
new users a bad impression of LO's overall quality.

-- 
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/27783e47/attachment.htm>