<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 - Cannot enter colon or semicolon in formula bar (French version)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108795">108795</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Cannot enter colon or semicolon in formula bar (French version)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>mjulier@free.fr
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134298" name="attach_134298" title="screenshot showing the bug">attachment 134298</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134298&action=edit" title="screenshot showing the bug">[details]</a></span>
screenshot showing the bug
You may know that in French typography, a non-breakable space is normally
inserted before any colon or semicolon sign. So does LibreOffice Writer for
French language, with no big trouble.
In LibreOffice Calc, French version, the same happens even in the cells
configured in English language. OK, this is not the problem.
Let me click on a cell and type the text "List: one; two; three". Some spaces
are correctly inserted and the cell now contains the text "List : one ; two ;
three". If I don't want these spaces, I can now delete them: no problem.
Now, let me click on the formula bar and, again, type the text "List: one; two;
three". The formula bar will show exactly this, but the cell will show "List
one two three;;:". Which means: spaces were inserted before the colons and
semicolons, and then the colons and semicolons were transferred to the end of
the string, in reverse order. This is bad!
OK then, I type Enter, go back to the same cell, and try to fix the problem in
the formula bar. I remove the extra spaces, remove the colons and semicolons at
the end, and try to insert colons and semicolons at the correct place, so that
the formula bar shows "List: one; two; three". But now, the cell contains the
text "List : on : t :o three", which is even worse and very strange.
I think that this bug exists since quite a long time, but I never took the time
to report it before since there is a workaround (typing into the cell).
Since it is related to a French typographic rule, I suspect that it exists just
in some languages, maybe just in the French version.
I am attaching a montage of screenshots</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>