Re: [libreoffice-users] Ability to change currency as needed across a spreadsheet in Calc?

Hi

        Excuse me but I think you have another problem (Not only change de
currency symbol):

        The type change currency between USD and other countries (If you want
that the people looks a correct value). 

Regards,

Jorge

________________



El jue, 14-07-2011 a las 14:05 -0400, planas escribió:
> 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
> jslozier@gmail.com

-- 
Atentamente,

Jorge Rodríguez


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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