Issue 80393

Summary: text import
Product: Calc Reporter: raindown <raindown>
Component: open-importAssignee: spreadsheet <spreadsheet>
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.2.1   
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
examples of text import problems none

Description raindown 2007-08-06 19:32:50 UTC 
When importing text (in my case from our database for creation of lists) the
feature "seperator option" doesn't work:
When pasting text into the spreadsheet the window "text import" opens.
we use semicolons to seperate text and ' as text limiter, this combination
doesn't result in seperate columns. 
If we apply only semicolons as seperator and leave the text limiter on the
preset ", the columns are seperated. 

On the other hand, I tried to import text with semicolons as text seperator and
" as text limitor. This resulted in the following:
- with the set up: text seperator = Semicolon and text limiter= " , the program
ignores some semicolons
-with the set up: text seperator = semicolon and text limiter= ' , the programs
seperates all columns, but ignores the text limiter

It seems like a little mix-up in the programming there. Although I am not a
specialsíst myself...
The text import feature seems like a new one to me, since I've only seen it in
the new version. We are using the "Text to Column" add-on and therefore it's not
a big problem. At least for us.
Comment 1 frank 2007-08-06 21:23:04 UTC 
Hi,

please attach a file showing your problem.

Frank
Comment 2 raindown 2007-08-07 07:23:43 UTC 
Created attachment 47355 [details]
examples of text import problems
Comment 3 frank 2007-08-07 13:29:00 UTC 
Hi,

this is not a bug.

The semicolons are used as field delimiter and the quotes (or double quotes) are
used to determine what is text, so you can have test;test;test which results in
three cells of test after import. Making 'test;test;test' and set the text
delimiter to single quote on import will open a single cell with content
test;test;test .

Your example mixes these settings up, making test;'test';test';'test;'test this
an almost faulty snippet of csv data.

So the information you need is that a starting quote needs an ending quote and
all between these two quotes is interpreted as text.

It's the way it must work according to the 'specifications'.

So I have to close this Issue as invalid. Sorry for no better reply.

Frank
Comment 4 frank 2007-08-07 13:29:26 UTC 
closed inv