[Libreoffice-bugs] [Bug 127013] New: The input fields for separators ("Function", "Array column", "Array row") allow to choose improper characters.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127013

            Bug ID: 127013
           Summary: The input fields for separators ("Function", "Array
                    column", "Array row") allow to choose improper
                    characters.
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jag at psilosoph.de

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).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190818/f6752be1/attachment-0001.html>