Issue 81915 - Delimited File Parsing
Summary: Delimited File Parsing
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2007-09-24 21:35 UTC by dissipate
Modified: 2007-11-22 11:43 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dissipate 2007-09-24 21:35:42 UTC 
When opening a tab delimited file, if there is a new line in a record, Calc
treats this as the end of a row, without looking ahead to see if there are other
columns in the row to be processed. Therefore, if a tab delimited file is opened
that has new lines in the records, the data in the adjacent column gets pushed
down to the next row instead of remaining in the intended row.

For instance, if there is a row that looks like the following:

'rec1 \t rec2 \n\t rec3 \n'

Where \t a tab and \n is a newline, rec3 gets pushed down to the next row,
whereas it would be much more convenient for formatting purposes to have Calc
look ahead to see if there is a tab directly after the newline, which would
indicate that columns for that row are not done being processed.
Comment 1 Regina Henschel 2007-09-24 23:57:04 UTC 
The term "newline" is not exact enough. Which character is it? How is the end of
a row determined?

Please attach such a file.

On which operating system do you see the problem? Which program has generated
that file?
Comment 2 frank 2007-11-22 11:43:03 UTC 
Could not reproduce with the given data, no answer on reginas request -> closed
worksforme
Comment 3 frank 2007-11-22 11:43:23 UTC 
closed wfm