To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113421
User er changed the following:
What |Old value |New value
================================================================================
CC|'' |'er'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Issue type|DEFECT |ENHANCEMENT
--------------------------------------------------------------------------------
OS/Version|Windows 7 |All
--------------------------------------------------------------------------------
Priority|P3 |P4
--------------------------------------------------------------------------------
Platform|PC |All
--------------------------------------------------------------------------------
Summary|CSV import does not follow|CSV import could ignore le
| CSV standard. |ading spaces if the field
| |content without them is qu
| |oted.
--------------------------------------------------------------------------------
------- Additional comments from e...@openoffice.org Mon Jul 26 11:12:22 +0000
2010 -------
The behavior is caused by the leading space: , "3,14159",
If that is changed to ,"3,14159", instead it works as expected.
It is not true that if a field contains spaces it must be enclosed in quotation
marks. Actually the import _does_ follow the standard
http://tools.ietf.org/html/rfc4180 that in 2.4. says "Spaces are considered part
of a field and should not be ignored." and hence the field _does not_ start
quoted. At first hand the file content does not follow the standard..
I agree that for convenience the import could look if without leading spaces the
field content would be quoted and treat it as such. However, this is of low
priority.
And no, the import dialog is not useless as it it used for any type of text file
import, apart from comma separated there are also tab separated, semicolon
separated, fixed field width files and others.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
