Issue 2162 - File->Open->Text CSV opens in word processor, not spreadsheet
Summary: File->Open->Text CSV opens in word processor, not spreadsheet
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 638
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords:
: 55512 (view as issue list)
Depends on:
Blocks:
 
Reported: 2001-11-09 17:19 UTC by Unknown
Modified: 2015-02-02 20:15 UTC (History)
2 users (show)

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

Attachments
Comma separated value format (384 bytes, text/plain)
2001-11-14 15:09 UTC, Unknown 		no flags Details
space-separated values (377 bytes, text/plain)
2001-11-14 15:10 UTC, Unknown 		no flags Details
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 Unknown 2001-11-09 17:19:20 UTC 
I have a CSV file. When I open the file, selecting Text CSV as the file type,
the document is opened as plain text in the word processor, not in a tabular
format in the spreadsheet as expected.

In issue 1834 (http://www.openoffice.org/issues/show_bug.cgi?id=1834) Falko
Tesch indicates this is working, but it's not for me.
Comment 1 peter.junge 2001-11-12 10:51:49 UTC 
Hi Brian,
do you try to open it with the menu or with the quickstarter?
Regards, Peter
Comment 2 Unknown 2001-11-12 18:54:23 UTC 
I t ried to open it from the menu in the spreadsheet.
-Brian
Comment 3 peter.junge 2001-11-13 09:24:21 UTC 
Sorry Brian,
my question was stupid anyway because you're using linux ;-)
I have to reboot.
Regards, Peter
Comment 4 peter.junge 2001-11-14 09:03:08 UTC 
Hi Brian,
I cannot reproduce it with a 638c on Suse 7.3. Could you please attach
a document which causes the issue. I have to find out what is specific
about your files.
Regards, Peter
Comment 5 Unknown 2001-11-14 15:09:33 UTC 
Created attachment 708 [details]
Comma separated value format
Comment 6 Unknown 2001-11-14 15:10:09 UTC 
Created attachment 709 [details]
space-separated values
Comment 7 Unknown 2001-11-14 15:11:12 UTC 
Both of the attachments hours.csv and hours.txt open in the word
processor, not the spreadsheet.
Comment 8 peter.junge 2001-11-19 12:33:29 UTC 
Hi,
reproduced the issue with the attached files. The point of failure
seems to be the last line in both files. After the file is opened in
Writer the last line reads '22299306'. Opened in vi shows
'22299306^@,,,' in the CSV file and '22299306^@' in the TXT file.
After deleting this line everything works fine.
Regards, Peter
Comment 9 ooo 2001-11-20 20:04:51 UTC 
What is shown as `^@' in vi is a NULL byte in this case. The
spreadsheet filter detection doesn't accept NULL bytes as valid
characters in a CSV file. The tool generating those files should be
considered broken instead.
Comment 10 peter.junge 2001-12-03 16:00:56 UTC 
No further comment for over a week. -> closed
Comment 11 aziem 2005-10-07 02:07:49 UTC 
*** Issue 55512 has been marked as a duplicate of this issue. ***