Configure, Change or Set OpenOffice.org to Default Save Files in Microsoft Office Formats

»»»Configure, Change or Set OpenOffice.org to Default Save Files in Microsoft Office Formats
OpenOffice.org (OOo) is a free office and business productivity suite that is a good alternative to costly Microsoft Office suite. Not only is OpenOffice.org is free to download, use and distribute, it’s also an open-source project, multiplatform, multilingual and compatible with all other major office suites, including Microsoft Office 2003, XP, 2000 and 97, with support for Office 2007 slated in upcoming release of OpenOffice. The problem is the other way round is not true, as Microsoft Office does not support OpenOffice.org file formats by default.

OpenOffice.org support most Microsoft Office file formats, and can open and import Microsoft Office files such as Word documents, Excel workbooks and PowerPoint presentations. But Microsoft Office Word, Excel and PowerPoint do not support and cannot open OpenOffice file formats by default, thus making sharing of documents and files across platform difficult, especially if you want to send a file to a Microsoft Office user, or you have a mix of Microsoft Office users in your organization. So, for sharing or viewing and editing of documents with Microsoft Office programs, the files must be saved in a Microsoft Office format or in .rtf.

By default, OpenOffice.org will save in native file formats and extensions, i.e. Writer documents in .sxw (document) or .stw (template), Calc spreadsheets in .sxc (document) or .stc (template) and Impress presentations in .sxi (document) or .sti (template). So if you always want to save the files in Microsoft Office compatible formats such as Word .doc or .dot, Excel .xls or PowerPoint .ppt, you can configure OpenOffice.org to set or change the default file format for the document file type so that it will always save in Microsoft Office format, without the need to select the file format every time when saving a file.

To change or set default file saving or “save as” format for new files in OpenOffice.org:

  1. Launch any OpenOffice.org application such as OpenOffice Writer.
  2. Click on Tools and then Options.
  3. Expand the Load/Save section in the left pane by clicking the + (plus sign).
  4. Click on General under the Load/Save section.
  5. In the area labeled as “Default file format” or “Default file format or ODF settings” near the bottom of the dialog window, select the type of document you want, for example, Text document for Writer files, Spreadsheet for Calc, or Presentation for Impress, in the Document type drop-down list.
  6. To the right dropdown list labeled as Always save as, change or select the format as Microsoft Word 97/2000/XP.
  7. Repeat the above 2 steps for other documents such as spreadsheets or presentations that you want to save in Microsoft Office file format, and select the appropriate default save as format for them.
  8. Click OK to save the settings.
  9. From now on, whenever you want to save a document, the default format will be .doc, .xls or .ppt and other Microsoft Office file formats and extensions.

    OpenOffice.org Save File Format

Change default file save format in OpenOffice.org

You can also make the change to default format for saving files in OpenOffice.org by modifying setup-calc.xcu, setup-writer.xcu and setup-impress.xcu files located in C:\Program Files\OpenOffice.org 2.0\share\registry\modules\org\openoffice\Setup folder. This method or workaround is useful when you want to set the default save format for multiple users and computers, where you can create a simple batch file or Unix script to copy the modified .xcu files to the Open Office installation directory and replace the existing one.

For OOo Writer:

Edit the following lines to the following value in setup-writer.xcu (this same default filter line appears twice in this file):

<prop oor:name="ooSetupFactoryDefaultFilter">
<value>MS Word 97</value>

For OO Calc:

Edit the following line to looks like below in setup-calc.xcu:

<prop oor:name="ooSetupFactoryDefaultFilter">
<value>MS Excel 97</value>

For OOo Impress:

Edit the following line to the following value in setup-impress.xcu:

<prop oor:name="ooSetupFactoryDefaultFilter">
<value>MS PowerPoint 97</value>

Note: In Unix or Linux, the files may start with the capital S.

By | 2016-12-09T08:40:36+00:00 December 9th, 2016|Categories: Office|Tags: |13 Comments

About the Author:

LK is a technology writer for Tech Journey with background of system and network administrator. He has be documenting his experiences in digital and technology world for over 15 years.Connect with LK through Tech Journey on Facebook, Twitter or Google+.
  • Pingback: Saving default as .doc in Openoffice()

  • Jen

    Thank you so much! I've been looking for a step by step guide to change the default saving format. Thank you!!!

  • and climb I grew for a while, to ramble these trees I went parents most these trees pruning

  • Pingback: What I did to make the Everex ready for patrons — Fiddling Librarian 3.0()

  • Pingback: restoring deleted MS word application()

  • Scott

    This doesn't seem to work for OpenOffice.org 3.0

    I've made the changes to Setup_calc.xcu, Setup_writer.xcu, and Setup_impress.xcu but when I try to Save As, the .ODT file format is still the default for writer, ODS is still the default for calc, etc.

    What would I have to do in order to get this working with OpenOffice.org 3.0?

  • Edward S

    Somehow many of my OPENOFFICE documents do not open in OPEN OFFICE, but open in word pad. How can I reset openoffice documents so they all open with .od form

  • Edward S

    June 22nd, 2010 00:55

    9 Somehow many of my OPENOFFICE documents do not open in OPEN OFFICE, but open in word pad. How can I reset openoffice documents so they all open with .od form

    REPAIR ERROR – I gues I meant .odt

    BEGGINER SEND ANSWER TO bce3000bce@yahoo.com

  • paul

    great!! exactly what I needed to know. Only problem I had was that under the "Presentation" document type, there were two options that were identical. There were two Microsoft Powerpoint 97/2000/XP options. I didn't know what to pick, so I just chose the first one (closest to the top) and I think that it works. =D

  • Ollie Webb

    Does anyone know how to change the default save location using the configuration file?

    Ollie

  • Manush

    Bingo…perfect… thanks a ton….

  • Pingback: HOW TO: stream OpenOffice.org 3.2.1 on XenApp 6 | DesktApp.IT()

  • Anne

    Is there any way to make OpenOffice not change the file type? If I open a .doc file and edit it, I want to save it as a .doc. If I open a .odt file and edit it, I want to save it as an .odt. Somehow, I do not seem to get this done. Thanks!

Pin It on Pinterest

Share This

Share This

Share this post with your friends!