[Libreoffice-ux-advise] [Bug 152337] Show a warning infobar when imported text file used several of selected field separators

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Heiko Tietze from comment #2)
> I suspect the infobar would be annoying to many users. And if you load a lot
> of data in any tool you have to do sanity checks anyway.

If you import a *CSV* (or TSV, or any of the *normal* text files of this kind,
generated by vast majority of software), which use a *single* separator inside,
then no matter how many separators you selected in the dialog - only one of
them must be used actually by Calc; if Calc happened to meet two of the
selected separators - it means that the import *went wrong*, and it is a
*destructive import error*. This is the whole essence of the issue. If "many
users" would see it, it means that many users import their data and break it,
and *do not notice it*!

> And I wonder what threshold you have in mind. Something like more than 0.01%
> "common separator" in the document.

No threshold. A single extra separator means the error occurred. *Especially*
when it's a single occurrence, it's most possible that the user will not notice
it somewhere in the middle of a huge data.

> Why not do the opposite with the argument that only a few data points are
> separated by semicolon and you haven't check it.

I totally do not understand you.

> Last but not least what impact would such a check have on the performance?

None.

-- 
You are receiving this mail because:
You are on the CC list for the bug.