<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_UNCONFIRMED "
title="UNCONFIRMED - A warning should be issued if one of the cells included in the computation has a value of any kind that is not taken into account in the result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=105394">bug 105394</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;">CC</td>
<td>
</td>
<td>miguelangelrv@libreoffice.org
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - A warning should be issued if one of the cells included in the computation has a value of any kind that is not taken into account in the result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=105394#c19">Comment # 19</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - A warning should be issued if one of the cells included in the computation has a value of any kind that is not taken into account in the result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=105394">bug 105394</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>I'm not for that, It implies analyze if it is a value as text for every cell,
and only can carry to reduce the calc's performance, that is currently not done
on ranges.
It can be controlled with formulas like, creating an 'Error' style.
=AVERAGE($A2:A2)+STYLE(IF(SUMPRODUCT(ISNUMBER($A2:A2))<>COLUMNS($A2:A2);"Error";""))
The same can be done with conditional format.</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>