<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 - LEFT() and empty space at the beginning in .xlsx"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142905">142905</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LEFT() and empty space at the beginning in .xlsx
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</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>prempa@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=172963" name="attach_172963" title="First LEFT may refers to a blank cell">attachment 172963</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=172963&action=edit" title="First LEFT may refers to a blank cell">[details]</a></span>
First LEFT may refers to a blank cell
If LEFT() formula inserts spaces at the beginning of the string (because the
cell it refers to is blank) and is saved as .xlsx, when you reopne the file,
the string ignores spaces until it is recalculated.
By copying and pasting before the recalculation the leading spaces are missing.
Saving in .ods the formula works correctly and the copy and paste works as
expected.</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>