https://bz.apache.org/ooo/show_bug.cgi?id=126805
Issue ID: 126805
Issue Type: DEFECT
Summary: Importing CSV where apostrophe is separator and
contained in text causes remaining rows to not import
Product: Calc
Version: 4.1.2
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Created attachment 85264
--> https://bz.apache.org/ooo/attachment.cgi?id=85264&action=edit
CSV file that can not be completely imported.
When importing a csv file with an apostrophe as text and numeric delimiters and
one of the text fields has an apostrophe in it, OpenOffice will stop importing
the remainder of the file when the Separator Options are made to eliminate the
apostrophes around the text and numeric values. Attached is a CSV file that can
not be imported past row 124. This file imports correctly into Microsoft Excel.
When the apostrophes are not showing in the preview window on the bottom of the
Text Import window, scroll down to row 124 then scroll to the right. You will
see the remainder of the rows are continuing across on row 124.
--
You are receiving this mail because:
You are the assignee for the issue.
