I know with LibreOffice Writer you can have it so when you save a file it will save it as a docx file by default. Is there a way to do the same for Calc and & Impress? And if not can this please be added as a new feature?
Yes. Done from Tool → Options → Load/Save → General panel.
In the Default File Format and ODF Settings section there is a drop list for “Document type” and below that a drop list for “Always save as”.
Select Spreadsheet for the document type and Excel 2007-2019 (or an Office Open XML Spreadsheet if standards concerned). The pairing will be recorded to the LibreOffice user profile.
However–these formats are not “native”, they are export filters and on roundtrip use an import filter to bring them back into LibreOffice. Integration of ODF standard(s) formatting is much tighter. Unless you have a real reason to work in Microsoft XML you’d have more reliable document handling in “native” ODF.
Thank you! All I needed to do was switch the document type.