[libreoffice-users] Re: Default Paper size

2011-05-25 Thread Twayne
In news:4dda8c3e.9070...@southamericamission.org, SAMAIR Peru - Michael Mahon samair.pe.m...@southamericamission.org typed: Our office uses A4 paper as our default paper in all applications. How can I set the default paper size. I have a work around in a template, but it would be a lot

Re: [libreoffice-users] Re: TDF benennt die Mitglieder des Engineering Steering Committee

2011-05-25 Thread Sigrid Carrera
Hi, On Tue, 24 May 2011 09:12:51 -0700 NoOp gl...@sbcglobal.net wrote: On 05/24/2011 04:19 AM, Florian Effenberger cross posted: Die Document Foundation benennt die Mitglieder des Engineering Steering Committee Die Gruppe koordiniert die Entwicklung und definiert die technische

[libreoffice-users] Re: Test for Error Conditions in Calc

2011-05-25 Thread Jack
Ron Adams wrote: How do I leverage IF to replace error conditions, making them instead display constant string values? For instance, how would I replace #N/A, #NAME and #VALUE with “None”? Some functions you can look into: ISNA(reference) - [is the reference #N/A ?] ISERROR(reference) -

RE: [libreoffice-users] Re: Test for Error Conditions in Calc

2011-05-25 Thread Daniel Carr
Please unsubscribe me from receiving these emails. I no longer wish to receive them! Thanks Daniel Carr | Application Developer Adapt IT Solutions Physical Address: 5 Rydall Vale Crescent, La Lucia Ridge, Durban, South Africa Postal Address: PO Box 5207, Rydall Vale Park, 4019, South Africa

Re: [libreoffice-users] Libre Office Extensions

2011-05-25 Thread webmaster for Kracked Press Productions
On 05/25/2011 08:17 AM, Tinkerer wrote: Many of the Extensions no longer appear to be available. PDF Import being the first one tried. Is there a reason? Tink If I remember right, some extensions are part of the package itself. One of the videos I have talked about bundling the most common

Unsubscribe[era]Re: [libreoffice-users] Re: Test for Error Conditions in Calc

2011-05-25 Thread lcoluiggi
Hi, Em 25-05-2011 09:29, Daniel Carr escreveu: Please unsubscribe me from receiving these emails. I no longer wish to receive them! You can do this yourself: Unsubscribe instructions: Send blank e-mail to users+unsubscr...@libreoffice.org Answer the confirmation message. Thats it!! Luiz

[libreoffice-users] I have a problem with the presentation on a monitor and projector

2011-05-25 Thread Yusniel E. Alfonso
I am a ubuntu user, please excuse my English is not very good. Do not know if it's a bug or maybe a setting that I do and I did not. It turns out I use my laptop and other LCD monitor when I open an Impress presentation and I want to put it in presentation mode, because as usual to OpenOffice, I

[libreoffice-users] Calculating the month number

2011-05-25 Thread Tanstaafl
Hi all, I'm trying to do a simple calculation: If the current month is May 2011 or later, 1,000,000, otherwise, 0 I tried: =IF(MONTH(5),100,0) Which obviously doesn't work... Is there an easy way to do this? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting

[libreoffice-users] Re: Libre Office Extensions

2011-05-25 Thread Tinkerer
I have a Mac 10.6.7 and LO 3.4 Build 5. Apparently PDF Import is not included. My understanding is the list in Extension Manager is only a list with links to the Extension or the Download. My list includes about 20 languages and the local Help for Extension Manager will not load, so I am stuck.

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Tanstaafl
Sorry, this is obviously in CALC... On 2011-05-25 10:19 AM, Tanstaafl wrote: Hi all, I'm trying to do a simple calculation: If the current month is May 2011 or later, 1,000,000, otherwise, 0 I tried: =IF(MONTH(5),100,0) Which obviously doesn't work... Is there an easy way

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Manoharan Durga
It is just =IF(MONTH(cellreference)5,100,0) replace cellreference with the cell address where May 2011 is stored. If you want the formula to automatically evaluate it based on today's date, then you can make it like below : =IF(MONTH(TODAY())5,100,0) Hope this helps On Wednesday 25

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Lorenzo Sutton
Hi Tanstaafl, Original Message Subject: Re: [libreoffice-users] Calculating the month number From: Tanstaafl tansta...@libertytrek.org To: users@libreoffice.org Date: 25/05/11 16:20 Sorry, this is obviously in CALC... [...] I'm trying to do a simple calculation: If the

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Michael D. Setzer II
=IF(NOW()=DATE(2011,5,1),100,0) If the comparison is with the May 2011, instead of just being later than May. Since it is now past May 1, 2011, the same could be done in reference to a cell with a date value. So, instead of now(), it could be a reference to a cell with a date in it, or

[libreoffice-users] Re: Libre Office Extensions

2011-05-25 Thread Tinkerer
Sorry. The PDF Importer is part of the package. If you look at the file types you can Open, you will see that PDF's are included and it works. I now need to find Convert Text to Numbers and the Grammar Checker though I am not sure of their names. There is a very obscure place for filing

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Tom Davies
Hi :) A instead of the 2nd = seems to work. eg =IF(NOW()DATE(2011,5,1),100,0) Although you might need to change the 2011,5,1 to 2011,5,0 otherwise the 1st of the month might not be included. Perhaps =IF(NOW()=DATE(2011,5,1),100,0) would be better as it is greater than or equal to.

Re: [libreoffice-users] Libre Office Extensions

2011-05-25 Thread Sigrid Carrera
Hi Tom, all, On Wed, 25 May 2011 15:56:47 +0100 (BST) Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I think a lot of the Extension's devs haven't yet made them available for LibreOffice. Apparently most/many/some of the OpenOffice ones work if you can find them but if you could

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Tanstaafl
Duh! I was trying to type the formula manually and forgot the cell reference... Thanks for the gentle use of the cluestick... :) On 2011-05-25 10:33 AM, Manoharan Durga wrote: It is just =IF(MONTH(cellreference)5,100,0) replace cellreference with the cell address where May 2011 is

Re: [libreoffice-users] I have a problem with the presentation on a monitor and projector

2011-05-25 Thread Tom Davies
Hi :) Does your presentation file have .pps or .ppsx both of which should automatically play the presentation instead of opening it ready for editing. If it is saved as a ppt, pptx or odp then it should open in design view instead of opening as a slide-show/presentation-mode. To change from

Re: [libreoffice-users] Libre Office Extensions

2011-05-25 Thread webmaster for Kracked Press Productions
On 05/25/2011 11:18 AM, Sigrid Carrera wrote: Hi Tom, all, On Wed, 25 May 2011 15:56:47 +0100 (BST) Tom Daviestomdavie...@yahoo.co.uk wrote: Hi :) I think a lot of the Extension's devs haven't yet made them available for LibreOffice. Apparently most/many/some of the OpenOffice ones work if

Re: [libreoffice-users] Re: Libre Office Extensions

2011-05-25 Thread Tom Davies
From: Marc Paré m...@marcpare.com To: users@libreoffice.org Sent: Wed, 25 May, 2011 16:44:02 Subject: [libreoffice-users] Re: Libre Office Extensions Hi Sigrid et al Le 2011-05-25 11:18, Sigrid Carrera a écrit : Hi Tom, all, On Wed, 25 May 2011 15:56:47

[libreoffice-users] installation observations

2011-05-25 Thread e-letter
Readers, Observations/comments after installation of LO 332. Navigation to the installation directories: urpmi *.rpm A requested package cannot be installed: libobasis3.3-en-GB-help-3.3.2-202.i586 (due to unsatisfied libobasis3.3-en-GB) Discovered that the correct procedure is to install the

[libreoffice-users] load url bar

2011-05-25 Thread e-letter
Readers, Is there a way to configure LO such that the 'load url bar' is visible in all components.? It is tiring and annoying to do this manually for writer, calc, draw etc. after every upgrade, since this disappeared from the default view (perhaps after SO 52?) -- Unsubscribe instructions:

[libreoffice-users] new to list

2011-05-25 Thread Phil Headford
Hello, I'm new to the list. My name is Phil Headford, but most people call me Flos. I'm a retired designer of satellites, and a fiddle player for English folk dancing. I'm hoping to use Scribus to produce The Old Swan Band Tunebook, and the Shropshire area folk magazine, Shreds and Patches. I'm

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Tanstaafl
On 2011-05-25 11:37 AM, Michael D. Setzer II wrote: Note that if you use the month( ) then it would be any date in which the month is 5, so 6/1 thru 12/31 of any year. Are the cells refereced entered as dates (numeric) or as strings? There are no cells being referenced, I'm simply evaluating

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Tanstaafl
On 2011-05-25 12:34 PM, Tanstaafl wrote: On 2011-05-25 11:37 AM, Michael D. Setzer II wrote: Note that if you use the month( ) then it would be any date in which the month is 5, so 6/1 thru 12/31 of any year. Are the cells refereced entered as dates (numeric) or as strings? There are no

[libreoffice-users] Compilation Error [make framework]

2011-05-25 Thread kaneda
i had a problem when try to compile libreoffice on my system, and i had all libraries but something its wrong. I think a file (uriabbreviation.cxx) is missing this is the error message --- Oh dear - something failed

Re: [libreoffice-users] new to list

2011-05-25 Thread James Wilde
Welcome to the list, Flos. Here you'll find all the help you'll need to use LibreOffice. The help is all provided by volunteers, users like yourself. //James On May 25, 2011, at 18:25 , Phil Headford wrote: Hello, I'm new to the list. My name is Phil Headford, but most people call me Flos.

[libreoffice-users] RE: [libreoffice-documentation] changes for this mailing list

2011-05-25 Thread Dennis E. Hamilton
I don't expect this will change, but I find the reasoning that appears to be behind it rather interesting. So, let me see if I understand this. So that you and other TDF Members can now have libreoffice.org e-mail addresses (which will be forwarded to whatever actual e-mail services hold and

Re: [libreoffice-users] Compilation Error [make framework]

2011-05-25 Thread Tom Davies
Hi :) Which Operating System are you using; a Bsd distro, Ubuntu, another Linux distro, Mac or Windows? Also what is your normal (human) language? I would guess you are using a Bsd, perhaps FreeBSD? Your English seems fine but it might be easier for someone to help in your own language?

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

2011-05-25 Thread plino
The simple explanation is that the MSO file is missing many ODF features ;) Interestingly both your files fail the ODF validation on this site http://tools.odftoolkit.org/odfvalidator/ Does it make any sense that only when I create an identical file under OOo 3.4 Beta the file is valid? Should

Re: [libreoffice-users] RE: [libreoffice-documentation] changes for this mailing list

2011-05-25 Thread Tom Davies
Hi :) This has been discussed 'ad nauseum' on the website list and probably other places although i think it was some time ago and 'shelved' as being too low-priority at the time. I haven't checked in with the website list for many months but i would hazard a guess that they have been

Re: [libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

2011-05-25 Thread Tom Davies
Hi :) I generally find that the original format of files like this is the smallest. If you re-write the document from scratch using exactly the same formatting in both then i would guess that LibreOffice generates the best and possibly smallest .odt. There are obvious exceptions such as

Re: [libreoffice-users] Compilation Error [make framework]

2011-05-25 Thread Cor Nouws
Hi, kaneda wrote (25-05-11 17:03) i had a problem when try to compile libreoffice on my system, ... The better place for your question is this list: libreoff...@lists.freedesktop.org Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation -

[libreoffice-users] Re: Libre Office Extensions

2011-05-25 Thread Tinkerer
Many thanks for the links. I have downloaded them, but where on my Mac, Snow Leopard, do I put them so that LO 3.4.5 will find them? Tink. -- View this message in context: http://nabble.documentfoundation.org/Libre-Office-Extensions-tp2984057p2985643.html Sent from the Users mailing list

Re: [libreoffice-users] Calculating the month number

2011-05-25 Thread Michael D. Setzer II
On 25 May 2011 at 12:40, Tanstaafl wrote: Date sent:Wed, 25 May 2011 12:40:24 -0400 From:tanstaafltansta...@libertytrek.org To:users@libreoffice.org Subject:Re: [libreoffice-users] Calculating the month number Send reply to:users@libreoffice.org On 2011-05-25 12:34 PM, Tanstaafl wrote: On

Re: [libreoffice-users] upgrade path?

2011-05-25 Thread Cor Nouws
Tom Davies wrote (25-05-11 19:04) I heard/saw somewhere that although there is currently a rapid and frequent (ie very aggressive) release cycle at the moment that there is an intention to slow down to 6monthly releases at some point within the next year or so. Personally This is completely

Re: [libreoffice-users] Re: Libre Office Extensions

2011-05-25 Thread Steve Edmonds
Hi. I down loaded them into a folder I labelled DownloadsInstallLO (only for future reference). Then in LO got to menu ToolsExtension Manager..., select Add and navigate to the folder with the extension and select the extension to add. steve On 26/05/11 7:04 AM, Tinkerer wrote: Many thanks

RE: [libreoffice-users] Variable field height in LO Base reports

2011-05-25 Thread Dennis E. Hamilton
I found a way to do this manually. It works the easiest when your details fields are stacked vertically, with maybe legends on the left, since these will each become a table row in the final report. I assume you want fields to wordwrap exactly enough so that their content cell is only as

[libreoffice-users] Re: Writer - envelope printing format problem

2011-05-25 Thread NoOp
On 05/25/2011 11:14 AM, Mike. wrote: On 5/23/2011 at 8:36 PM NoOp wrote: ... |Can you try modifying the Envelope style as I mentioned in my other |post? If that works, then we might have something that we can take to |the bug reports. This is from my other post: | | OK. I found that #6 3/4

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

2011-05-25 Thread plino
Hi Tom ;) If you re-write the document from scratch using exactly the same formatting in both then i would guess that LibreOffice generates the best and possibly smallest .odt. I did. It is not :) Since the MS ODF is so incomplete it manages to be the smallest. And the OOo file is the second

Re: [libreoffice-users] upgrade path?

2011-05-25 Thread Tom Davies
Lol. I'm not exactly sure how your post helps the original question. My complete nonsense is from the TDF wiki. http://wiki.documentfoundation.org/ReleasePlan ... we will necessarily release earlier, and then rapidly, incrementally bug fix releases based on the previous stable version. Thus

Re: [libreoffice-users] upgrade path?

2011-05-25 Thread Cor Nouws
Tom Davies wrote (25-05-11 23:53) Lol. Lol too http://wiki.documentfoundation.org/ReleasePlan Release cycle of 6 months, does mean in our case approximately 6-7 releases a year. Please, you do a lot of good work for TDF and there is no need to spoil that with personal attacks in

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

2011-05-25 Thread plino
But, it is clear that OOo/LO could use some 'fine tuning' in the file size/image compression/conversion area - at least with respect to Impress. If I get time if it is interest to anyone I can just build a 1 slide Impress presentation using the extracted .ppt jpg compare. I've only MS

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

2011-05-25 Thread plino
Hi Gary I don't have a link for it - M. Henri Day sent it to me directly. But I'll be happy to email it to you if you'd like. Note: I had to do considerable timing adjustments to get it to sync with the external .wav file in order to get it to work in OOo with gstreamer. I meant upload it

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

2011-05-25 Thread NoOp
On 05/25/2011 04:32 PM, plino wrote: Hi Gary I don't have a link for it - M. Henri Day sent it to me directly. But I'll be happy to email it to you if you'd like. Note: I had to do considerable timing adjustments to get it to sync with the external .wav file in order to get it to work in

Re: [libreoffice-users] new to list

2011-05-25 Thread webmaster for Kracked Press Productions
On 05/25/2011 01:20 PM, James Wilde wrote: Welcome to the list, Flos. Here you'll find all the help you'll need to use LibreOffice. The help is all provided by volunteers, users like yourself. //James You might want to look into some other resources that are being created as projects for

Re: [libreoffice-users] Re: Libre Office Extensions

2011-05-25 Thread webmaster for Kracked Press Productions
On 05/25/2011 03:04 PM, Tinkerer wrote: Many thanks for the links. I have downloaded them, but where on my Mac, Snow Leopard, do I put them so that LO 3.4.5 will find them? Tink. For Windows and Ubuntu, I double click on them, since the .oxt file uses LibreOffice's as their application. You

[libreoffice-users] Re: upgrade path?

2011-05-25 Thread NoOp
On 05/25/2011 03:21 PM, Cor Nouws wrote: Tom Davies wrote (25-05-11 23:53) Lol. Lol too http://wiki.documentfoundation.org/ReleasePlan Release cycle of 6 months, does mean in our case approximately 6-7 releases a year. ... No. It means the final releases are (I suspect) in sync with

Re: [libreoffice-users] Re: upgrade path?

2011-05-25 Thread Matthew Young
On 05/25/2011 08:24 PM, Jean Hollis Weber wrote: On Wed, 2011-05-25 at 21:15 -0400, webmaster for Kracked Press Productions wrote: well 3.4 is scheduled to be out around June 1st. We are on RC2 right now. I see only RC1 on the Pre-Releases page of the website. Where can I get RC2? --Jean

[libreoffice-users] Re: upgrade path?

2011-05-25 Thread NoOp
On 05/25/2011 06:15 PM, webmaster for Kracked Press Productions wrote: On 05/25/2011 08:30 PM, NoOp wrote: On 05/25/2011 03:21 PM, Cor Nouws wrote: Tom Davies wrote (25-05-11 23:53) Lol. Lol too http://wiki.documentfoundation.org/ReleasePlan Release cycle of 6 months, does mean in our case

Re: [libreoffice-users] Re: upgrade path?

2011-05-25 Thread Jean Hollis Weber
On Wed, 2011-05-25 at 20:48 -0500, Matthew Young wrote: On 05/25/2011 08:24 PM, Jean Hollis Weber wrote: On Wed, 2011-05-25 at 21:15 -0400, webmaster for Kracked Press Productions wrote: well 3.4 is scheduled to be out around June 1st. We are on RC2 right now. I see only RC1 on the