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?
Created attachment 160675 [details] snip2
Created attachment 160676 [details] snip3
Created attachment 160677 [details] snip4
(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?
(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!
(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.
OK, thanks