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
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.