<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 - Difference between SUM function and plain addition when part of number is Bolded"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132307">bug 132307</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;">Status</td>
<td>REOPENED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Difference between SUM function and plain addition when part of number is Bolded"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132307#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Difference between SUM function and plain addition when part of number is Bolded"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132307">bug 132307</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>Not because SUM with a range doesn't take care of text cells, and number's
bolded become text instead number, <a href="show_bug.cgi?id=132307#c1">comment#1</a>, BTW Erak is a main dev on calc.
Only direct references, but not range references to cells with numbers as text
can be taken as numbers, and there is an options in relation it
Menu/Tools/LibreOffice Calc/Formula/Detailed Calculation Settings - Custom -
Conversion from text to number.
You can use a formula like
=SUMPRODUCT(IFERROR(VALUE(A1:A2);0))
to get what you like, but being sure that is possible convert the text to
number.
Sorry but it's not a bug.</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>