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