<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 - Numeric formatting using the _ does not work"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108338">108338</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Numeric formatting using the _ does not work
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>NetBSD
</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>paul@whooppee.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
In the "other" spreadsheet program, I would be able to apply a format of
'#,##0_._0_0' to request that space for a decimal point and two fractional
digits be reserved, but not printed; with horizontal-alignment of "right" the
above format would align correctly with numbers formatted at '#,##0.00'.
However, with Calc, the _ formatting directive doesn't seem to work. It allows
me to create a user-defined format, but when the document is saved and then
reloaded, all formats with the _x type of directive are replaced with modified
formats that have trailing quoted spaces instead of the _x directive(s). And
the number of spaces does not seem to be correct for ensuring vertical
alignment.
Steps to Reproduce:
1.Format a number using the _0 (or any other _x)
2.Save document, exit program
3.Restart program, open document, observe formatting changes
Actual Results:
format string for affected numeric fields is changed to include " " (number
of spaces varies).
Expected Results:
Specified formatting (with the _ directive) should be retained.
Alternatively, if the conversion to " " formatting is absolutely essential, at
least the amount of space being inserted should correspond to the intended
behavior (ie, proper alignment).
Reproducible: Always
User Profile Reset: No
Additional Info:
According to Mike Kaganski, he has reproduced this on 5.3.3.2 and requested
that I file this bug report.
User-Agent: Mozilla/5.0 (Windows NT 6.3; 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>