Euro Converter Wizard

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

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

To access this command...

Choose File - Wizards - Euro Converter.


Warning Icon

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


Extent

Single Collabora Office Calc document

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

Complete Directory

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

Currencies

Specifies the currency to be converted into euros.

Source directory / Source Document

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

...

Opens a dialog to select the desired directory or document.

Including Subfolders

Specifies whether all subfolders of the selected directory are included.

Also convert fields and tables in text documents

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

Warning Icon

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 dialog for entering the password.

Target Directory

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

...

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

Cancel

Closes the Euro Converter.

Help

Activates the help for the dialog.

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 Collabora 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.

Icon

Euro Converter

The Euro Converter dialog contains the following functions:

Entire document

Converts the entire document.

Currencies

Specifies the currency to be converted into euros.

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 recognized as a selected range.

Templates / Currency ranges

Displays the ranges to be converted from the list.

Please support us!