<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FORMATTING: Free space filling broken with thousands separator"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107993">107993</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FORMATTING: Free space filling broken with thousands separator
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>benoit.thebaudeau.dev@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Custom format codes using both the free space filling (*) feature and a
thousands separator fail to fill the free space in the spreadsheet for numbers
with an absolute value greater than or equal to 1000. However, the preview in
the format dialog is correct.
Steps to Reproduce:
1. Create a new spreadsheet.
2. Enter 1000 in a cell.
3. Open the cell format dialog for this cell.
4. Apply the following format code to the cell, which should left-align the
sign in the cell and use a blank as a thousands separator (Calc set up for
French):
+* # ##0;-* # ##0
Actual Results:
The preview displays [+ 1 000] as expected, but [ +1 000] is
actually displayed in the cell. The square brackets represent the left and
right borders of the cell.
With 999, [+ 999] is displayed in both the preview and the cell as
expected.
Expected Results:
The sign should always be left-aligned:
[+ 1 000]
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:53.0) Gecko/20100101
Firefox/53.0</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>