https://bugs.documentfoundation.org/show_bug.cgi?id=117672
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=15
| |0635,
| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=15
| |0652
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #5 from Mike Kaganski <mikekagan...@hotmail.com> ---
No, there is no use to do this "warning", nor change the default import column
type.
The principle of least surprise tells that the software should not confuse most
users. And most users would be surprised to get their numbers with multiple
digits (like "1.2345678901234567890") not treated as numbers.
The dialog allows one to define column types explicitly. Bug 150652 would make
that more discoverable. Using an external format, especially CSV, which on one
hand is heavily used by banks and such (so any additional failure to recognize
numbers would make *lots* of people suffer), and on the other hand, has
absolutely no idea about data types, requires some user involvement. Dumbing
the import process to provide "safe" default (like "everything is text") will
make major pain to most users; and there is *no* way to tell that there was no
data modification, when you e.g. imported a number 0.1, and got its imprecise
binary representation equal to
0.1000000000000000055511151231257827021181583404541015625.
--
You are receiving this mail because:
You are the assignee for the bug.
