Calc Guide

ODF format version
OpenOffice.org 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
OpenOffice.org (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
OpenOffice.org, it is recommended that you save the document
using ODF version 1.0/1.1.
Size optimization for ODF format
OpenOffice.org 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 spreadsheets
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
OpenOffice.org.
Figure 319: Choosing
Load/Save VBA Properties
Chapter 14 Setting up and Customizing Calc 397