I work within my spreadsheets, save, close & when I reopen they want to open as text files.
Pleas, what fIle format for save, LibreOffice version an OS?
If you are using Win10, you can try right-click on the file → OpenWith → ‘Choose another app’ .
On GNU/Linux, it should be similar