<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:todventtu@suomi24.fi" title="Buovjaga <todventtu@suomi24.fi>"> <span class="fn">Buovjaga</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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;">Keywords</td>
<td>
</td>
<td>needsDevAdvice
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>todventtu@suomi24.fi
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Language of Calc Spreadsheet
</td>
<td>Concatenating formatted numbers should respect the language formatting and not change it to user default
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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:todventtu@suomi24.fi" title="Buovjaga <todventtu@suomi24.fi>"> <span class="fn">Buovjaga</span></a>
</span></b>
<pre>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>)
<span class="quote">> 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</span >
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</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>