Calc Guide

features may be lost. Two notable examples are cross-references to headings and
the formatting of numbered lists. If you plan to share documents with people who
are still using older versions of OpenOffice.org, 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.
Note
Although OOo can open files in the .xlsx format produced by Microsoft
Office 2007, it cannot save in this format. This capability is planned for
a future release.
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 336: Choosing Load/Save VBA Properties
• If you choose Save original Basic code, the macros will not work in
OpenOffice.org 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
OpenOffice.org 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.
348 OpenOffice.org 3.3 Calc Guide