Ask Your Question
0

Calc: file extension xlsx not available in save as picklist?

asked 2019-07-09 22:22:29 +0100

mah55 gravatar image

I have a file that is .xlsx. Calc opens it and allows me to edit just fine but when I press 'save' the 'save as' box appears and then the file type picklist does not have .xlsx as an option. It has several Excel options up to .xls (97/2000/XP). If I save as .xls then neither Excel no Calc will open the file again. If I save as .ods then Calc opens the file with what appears to be several dozen blank text boxes on top of my spreadsheet which takes a long time to delete... Any idea what is going on??

edit retag flag offensive close merge delete

Comments

What version of LibO are you using and SO?

Schiavinatto gravatar imageSchiavinatto ( 2019-07-09 23:53:24 +0100 )edit
2

LibreOffice was always able to save as XLSX - right from the beginning, since its version 3.3. I suppose that you might be using Apache OpenOffice, which can't export to OOXML formats even today.

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-10 06:50:15 +0100 )edit

Thank you @Mike Kaganski, again learned something.

ebot gravatar imageebot ( 2019-07-10 06:59:06 +0100 )edit

Aha! Yes I was using Apache OpenOffice. I got a new laptop recently and downloaded quickly and it all looks the same. I've now switched over and it's working fine. What a gap for OpenOffice to not be able to do this! Thanks all for your help.

mah55 gravatar imagemah55 ( 2019-07-10 20:46:11 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-10 06:47:44 +0100

ebot gravatar image

updated 2019-07-10 07:00:12 +0100

You can select the file type xlsx.

image description

edit flag offensive delete link more

Comments

With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: 6.2.5.2 (x64).

ebot gravatar imageebot ( 2019-07-10 06:48:03 +0100 )edit

Thanks- me being an idiot and using Apache OpenOffice instead!

mah55 gravatar imagemah55 ( 2019-07-10 20:46:51 +0100 )edit

Man himself is constructed to make mistakes. That's nothing bad.

ebot gravatar imageebot ( 2019-07-11 08:10:07 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-09 22:22:29 +0100

Seen: 48 times

Last updated: Jul 10