thanks Twayne - I'm actually not interested in 'coverting' from USD to pick
your currency so exchange rates don't matter at all... all I really need
to do is be able to say hey, here's a spreadsheet that's in USD... if you
click on this button you can change the currency to pick your currency and
thanks Jay... I'll look into this and see if this is do-able/works...
/g
--
View this message in context:
http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3170427.html
Sent from the Users mailing list archive at Nabble.com.
--
Hi, Roland,
On 7/14/11 9:19 PM, Roland Hughes wrote:
Your bottom posting equates to the IQ of your logic.
snip
Bottom posters contribute so little to society
I've gotten tired of comments about which type of posting is correct.
My conclusion is, there is no absolute right or wrong
floridabrits wrote:
thanks Twayne - I'm actually not interested in 'coverting' from USD to pick
your currency so exchange rates don't matter at all... all I really need
to do is be able to say hey, here's a spreadsheet that's in USD... if you
click on this button you can change the currency
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
Roland Hughes wrote:
People have been poking at this from different angles based upon what
they want, and what they think LibreOffice is or should be. Putting
it bluntly, they are all incorrect.
At last! Thou is our real, awaited god of IT! Finally show us the Way
to the correct way we must
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 allowed
* Ken Springer (Thu, 14 Jul 2011 21:47:05 -0600)
Furthermore, you (yes: You) save a lot of time using this way of
quoting: You do not need to repeat what the person you refer to wrote,
in order to show the context. You just place your comment after the
text you wish to comment upon, and
Stephan - looking for the currency symbol to change and display in whatever
format that current displays in.
Jiri - I'll take a look at your ideas too today and see if I can make that
work.
Thanks for everyone's input so far. Love this forum! :-)
Regards,
/g
--
View this message in context:
I have an iMac, System 10.6.8 and Libre 3.4.1
In Calc I have no problems with red negatives, two decimal places and comma
separated thousands when saved as odf
However, when saved as xls, the red negatives are all black, but the
thousand separator and the two decimals are OK.
In xml, fods,
Hi :)
That sounds like a bug to me
http://wiki.documentfoundation.org/BugReport
On Ubuntu the LibreOffice 3.3.2 has no trouble. Can you try the 3.3.3 to see
if
you have the same trouble?
http://wiki.documentfoundation.org/Installing_in_parallel
Regards from
Tom :)
Hi :)
This guide might help post a wish-list item
http://wiki.documentfoundation.org/BugReport
A normal bug-report with [wishlist] added into the subject-line can sometimes
be enough but the guide might have a more sophisticated way of doing it for
LibreOffice.
Regards from
Tom :)
WoooHoo :)
Congrats on fixing the problem. Gif is a good light-weight format that
should
work easily in MS Office too :)
Regards from
Tom :)
From: purbeckjm j...@purbeck.adsl24.co.uk
To: users@global.libreoffice.org
Sent: Fri, 15 July, 2011 17:09:36
Subject:
It strikes me that there is more than that going on here. I bet they are OLEs
-- that is how embedding is done, they just present differently in Microsoft
Office if Visio is installed (or not).
You need to see what they are in the LO document if you are saving them as ODF.
Typically, the
John B wrote:
Dear Regina
You are a cruel person;-) , I downloaded the documents from OASIS you
suggested, to find over 1,500 pages.
The first 150 pages is just the Index, (it needs an index to the Index)
You must think I am Sheldon Cooper.
Do you think you could reduce it to say 3
I don't seem to be able to display negative numbers red using a comma
thousands separator and 2 decimal places . If I go to cell formatting, I
have been able to get the negative number red with 2 decimal places, but no
separator. However as soon as I save the document (in either .ods or .xml
Tom,
Yes, it appears to be a bug in 3.4.1. I uninstalled 3.4.1, installed 3.3.3
and the display now works as expected. I will submit a bug report in the
near future. Oh, and for what it is worth, I am running Windows 7 64-bit.
Thank you.
--
View this message in context:
On 07/15/2011 02:33 PM, NoOp wrote:
On 07/15/2011 07:29 AM, Earl Melton wrote:
Hi Y'all,
Not a Master Page, but a Layout instead of the one I choose every week and
for
which, each and every time, have to manually adjust the size and placement
of
text boxes (or place holders, whatever
On 7/15/2011 2:10 PM, John B wrote:
Dear Regina
You are a cruel person;-) , I downloaded the documents from OASIS you
suggested, to find over 1,500 pages.
The first 150 pages is just the Index, (it needs an index to the
Index) You must think I am Sheldon Cooper.
Do you think you could
El Sindicato Unico de Trabajadores de Edificios de Renta y Horizontal
(SUTERH), pone a disposición de la comunidad los cursos
Operador de Procesador de Textos (OpenOffice/LibreOffice): 2 meses
Operador de Planilla de Cálculos (OpenOffice/LibreOffice): 2 meses
Ambos cuentan con título expedido
Hi :)
The guide for installing 2 versions of LO on the same machine might need a bit
of thinking about but it should work
http://wiki.documentfoundation.org/Installing_in_parallel
It is possible to buy Dvd versions to avoid having to download and they tend to
be very reasonably priced
Regards
Hi :)
I think this was spam? IM Translate gave me
The Union of Workers in Building Income and Horizontal
(SUTERH) offers community courses
Word Processor Operator (OpenOffice / LibreOffice): 2 months
Operator spreadsheet (OpenOffice / LibreOffice): 2 months
Both have certificates issued by
Hi :)
Ooop, actually it looks like really good news :)
Thanks and regards from
Tom :)
From: Tom Davies tomdavie...@yahoo.co.uk
To: users@global.libreoffice.org
Sent: Sat, 16 July, 2011 0:16:42
Subject: Re: [libreoffice-users] Cursos a muy bajo costo - Buenos
Hi :)
Lol. I don't think John was being serious! It's the kinda thing friends say
to
each other in jest. No worries. All good :)
Regards from
Tom :)
From: JOE Conner joeconner2...@gmail.com
To: users@global.libreoffice.org
Sent: Fri, 15 July, 2011
Just got an email from Drew,
In a week or so, there should be a link for the initial ISO based upon
the CMS server system of the North American Community DVD. From there
we hope to have a final version after this initial ISO is tested. But
it is good news that the initial ISO is well ahead
On 07/13/2011 03:15 PM, Sandy Miller wrote:
I have LibreOffice documents (written in 3.2/3.3) with extensive field
cross-referencing to numbers of tables, numbered paragraphs, numbered
sections and chapters, etc. Conversion to Word often messes those up
so I wanted to change them all to text.
26 matches
Mail list logo