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

2011-07-15 Thread Hladůvka Jiří
Let, say that in "parameters" sheet you have - in A1 some label saying "Choose your currency" - in A2 some initial valu e.g. USD click to A2 and choose from Data -> Validity ->bookmark Criteria -> field Allow select "Cell range" and into field source enter link to the range where you have allo

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

2011-07-14 Thread jorge
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

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

2011-07-14 Thread planas
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

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

2011-07-14 Thread toki
On 07/14/2011 03:04 PM, floridabrits wrote: - 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. Create a specific cell style for curre

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

2011-07-14 Thread floridabrits
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