Issue 28017 - Importing CSV Unicode Files
Summary: Importing CSV Unicode Files
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-20 13:36 UTC by jmberthier
Modified: 2004-07-15 16:02 UTC (History)
1 user (show)

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

Attachments
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 jmberthier 2004-04-20 13:36:57 UTC 
It is not possible to import CSV files in UNICODE format in the SpreadSheet.
The file is always imported to the Word Processor.
You need to record the file in ANSI or UTF-8 to be able to import inside the 
SpreadSheet.
Comment 1 frank 2004-04-21 10:33:52 UTC 
Hi,

I was not able to reproduce what you're facing.

Please attach a document that will not be opened by Calc and describe step by
step how you're proceeding.

Frank
Comment 2 frank 2004-05-07 13:11:51 UTC 
As I've got no response and can't reproduce it, I close this Issue as worksforme.

Frank
Comment 3 frank 2004-05-07 13:12:10 UTC 
closed wfm
Comment 4 marianaccio 2004-07-15 15:20:33 UTC 
fts,
I confirm this bug.
I am using OO.o 1.1.2 (Italian) on a PC with XP prof as OS.
The procedure, for importing data in a spreadsheet from an external CSV 
file, stops at the 2nd window, showing the sub-window "available 
sections/tables" to be filled.
But it cannot be filled ---> so the button OK cannot be clicked and the import 
does not happen!. 

The text file is attached below.
I have also prepared 2 jpg files showing the windows, but I don't know how to 
attach graphic files this comment (If they can be useful, send me an email).

Mariano
Italy
----------------------------------- attachment (txt file) -------
ENERGIA E PETROLIO IN ITALIA
81
Prezzo Componente Prezzo alla
industriale fiscale pompa
1985 (*) 0,244 0,484 0,728
1990 0,204 0,534 0,738
1991 0,197 0,567 0,764
1992 0,203 0,560 0,763
1993 0,221 0,568 0,789
1994 0,216 0,601 0,817
1995 0,234 0,653 0,887
1996 0,250 0,676 0,925
1997 0,262 0,680 0,943
1998 0,230 0,679 0,909
1999 0,258 0,699 0,956
2000 0,380 0,702 1,082
2001 0,352 0,699 1,052
2002 0,331 0,716 1,047
1/11/2003 0,328 0,716 1,044
PREZZI DELLA BENZINA SUPER SENZA PIOMBO
(Euro/litro media annua)
(*) Prezzo a fine anno.
Fonte: Ministero delle Attività Produttive, UP
Comment 5 frank 2004-07-15 16:02:13 UTC 
Hi Mariano,

what you're facing has nothing in common with unicode txt files. Your problem is
that youwant to use Insert External Data with a non valid data type. This is
covered by Issue 1834.

Frank