<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - calc add-in functions are not evaluated as expected"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=54854">bug 54854</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Component</td>
<td>Calc
</td>
<td>Documentation
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - calc add-in functions are not evaluated as expected"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=54854#c29">Comment # 29</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - calc add-in functions are not evaluated as expected"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=54854">bug 54854</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>This is not a bug. API access to add-in functions is described in our help [1]:
<span class="quote">> The Add-in functions are supplied by the UNO com.sun.star.sheet.addin.Analysis
> service</span >
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:
<span class="quote">> Cell.Formula = "=com.sun.star.sheet.addin.Analysis.getDec2Bin(B3)"</span >
instead of
<span class="quote">> Cell.Formula = "=DEC2BIN(B3)"</span >
... which may be seen using the reverse call, after you set the required
working formula in that cell manually:
<span class="quote">> MsgBox Cell.getFormula</span >
In addition, [3] also needs a reference to that information (currently only
Analisys Functions help pages link to that).
[1] <a href="https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060115.html">https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060115.html</a>
[2]
<a href="https://help.libreoffice.org/7.0/en-US/text/sbasic/shared/calc_functions.html">https://help.libreoffice.org/7.0/en-US/text/sbasic/shared/calc_functions.html</a>
[3] <a href="https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060111.html">https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060111.html</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>