How-To: Set the default save file format to Microsoft Excel - OpenOffice.org Calc
- To set the default file format when saving spreadsheets to Microsoft Excel format, first click on the "Tools" Option here.
- Then, on the menu that opens, click on the option "Options..."
- The OpenOffice options dialog should open. You should see a menu tree here. For clarity's sake, first we shall close the OpenOffice.org options by clicking on this "minus" sign.
- Now look for the "Load/Save" option and click on the "plus" sign beside it to view a submenu.
- Once the new options appear, click on "General."
- You should see the different loading and saving options on this part of the window.
- Look for the default file format options here and click on this down arrow.
- This lets you choose the document type that we will change the save settings for. Since we want to change the save settings for spreadhsheets, click on "Spreadsheet."
- Now to choose the default file format for saving, click on this down arrow here.
- Then, on the menu that drops down, look for the "Microsoft Excel 97/2000/XP" option and click on it once.
- Afterwards, just click on "OK."
- Now, to check, click on the "File" option here.
- Then, on the menu that opens, click on the option "Save As."
- As you can see, the default format for saving files has been set to Microsoft Excel. Congratulations!
powered by Plan-B screencast technology
Set the default save file format to Microsoft Excel
This screencast demonstrates how to set the default save file format
to Microsoft Excel.
You learn:
- How to access the Options Dialog.
- How to set the default save file format to Microsoft Excel.
Other file formats
You can set the default save format in OpenOffice Calc to other file formats, not just Microsoft Excel. All the formats supported are as follows
| File Formats | Formats cont'd |
|---|---|
| Data Interchange Format | OpenOffice.org 1.0 Spreadsheet |
| dBase | OpenOffice.org 1.0 Spreadsheet Template |
| HTML Document (OpenOffice.org Calc) | Pocket Excel |
| Microsoft Excel 2003 XML | StarCalc 3.0 |
| Microsoft Excel 5.0 | StarCalc 3.0 Template |
| Microsoft Excel 5.0 Template | StarCalc 4.0 |
| Microsoft Excel 95 | StarCalc 4.0 Template |
| Microsoft Excel 95 Template | StarCalc 5.0 |
| Microsoft Excel 97/2000/XP | StarCalc 5.0 Template |
| Microsoft Excel 97/2000/XP Template | SYLK |
| OpenDocument Spreadsheet (Default) | Text CSV |
| OpenDocument Spreadsheet Template | ... |
Advanced topics
For related functionality see:
- Set the default save file format to Microsoft Word
- Set the default save file format to Microsoft Powerpoint
- Disable the warning when not saving in the default file format
- Disable the warning when not saving in the default file format using the dialog window
OpenOffice.org™ is a trademark of OpenOffice.org.
