https://bugs.documentfoundation.org/show_bug.cgi?id=172905
--- Comment #9 from ady <[email protected]> --- Indeed attachment 207904 seems to be recognized (by using some plain text editors) as an ANSI file (not Unicode). Optionally, using a plain text editor (among other possibilities), the csv file can be converted to UTF-8. Now, regarding this report, I believe that the "problem" is the interpretation of the term "Automatic" for the "Character set" field. Currently Calc is not really able to "automagically detect" an adequate Character Set on a simple plain csv file (which _might_ be hypothetically possible by means of some "flags" that could potentially be included in a csv file, IIUC). The term "Automatic" for the "Character set" field in the import dialog does not mean "Calc can automatically detect by itself an adequate character set"; I believe it just means "use whatever the OS is using as its default character set". In practical terms, what users could actually do is to set an adequate character set when the text file to be imported does not match their own OS. The settings in the Import dialog are remembered for later occasions, so if you are using the same type of file repeatedly you don't need to modify the import settings more than once for the same task. The alternative would be to have the text file pre-processed / converted to Unicode before importing it in Calc. As for improving Calc, IDK whether there is a possible better label. My guess is that this has been discussed in the past. Or perhaps I am misremembering the real meaning of the "Automatic" label for the Character set field, in which case I am wasting everyone's time with this comment. -- You are receiving this mail because: You are the assignee for the bug.
