I should double click on the file and it open correctly, like LibreOffice does when I set it as the default for this file type.

The problem is that Excel let you open a file with a random format. Same for LO, CSV data is usually so dirty that you shouldn't manage them without an proper loading process.

…but Excel already does it without a proper loading process and just breaks the files. LibreOffice figured this out. Just have a small modal that pops up when you open with sane defaults. This works the vast majority of the time.