Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | OO doesn't recognize CSV files having both semicolons and double quotes | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | zakmck <zakmck> | ||||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CONFIRMED --- | QA Contact: | |||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | damjan, issues, rainerbielefeld_ooo_qa | ||||||
Version: | OOo 2.2 | Keywords: | oooqa | ||||||
Target Milestone: | --- | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
zakmck
2008-09-04 14:41:54 UTC
Sorry. Let's do it again... The attached file is a CSV with TAB as separator and double quotes as cell value delimiter. Some values have semicolons characters inside. OO doesn't recognize it correctly when I try to open it, either via right-click, or via Open File -> Text/CSV format. Instead, if I create an empty spreadsheet and then I do "Insert spreadsheet from file", I am being asked about the CSV options (separator and alike) and eventually the file is correctly loaded. Therefore I guess it depends on auto-guessing of format options, which is a feature I really would like it was optional, with CSV options dialog in case I want to specify format variants. Created attachment 56239 [details]
CSV files which is not recognized by OO
Created attachment 56240 [details]
SORRY, REFER TO THIS AND NOT TO THE PREVIOUS ONE
Sorry for the mess. Correct version of the attachment is the second one. I am using OO 2.4.1 for OS/X. I checked with "Ooo 3.0.0 (DE) Multilingual version German UI WIN XP: [OOO300m9 (Build9358)]" and can confirm the reported effect. Same with "Ooo 3.1 Multilingual version German UI WIN XP: [DEV300m36 (Build 9369)]", "2.4.1 Multilingual version German UI WIN XP: [680m17(Build9310)]", "1.1.4 (German) WIN XP: [645m52 (Build 8824)]" Will be opened with OOo after double click from WIN Explorer We have several issues concerning this or similar problems: Issue 49828 (WFM? I don' think so) Issue 65460 (invalid?) Issue 80393 (invalid) Issue 93488 (might be something different with double semicolons and double quotes) @zakmck, great idea to use the same name for all sample files with different behaviour, that really makes it easy for us to fins out what happens ;-) And NEW With the first 129 characters in the sample file or less, the CSV import dialog is brought up. With 130 or more characters, we get the ASCII filter dialog instead. Character 130 is a null (0), but not the first nor the only in the file. Interestingly, a file made of 2 nulls (head -c 2 /dev/zero > /tmp/file.csv) is also opened in the ASCII filter dialog. |