<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 - TEXT function is failing -- every now and again. It gets the <format> and <number> confused."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116780">bug 116780</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>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>miguelangelrv@libreoffice.org
</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 - TEXT function is failing -- every now and again. It gets the <format> and <number> confused."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116780#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - TEXT function is failing -- every now and again. It gets the <format> and <number> confused."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116780">bug 116780</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>Help of the TEXT function:
<a href="https://help.libreoffice.org/6.0/en-US/text/scalc/01/04060110.html?System=WIN&DbPAR=CALC#bm_id3156426">https://help.libreoffice.org/6.0/en-US/text/scalc/01/04060110.html?System=WIN&DbPAR=CALC#bm_id3156426</a>
TEXT
Converts a number into text according to a given format.
Syntax
TEXT(Number; Format)
Number is the numerical value to be converted.
Format is the text which defines the format. Use decimal and thousands
separators according to the language set in the cell format.
Example
=TEXT(12.34567;"###.##") returns the text 12.35
=TEXT(12.34567;"000.00") returns the text 012.35
you are giving numbers as second argument, so such number is taken as a string
by the function to format.
Being ROUND(T3,0) = 10, ROUND(T9,0) = 60, 10 or 60 as string used to format 4
doesn't make difference.
Help about format codes:
<a href="https://help.libreoffice.org/6.0/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=WIN">https://help.libreoffice.org/6.0/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=WIN</a>
I don't know what you want achieve, but I can't see a bug.
Please to get help you can go
<a href="https://www.libreoffice.org/get-help/community-support/">https://www.libreoffice.org/get-help/community-support/</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>