Calc Guide

• 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.
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 OpenOffice.org OLE objects when a Microsoft document
is loaded into OOo (mnemonic: “L” for “load”).
Select the [S] options to convert OpenOffice.org OLE objects into the
corresponding Microsoft OLE objects when a document is saved in a
Microsoft format (mnemonic: “S” for “save”).
Figure 320: Choosing Load/Save Microsoft Office options
398 OpenOffice.org 3.x Calc Guide