Hello LibreOffice fans... I'm looking for some help with calc on a spreadsheet that I have set up. I'm not sure if it needs a macro set up, or if there's something in LibreOffice that will do this for me, or if I have to seek custom development to do this....
Here's the problem: - I have a large risk management spreadsheet that contains a number of cells with currency based risk numbers in it; some of these are manually entered by the user and some are calculated from cells where the user enters the information. - Currently, the financial risk cells are all in USD ($) currency. - If I have a user in another country that wants to use this spreadsheet, I'd like that person to be able to either press a button, or select from a drop-down list, a list of available currencies to choose from. - When they choose their currently, I want a macro (or something!) to go and find all the US currency based cells in the spreadsheet and change them to the currency selected by the user. - If I can get this to work, then this spreadsheet could pretty much be used in any country/currency and the user would not have to go into every single currency based cell and make the changes needed (which would be time prohibitive). - i.e. Looking for a minimum click solution to achieve this. I do realize that the local install will change the currency for the user by default, but I want to be able to over-ride this so that if a local user sees the spreadsheet in USD and changes it to, for example, GBP, then when he sends it back to me, I see the numbers in GBP and not my local language setting (which would default back to USD). I hope I have explained this clearly! If not please don't hesitate to ask... Has anyone done this before or have any ideas how to achieve what I am looking for? Many thanks in advance. Regards, Geoff -- View this message in context: http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169381.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
