On 09/04/2008 16:06, Joe Grech wrote:
Hi, recently I had to convert a list of currencies to the Maltese Euro in the
Calc spreadsheet but alas it has been left out in the Convert Currencies list.
Ugh!
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
I think that what you mean is that the Maltese *Lira* is not on the
list. That's true and even though Malta only changed from their Lira to
the Euro on 1 Jan '08 its a shame. The exchange rate is 0.429300 MTL per
1 Euro so unless you have a lot of files to convert it's not hard.
I haven't found a way to hack the wizard but assuming you are using OOo
2.4 on Windows you can add the MTL to the list of available currencies
known to the CONVERT function by editing the text file "c:\program
files\openoffice.org
2.4\share\registry\data\org\openoffice\office\calc.xcu". The text to be
added is
==== begin text to add ===
<node oor:name="CR14" oor:op="replace">
<prop oor:name="FromUnit">
<value>EUR</value>
</prop>
<prop oor:name="ToUnit">
<value>MTL</value>
</prop>
<prop oor:name="Factor">
<value>0.429300</value>
</prop>
</node>
=== end text to add ===
Add this text *after* the "</node> associated with CR13. Be sure to quit
OOo and the Quickstarter before editing this file. Be sure too to take a
backup copy of the file before you start.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
