<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Concatenating formatted numbers should respect the language formatting and not change it to user default"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125137">bug 125137</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>xiscofauli@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEEDINFO
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Concatenating formatted numbers should respect the language formatting and not change it to user default"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125137#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Concatenating formatted numbers should respect the language formatting and not change it to user default"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125137">bug 125137</a>
from <span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span></b>
<pre>(In reply to Buovjaga from <a href="show_bug.cgi?id=125137#c5">comment #5</a>)
<span class="quote">> The request might be valid, but I would like some developer input before
> accepting it.
>
> (In reply to csongor from <a href="show_bug.cgi?id=125137#c2">comment #2</a>)
> > In order to get decimal points in my green and red cells, I would need to
> > apply explicit formatting formulas which
> > - is cumbersome to add them one by one
> > - would make the whole spreadsheet calculation slower
> > - does not work if the file is write protected
>
> It is not so cumbersome. You can add the formatting to the source formulas
> like so:
> =TEXT((ROUND(RAND()*(G$4-2*C5)+C5;2));"###.##")
>
> From help:
>
> 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</span >
Hello <a href="mailto:csongor@halmai.hu">csongor@halmai.hu</a>,
Does it fulfill your expectations ?</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>