Hi Geoff, On Thu, 2011-07-14 at 08:04 -0700, floridabrits wrote:
> 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. > If I understand you problem, you want to show the currency in a user defined manner. One possibility is to have a cover worksheet that summarizes the data in any currency. You might use a macro to set the proper currency and exchange rates. One idea that might make finding all the cells with data to be converted is to name each one as a one-cell range (ex the cell sheet4!C3 is named 'Fred'). -- Jay Lozier [email protected] -- 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
