Ask Your Question
0

Currency Covert Entire Calc Document [closed]

asked 2013-03-28 14:09:26 +0200

alabandit gravatar image

Hi

I have a complex document that is currently in Dollars and need to convert it to Euro's. Is there a simple way to do this?

Alternatively the document has a few base fields that I can convert manually and all the formula will correct to Euro equivalents. e.g. Item valued at $1000 is now €781.34.

But this still need me to adjust 100 of columns. Is there an easy way to do this with out changing all cell values of months, for instance, to have having a Euro symbol?

Thanks for you help!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-27 23:47:39.070683

Comments

It's about the formatting of the cells so that they reflect the € not the € icon in the cell. I have a working formula.

I have uploaded a simple example to dropbox, as I don't have any Karma yet, https://www.dropbox.com/s/oyjyk0d212uzx5k/example%20for%20currancy%20conversion.ods, the first table is my table in Dollars. The second table is in euro's but I can't get it to switch the format to euro's automatical

alabandit gravatar imagealabandit ( 2013-04-02 11:39:59 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2013-04-02 15:21:42 +0200

alabandit gravatar image

got the answer from jrkrideau at http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=60754&p=269285#p269285

Create a new Style. Or in a more detailed fashion : create a new Style from default and name it something like euro. Under the numbers tab select currency. The default currency formatting will appear in the box at the bottom of the window. You should get something that looks like

[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00

Replace the second $ signs with the € sign and you should get something like

[$€-1009]#,##0.00;[RED]-[$€-1009]#,##0.00

and you're done. Just paste the above code. Otherwise the € can be found in Insert > Special Characters >Currency Symbols.

edit flag offensive delete link more

Comments

The same thing would be changing number format for the necassary cells to currency and choosing a format with euro. I tried it on your sheet, at first nothing happened, but I tried deleting cell value that is used in calculations (F19 in your sheet) and wrote it again and after automatically re-calculating values, the currency changed too.

Aigars gravatar imageAigars ( 2013-04-02 17:36:31 +0200 )edit
0

answered 2013-03-29 00:09:15 +0200

m.a.riosv gravatar image

I think it should be possible with find and replace Ctrl+H using regular expressions, replacing values with =values/change.

But is needed more information on how the data are in the spreadsheet:
Are they the only numbers values in the range where they are?

Or with paste special Shit+Ctrl+V.
Insert the change value in a non used cell.
Copy from this cell.
Select the range to change.
Paste special - Operations - divide

edit flag offensive delete link more
0

answered 2013-03-29 03:16:00 +0200

ROSt52 gravatar image

I am not sure if this fits to the $-spreadsheet as it is built right now.

Assumption: your $ spreadsheet is on sheet$ and covers A1:D100 with cells containing $-values to be converted into EUR, and cells with other information which should not be changed

on sheet$=EUR place the conversion rate you want to you use in cell A1

on sheetEUR create links to sheet$ and wherever you need to recalculate the figures multiply with the exchange rate of A1 on sheet$-EUR but use absolute reference to A1, thus $A$1

Once this is done you might want to break the link

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-03-28 14:09:26 +0200

Seen: 2,074 times

Last updated: Apr 02 '13