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.