Choosing options for loading and saving documents

From Apache OpenOffice Wiki
Jump to: navigation, search

You can set the Load/Save options to suit the way you work. This chapter describes only a few of the options, those more relevant to working with Calc. See Setting Up in the Getting Started guide for a description of the other options.

If the Options dialog is not already open, click Tools > Options. Click the + sign to the left of Load/Save to display the list of load/save options pages.

Load/Save options

General Load/Save options

Most of the choices on the Load/Save – General page are familiar to users of other office suites. Those specific to are in the Default file format and ODF settings section.

Choosing Load and Save options

ODF format version by default saves documents in OpenDocument Format (ODF) version 1.2. While this allows for improved functionality, there may be backwards compatibility issues. When a file saved in ODF 1.2 is opened in an earlier version of (using ODF 1.0/1.1), some of the advanced features may be lost. Two notable examples are the functions ADDRESS and INDIRECT and the formatting of numbered lists. If you plan to share documents with people who are still using older versions of, it is recommended that you save the document using ODF version 1.0/1.1.

Size optimization for ODF format documents are XML files. When you select this option, OOo writes the XML data without indents and line breaks. If you want to be able to read the XML files in a text editor in a structured form, deselect this option.

Document type

If you routinely share documents with users of Microsoft Excel, you might want to change the Always save as attribute for text documents to one of the Excel formats.

VBA Properties Load/Save options

On the Load/Save – VBA Properties page, you can choose whether to keep any macros in Microsoft Office documents that are opened in

Choosing Load/Save VBA Properties
  • If you choose Save original Basic code, the macros will not work in but are retained if you save the file into Microsoft Office format.
  • If you choose Load Basic code to edit, the changed code is saved in an document but is not retained if you save into an Microsoft Office format.
  • If you are importing a Microsoft Excel file containing VBA code, you can select the option Executable code. Whereas normally the code is preserved but rendered inactive (if you inspect it with the StarBasic IDE you will notice that it is all commented), with this option the code is ready to be executed.

Microsoft Office Load/Save options

On the Load/Save – Microsoft Office page, you can choose what to do when importing and exporting Microsoft Office OLE objects (linked or embedded objects or documents such as spreadsheets or equations).

Select the [L] options to convert Microsoft OLE objects into the corresponding OLE objects when a Microsoft document is loaded into OOo (mnemonic: “L” for “load”).

Select the [S] options to convert OLE objects into the corresponding Microsoft OLE objects when a document is saved in a Microsoft format (mnemonic: “S” for “save”).

Choosing Load/Save Microsoft Office options

HTML compatibility Load/Save options

Choices made on the Load/Save – HTML Compatibility page affect HTML pages imported into and those exported from OOo. See HTML documents; importing/exporting in the Help for more information.

The main items of interest for Calc users are in the Export section: Basic and Display warning.

Export - Basic

Select this option to include OOo Basic macros (scripts) when exporting to HTML format. You must activate this option before you create the Basic macro; otherwise the script will not be inserted. Basic macros must be located in the header of the HTML document. Once you have created the macro in the Basic IDE, it appears in the source text of the HTML document in the header.

If you want the macro to run automatically when the HTML document is opened, choose Tools > Customize > Events. See Calc Macros for more information.

Export - Display warning

When the Basic option (see above) is not selected, the Display warning option becomes available. If the Display warning option is selected, then when exporting to HTML a warning is shown that Basic macros will be lost.

Choosing HTML compatibility options

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools