Calc Guide

HTML compatibility Load/Save options
Choices made on the Load/Save – HTML Compatibility page
(Figure 321) affect HTML pages imported into OpenOffice.org 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:
OpenOffice.org Basic and Display warning.
Export - OpenOffice.org Basic
Select this option to include OOo Basic macros (scripts) when
exporting to HTML format. You must activate this option before you
create the OpenOffice.org Basic macro; otherwise the script will not
be inserted. OpenOffice.org Basic macros must be located in the
header of the HTML document. Once you have created the macro in
the OpenOffice.org 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
Chapter 12 (Calc Macros) for more information.
Export - Display warning
When the OpenOffice.org 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 OpenOffice.org Basic macros will be lost.
Figure 321: Choosing HTML compatibility options
Chapter 14 Setting up and Customizing Calc 399