In CSV import dialog, the "Text delimiter" field is a drop-down with some pre-defined often-used values; but it is editable, allowing to define own delimiter, or to remove it completely. This is not obvious, especially for newbies - see e.g. [1]. The proposal is to amend the "Text delimiter" label with "(clear to disable)" comment. While I realize it will become very long, it still is UX improvement IMO. It may be moved to an own line to accommodate for the translatable string. An option to introduce a checkbox to disable the delimiter was considered, but I suppose it's bad: (a) it would be inconsistent second way to do the same (remove the character); and (b) it would not draw attention to editability (my suggestion allows one to realize other ways to customize the delimiter). Of course, maybe there are better ways to improve the situation; whichever way is decided, this needs an UX improvement. [1] https://ask.libreoffice.org/t/import-csv-file-ignore-string-delimiter-while-importing/55999
@Mike, other than the labeling as an editable field, could we tighten up the field validation? Currently you can edit it to be any string--but just the first character is used as the delimiter. Had scratched my head over bug 124899 Alternatively, could we achieve a "multi-character" delimiter string for working with CSV (import & export)?
(In reply to V Stuart Foote from comment #1) > @Mike, other than the labeling as an editable field, could we tighten up the > field validation? Currently you can edit it to be any string--but just the > first character is used as the delimiter. Had scratched my head over bug > 124899 Limiting the field to 1 character is a good idea - please file it separately. Should be a simple .ui change. > Alternatively, could we achieve a "multi-character" delimiter string for > working with CSV (import & export)? I suppose it's something Eike could answer *in a separate issue*.
It depends on the OS/DE how controls are drawn. Readonly dropdown have usually an elevated appearance and a slightly lighter color while editable combo boxes look like input fields with an expander at right. In this particular case it might help to find a better place for the string delimiter, not attached to the right border. And we have to give immediate feedback.
valid request IMO.
The topic was on the agenda of the design meeting. Out of the ideas a) separate positioning and a bit larger size, b) remove the dropdown in favor of text input (with default to double quote), c) tooltip / documentation we believe a) is the best to implement.