[Libreoffice-bugs] [Bug 54854] calc add-in functions are not evaluated as expected

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Calc                        |Documentation

--- Comment #29 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug. API access to add-in functions is described in our help [1]:

> The Add-in functions are supplied by the UNO com.sun.star.sheet.addin.Analysis
> service

which links to [2] "Calling Add-In Calc Functions in BASIC", ... which tells
about the separate UNO service that implements the add-in functions.

However, it's not clear from those links that one should also use specific
names when setting formulas to cells, not only when calling spreadsheet
functions in code. So we need to improve the documentation, that one needs
something like this:

> Cell.Formula = "=com.sun.star.sheet.addin.Analysis.getDec2Bin(B3)"

instead of

> Cell.Formula = "=DEC2BIN(B3)"

... which may be seen using the reverse call, after you set the required
working formula in that cell manually:

> MsgBox Cell.getFormula

In addition, [3] also needs a reference to that information (currently only
Analisys Functions help pages link to that).

[1] https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060115.html
[2]
https://help.libreoffice.org/7.0/en-US/text/sbasic/shared/calc_functions.html
[3] https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060111.html

-- 
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/20201012/ba79f713/attachment.htm>