<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Libreoffice calc checkbox when checked changes contents of linked cell but cell value is not evaluated properly when included in formulas in other cells."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123510">bug 123510</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>NEEDINFO
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Libreoffice calc checkbox when checked changes contents of linked cell but cell value is not evaluated properly when included in formulas in other cells."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123510#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Libreoffice calc checkbox when checked changes contents of linked cell but cell value is not evaluated properly when included in formulas in other cells."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123510">bug 123510</a>
from <span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span></b>
<pre>If all values in the range to sum are numbers or text numbers not other kind of
strings, then =SUMPRODUCT(A1:A2*1) can work, because it forces the conversion.
And direct references to one cell with text numbers should work also.
Another issue sure is that change the behavior can break existing forms.
Forms don't take care of what the receiver does with the values, in this case a
spreadsheet.
If you want reopen as request for enhancement on the second box of Importance
field, adapting the title.</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>