<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 - The input fields for separators ("Function", "Array column", "Array row") allow to choose improper characters."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127013">127013</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>The input fields for separators ("Function", "Array column", "Array row") allow to choose improper characters.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>jag@psilosoph.de
</td>
</tr></table>
<p>
<div>
<pre>Menu item sequence >Tools>Options>LibreOffice Calc>Formula>
leads to a dialogue window containing a section "Separators".
There are the three mentioned input fields. They don't offer a restricted
selection, but allow for direct input. Some characters are not accepted, among
them letters and the ordinary arithmentic operators, but many are accepted even
if obviousliy not usable for the purpose.
Among the improper characters are
all decimal digits
":", "~", "!" range operators
"&" the concatenation operator
"=" a comparison operator
"%" an arithmetic suffix operator
"#","$", "?" otherwise improper
and even "{", "}".
The only characters I can find for a positive list are ";" and (hesitating)
"|", and -if you think it's unavoidable- the damned comma which surely was at
the beginning of the mess.
Suggested solutions:
1) Simple: The fields accept only ";", "|", and "," shown in a label.
2) Comfortable: The selection is made by enabling the respective radio button
from a group.
In any case the second and the third choice must be different (as already
implemented).</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>