Issue 25900

Summary: Cannot specify both commas and tabs as csv separators
Product: Calc Reporter: drc <drc>
Component: codeAssignee: frank
Status: CLOSED IRREPRODUCIBLE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 RC5   
Target Milestone: ---   
Hardware: PC   
OS: Windows 98   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
tab and comma separated values none

Description drc 2004-02-26 12:46:39 UTC
I have a .csv file with tabs separating fields, and commas within the fields.

I use commas to identify sub-fields (don't ask - it comes from something else)

When I ask the import filter to recognise both tabs and commas as field 
separators, it only recognises the tabs.

There is an obvious but messy work-around involving importing the file twice, 
so the defect is not a show-stopper.


Chris

(see also bug 834)
Comment 1 frank 2004-03-01 11:44:33 UTC
Hi Chris,

please attach a document with such delimeters.

Frank
Comment 2 frank 2004-03-18 15:49:55 UTC
Created attachment 13910 [details]
tab and comma separated values
Comment 3 frank 2004-03-18 15:50:24 UTC
Hi,

I've made a document containing tabs and commas mixed as separators and opened
this using OOo1.1 and 1.1.1rc and the separation works as expected. I attach my
document and when close this Issue as worksforme.

Frank
Comment 4 frank 2004-03-18 15:50:49 UTC
closed wfm