3 ms·
Importing of CSVs is a joke in both OO and LibreOffice - I literally have to rename files to .csv to get them to interpret .txt (or other extensions) as comma-s
by berkut 12y ago
Importing of CSVs is a joke in both OO and LibreOffice - I literally have to rename files to .csv to get them to interpret .txt (or other extensions) as comma-separated - there's no nice "Import" menu like Excel has had for decades.
Even opening Calc first then using its menu to open a .txt opens the file in LibreOffice Writer!
And then of course Gnome's (on Linux) file browsers no longer support renaming of files in the browsers, so you have to mess around elsewhere.
- chris_wot 12y agoHave you considered filing a bug report?
- stinky613 12y agoI had no idea that LibreOffice can't be forced to recognize that a .txt file is CSV; that sounds annoying. Watch out, though, for handling CSV files in Excel if you're using an encoding other than ANSI. Excel for Windows does not correctly write UTF-8 files[1] Excel for Mac lists 'UTF-8' as an import CSV encoding option but Excel for Mac does not import UTF-8 CSV files[2] [1]Response from MS employee: "Unfortunately, not all applications can encode files in UTF-8 by default, and Microsoft Excel is one of them." http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/how-can-i-save-a-csv-with-utf-8-encoding-using/12801501-c1e4-4a64-80d9-96b680b64cfe http://answers.microsoft.com/en-us/office/forum/office_2013_... [2]Response from MS employee: "Excel for Mac does not currently support UTF-8" -- despite UTF-8 being an option in Excel for Mac http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/mac-excel-converts-utf-8-characters-to-underlines/7c4cdaa7-bfa3-41a2-8482-554ae235227b http://answers.microsoft.com/en-us/mac/forum/macoffice2011-m...
- ac29 12y agoFile a bug report, it works fine for me.