https://bugs.documentfoundation.org/show_bug.cgi?id=117672
Mike Kaganski <[email protected]> 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 <[email protected]> --- 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.
