https://bugs.documentfoundation.org/show_bug.cgi?id=167827
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Mike Kaganski <[email protected]> --- (In reply to Paolo Devoti from comment #0) > when importing a quoted string it should be handled as a string and not as a > number even if string content looks like a valid number No. There is absolutely no "data type" notion in CSV; and the only purpose of quotes in it is not to designate "text", but to mask characters that could conflict with special characters there (quotes, field separators, record separators) [1]. However, SCV is not a true standard, but rather a loose group of ad-hoc-created formats; and RFC4180 is just informational. Therefore, we have a highly functional import dialog, which includes "Format quoted field as text" checkbox, exactly for uses where someone decided to alter the format with "quotes mean text" idea. Closing NOTABUG. [1] https://www.rfc-editor.org/rfc/rfc4180 -- You are receiving this mail because: You are the assignee for the bug.
