Euro Converter Wizard

Converts the currency amounts found in Office Calc documents and in fields and tables of Office Writer documents into euros.

Only closed files are converted. It is possible, however, to use the Euro Converter in an open Office Calc document. In this case, a separate dialogue box opens. This dialogue box is described at the end of this section.

To access this command...

Choose File - Wizards - Euro Converter.

Only the currencies of the countries participating in the European Monetary Union are converted.

Extent

Single Office Calc document

Converts a single Office Calc file. To convert fields and tables in Office Writer, first mark the Also convert fields and tables in text documents check box.

Complete Directory

Converts all Office Calc and Office Writer documents and templates in the selected directory.

Currencies

Specifies the currency to be converted into euro.

Source directory / Source Document

Indicates the directory or the name of the single document to be converted.

...

Opens a dialogue box to select the desired directory or document.

Including Subfolders

Specifies whether all sub-folders of the selected directory are included.

Also convert fields and tables in text documents

Converts currency amounts found in fields and tables of Office Writer documents.

Values in the text document that are not in fields or tables are not converted.

Temporarily unprotect sheet without query

Specifies that sheet protection will be disabled during conversion and thereafter re-enabled. If sheet protection is covered by a password, you will see a dialogue box for entering the password.

Target Directory

Specifies the folder and path in which the converted files are to be saved.

...

Opens a dialogue box in which you can select a directory to hold the converted files.

Cancel

Closes the Euro Converter.

Help

Activates the help for the dialogue box.

Convert

Starts the conversion.

During conversion, a page showing the progress status is displayed.

Back

Returns to the first page of the Euro Converter.

If the current document is a Office Calc document or template, you can call up the Euro Converter using the corresponding icon in the Tools bar. This icon is hidden by default. To display the Euro Converter icon, click the arrow at the end of the Tools bar, select the Visible Buttons command and activate the Euro Converter icon.

The Euro Converter dialogue box contains the following functions:

Entire document

Converts the entire document.

Currencies

Specifies the currency to be converted into euro.

Selection

Select the cells you want to convert in this range, if you did not mark the Entire document check box. Select an option and then click the desired entries in the Templates / Currency ranges field. The selected range will be visible as such in the document. Click Convert to carry out the conversion.

Cell Styles

All cells with the selected Cell Styles are converted.

Currency cells in the current sheet

All currency cells in the active spreadsheet will be converted.

Currency cells in the entire document

All currency cells in the active document will be converted.

Selected range

All currency cells in the range selected before the converter was called will be converted. All cells must have the same format so that they can be recognised as a selected range.

Templates / Currency ranges

Displays the ranges to be converted from the list.