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

Hi,
in my spreadsheets there I usually have a special sheet named Parameters
where I set some varying values such as
- company name
- period (weeknumber, year, month etc.)
- local currency name or sign
- other currencies used
- and other ...

Besides that I have a "Work" sheet which remains hidden from printing
and eventually locked from users which sheet contains only supporting
formulas and computations based on the parameters and data enterd 
somwhere else.
It usually contains current exchange rates vlookup-ed in a separate 
spreadsheet.

Currency used in the report is usually placed in the report header
( first several rows of the sheet) e.g. "All numbers in EUR" (that is as 
a formula for example ="All numbers in "&$Parameters.$D$4 )
or in the column headers of the report actually linked from "Parameters" 
or "Work".
Changing the currency is then only a matter of adjusting the 
"Parameters" sheet.

I never use the number format with currency sign, as the reports are 
better readible, it saves the column width (and the printer toner) and 
usualy there are not mixed financial values with kilometers, liters or 
emploies number :)

Regards,
Jiri

Dne 14.7.2011 20:58, Twayne napsal(a):
> In news:1310666739.4101.16.camel@planas-pinguy,
> planas<jslozier@gmail.com>  typed:
> > 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
>
> You could only make that work if you included a look-up on the exchange
> rates for every monetary system you wanted to use as they change daily, even
> hourly in some cases, and a number today m,ight not be accurate tomorrow.
> How much accuracy do you requre in other words? You could take a bath in
> some cases.
>
> Otherwise, just set up your currency multipliers in hidden columns and do
> the multiplication.
>
> HTH,
>
> Twayne`

--
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