To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78926
User er changed the following:
What |Old value |New value
================================================================================
Assigned to|spreadsheet |er
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Issue type|DEFECT |TASK
--------------------------------------------------------------------------------
Summary|Export to CSV makes empty |Might apply some magic to
|columns |CSV import with broken non
| |-escaped quotes in fields
--------------------------------------------------------------------------------
Subcomponent|save-export |open-import
--------------------------------------------------------------------------------
Target milestone|--- |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Jun 27 18:35:17 +0000
2007 -------
1. Your input file is broken.
If a quoted field contains a quote the software creating the file
escaped the quote using a backslash (\"), which is wrong and may
result in data fields being misaligned. Contained quotes must be
escaped by doubling them ("").
2. In case an odd number of wrongly escaped quotes is contained within
a field it depends on the context how the line is read.
For example see row 774 where data from line 774 (starting with
"773";"1";"BIGODINI RISCALDANTI \"BA";...) is followed by data from
line 774 and following lines until a pairing quote is matched,
resulting in a long row up to cell IQ774, which upon export results
in that many columns.
3. However, this special case should not result in a line concatenation
because the preceding fields up to AI774 were recognized and aligned
correctly the same as in other lines that contain an even number of
broken quotes. [hey, good piece of software, isn't it? Your data is
broken and still it is read almost correctly ;-) except that
non-doubled quotes are lost in all fields]
4. I take this issue only to investigate what the special case here
exactly is and maybe find some magic to apply.
5. Remember, your input file is broken.
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
