<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_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FormulaResultType return VALUE for cells with formula result #DIV/0! or #NAME?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=70882">bug 70882</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;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FormulaResultType return VALUE for cells with formula result #DIV/0! or #NAME?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=70882#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FormulaResultType return VALUE for cells with formula result #DIV/0! or #NAME?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=70882">bug 70882</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.
As described in description of FormulaResultType attribute of SheetCell Service
Reference [1], its return value is CellContentType (see <a href="show_bug.cgi?id=70882#c6">comment 6</a>), which lacks
any ERROR value (and it's impossible to change the enumeration, because it's
breaking the API and ABI); to obtain a com::sun::star::sheet::FormulaResult
constant (having ERROR value), you need to use FormulaResultType2 attribute of
the same service (which likely was introduced for that very reason).
Or you can use getError() of XCell Interface [2], like described in [3].
[1]
<a href="https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1SheetCell.html#affda686bb18571c67c625c9adc1c85f9">https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1SheetCell.html#affda686bb18571c67c625c9adc1c85f9</a>
[2]
<a href="https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCell.html#a79278ec2dc4228f41254eef7e33729f0">https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCell.html#a79278ec2dc4228f41254eef7e33729f0</a>
[3]
<a href="https://ask.libreoffice.org/en/question/83622/macro-how-to-get-a-cell-value-set-by-a-formula/">https://ask.libreoffice.org/en/question/83622/macro-how-to-get-a-cell-value-set-by-a-formula/</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>