Joined: Sep 18, 2003 Posts: 434 Location: London, UK
Posted: Fri Dec 16, 2005 1:16 pm Post subject:
From Help>Contents>Contents>Spreadsheets>Function Types and Operators>Mathematical Functions
Code:
CONVERT
This function allows you to convert a currency value of a European currency into Euros. The conversion factors are stored in the calc.xml file, which is located in the {installpath}/share/config/registry/instance/org/openoffice/Office/ directory.
Syntax:
CONVERT(value;"Text"; "Text")
Value is the amount in the currency to be converted.
Text is the official abbreviation for the currency in question (for example, "EUR"). The first Text parameter gives the source value to be converted, the second Text parameter gives the destination value.
Example:
=CONVERT(100;"ATS";"EUR") converts 100 Austrian Schilling into Euro.
=CONVERT(100;"EUR";"DEM")converts 100 Euro into German Mark.
The table shows you the names of the currencies and the rates of exchange with the Euro set by the European Commission. The basis of calculation is 1 Euro. For more information on this go to http://europa.eu.int/eurobirth/rates.html.
Does that help? _________________ PBG4, 1.5GHz, SuperDrive, 1GB RAM, 128MB VRAM, 5400rpm 80GB HD, MacOS X 10.4.5
Joined: Sep 18, 2003 Posts: 434 Location: London, UK
Posted: Fri Dec 16, 2005 1:21 pm Post subject:
Furthermore there is CONVERT_ADD which does the equivalent for measurements in place of currencies.
In Calc, click the Autopilot: Functions button (or select Insert>Function... from the menubar) and scroll down the list of functions to the CONVERT options:
Joined: Sep 18, 2003 Posts: 434 Location: London, UK
Posted: Sat Dec 17, 2005 2:45 am Post subject:
Hi James,
it appears that NeoOffice probably can do this, but it is spread out over a number of different functions depending on the conversion required. Those are BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, etc:
it appears that NeoOffice probably can do this, but it is spread out over a number of different functions depending on the conversion required. Those are BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, etc:
Thanks, JKT.
I'm looking for something like this. I have a requirement to do this for a project that I'm working on for my 'real' job.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum