Bug 132957 - importing a csv file into Calc
Summary: importing a csv file into Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-05-11 15:47 UTC by gmarco
Modified: 2020-05-11 20:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
snip1 (75.57 KB, image/jpeg)
2020-05-11 15:47 UTC, gmarco
Details
snip2 (83.32 KB, image/jpeg)
2020-05-11 15:48 UTC, gmarco
Details
snip3 (151.50 KB, image/jpeg)
2020-05-11 15:50 UTC, gmarco
Details
snip4 (113.36 KB, image/jpeg)
2020-05-11 15:51 UTC, gmarco
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gmarco 2020-05-11 15:47:39 UTC
Created attachment 160674 [details]
snip1

Problem: importing a csv file into Calc.
Opening a file.csv with Calc we get an import screen with oriental characters and no possibility of obtaining a different view (see attachment LOC-importCSV 1).
I found that the only way to import usable data is to open the file.csv with WordPad (LOC-importCSV 2a attachment) and then copy it into Calc as "unformatted text" (LOC-importCSV 2b and 2c attachments).
Why? is it a bug?
Comment 1 gmarco 2020-05-11 15:48:34 UTC
Created attachment 160675 [details]
snip2
Comment 2 gmarco 2020-05-11 15:50:35 UTC
Created attachment 160676 [details]
snip3
Comment 3 gmarco 2020-05-11 15:51:44 UTC
Created attachment 160677 [details]
snip4
Comment 4 Ming Hua 2020-05-11 16:10:53 UTC
(In reply to gmarco from comment #0)
> Opening a file.csv with Calc we get an import screen with oriental
> characters and no possibility of obtaining a different view (see attachment
> LOC-importCSV 1).
Have you tried changing the character set choice ("Tipo di carattere" in your screenshot) from UTF-16 to something more suitable for your system?  Either some western european encoding, or UTF-8?
Comment 5 gmarco 2020-05-11 17:30:36 UTC
(In reply to Ming Hua from comment #4)
> (In reply to gmarco from comment #0)
> > Opening a file.csv with Calc we get an import screen with oriental
> > characters and no possibility of obtaining a different view (see attachment
> > LOC-importCSV 1).
> Have you tried changing the character set choice ("Tipo di carattere" in
> your screenshot) from UTF-16 to something more suitable for your system? 
> Either some western european encoding, or UTF-8?

Good, any other encoding gets OK.
Why Calc shows UTF-16 as default? The problem is not in WordPad, it opens the file without asking anything!
Comment 6 Ming Hua 2020-05-11 17:58:16 UTC
(In reply to gmarco from comment #5)
> Good, any other encoding gets OK.
I'm closing this bug then.  If you disagree feel free to REOPEN and add a short comment for the reason.

> Why Calc shows UTF-16 as default?
The default is not UTF-16 for everyone, it likely depends on the user's system and locale.  Since you didn't provide any information about your system, I have no idea.

Also if I remember correctly it remembers your choice from last time, so you only need to set it manually once if you always use the same encoding.
Comment 7 gmarco 2020-05-11 20:01:42 UTC
OK, thanks