[libreoffice-users] Re: Default Paper size
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 easier to set it once since we are looking at installing it on several machines. It would be great if I can do this in Calc and Writer. -- *Michael * Tools Optons /or preferences for Writer, I believe. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: TDF benennt die Mitglieder des Engineering Steering Committee
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 Weiterentwicklung von LibreOffice ... If you are going to cross post these to user, perhaps you might want to provide an english version? this was probably an easy mistake: instead of typing us...@de.libreoffice.org Florian just typed users@libreoffice.org. Btw, the english announcement was one day earlier - it was the message about the members of the engineering steering committee. :) Sigrid -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Test for Error Conditions in Calc
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) - [is the reference any of the following: #VALUE, #REF, #NAME or #N/A ?] ISERR(reference) - [is the reference any of the following: #VALUE, #REF or #NAME ?] All of these functions return boolean results (either TRUE, or FALSE) which you can then use in an IF() statement. Notice that ISERROR() and ISERR() only differ when it comes to #N/A. Please also note that I am not 100% sure of the definitions I gave here, this is only what I observed from use. As mentioned before, I think ISERROR() would work for your case. There are also some other IS... functions you can look at, but are not really relevant to this topic. Hope this helps. Regards Jack -- View this message in context: http://nabble.documentfoundation.org/Test-for-Error-Conditions-in-Calc-tp2982777p2984083.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Test for Error Conditions in Calc
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 Tel: +27 31 514 7300 | Direct: +27 31 514 7442 | Mobile: +27 78 274 6973 Fax: +27 31 514 7494 | Tollfree Support: 086 ADAPTIT (0861 232 7848) Do you know what happened to my tree? Save this little guy's home, go paperless. Adapt IT is a level 2 BBBEE accredited company and value adding enterprise (156%) Disclaimer -Original Message- From: Jack [mailto:szi...@gmail.com] Sent: 25 May 2011 14:27 To: users@libreoffice.org Subject: [libreoffice-users] Re: Test for Error Conditions in Calc 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) - [is the reference any of the following: #VALUE, #REF, #NAME or #N/A ?] ISERR(reference) - [is the reference any of the following: #VALUE, #REF or #NAME ?] All of these functions return boolean results (either TRUE, or FALSE) which you can then use in an IF() statement. Notice that ISERROR() and ISERR() only differ when it comes to #N/A. Please also note that I am not 100% sure of the definitions I gave here, this is only what I observed from use. As mentioned before, I think ISERROR() would work for your case. There are also some other IS... functions you can look at, but are not really relevant to this topic. Hope this helps. Regards Jack -- View this message in context: http://nabble.documentfoundation.org/Test-for-Error-Conditions-in-Calc-tp2982777p2984083.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office Extensions
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 extension with the install, so you do not have to go add them. My Ubuntu copy has PDF import listed in the Extension Manager, and I do not remember installing it. I could have, but I do not remember doing that. To be honest, I got most of my extensions from OOo, but Oracle has made a mess of the pages and it it not working half the time. So it is going to get hard to get extensions and templates from their side anymore. Here is the basic list of Extensions on the North American DVD http://libreoffice-na.us/English/extensions.html Here is the LibrePlanet.org list of extensions http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Unsubscribe[era]Re: [libreoffice-users] Re: Test for Error Conditions in Calc
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 Oliveira -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] I have a problem with the presentation on a monitor and projector
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 drew a presentation to the external display and pressing F5 when in presentation mode was coming down in Libreoffice Something similar happens to me except that I get the display on the monitor of the portail and I want to leave the external monitor or projector to be connected. thank you very much. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calculating the month number
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 guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Libre Office Extensions
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. BTW. Where are the Extensions kept? Tink. -- View this message in context: http://nabble.documentfoundation.org/Libre-Office-Extensions-tp2984057p2984497.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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 to do this? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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 May 2011 07:49 PM, 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 to do this? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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 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? Try: Try: =IF(MONTH(NOW())=5,100,0) Lorenzo. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
=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 use datevalue if it is a string. On 25 May 2011 at 20:03, Manoharan Durga wrote: Date sent:Wed, 25 May 2011 20:03:36 +0530 From:Manoharan durgadurgamanoha...@gudalur.net To:users@libreoffice.org Copies to:tanstaafltansta...@libertytrek.org Subject:Re: [libreoffice-users] Calculating the month number Send reply to:users@libreoffice.org 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 May 2011 07:49 PM, 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 to do this? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Libre Office Extensions
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 Templates, The Extension folder seems to be even more obscure. Tink. -- View this message in context: http://nabble.documentfoundation.org/Libre-Office-Extensions-tp2984057p2984619.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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. Regards from Tom :) From: Michael D. Setzer II mi...@kuentos.guam.net To: users@libreoffice.org Sent: Wed, 25 May, 2011 15:49:18 Subject: Re: [libreoffice-users] Calculating the month number =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 use datevalue if it is a string. On 25 May 2011 at 20:03, Manoharan Durga wrote: Date sent:Wed, 25 May 2011 20:03:36 +0530 From:Manoharan durgadurgamanoha...@gudalur.net To:users@libreoffice.org Copies to:tanstaafltansta...@libertytrek.org Subject:Re: [libreoffice-users] Calculating the month number Send reply to:users@libreoffice.org 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 May 2011 07:49 PM, 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 to do this? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office Extensions
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 contact the devs of your favourite Extensions then they would probably be quite keen to add them to LibreOffice's collection. I have a feeling that it's usually pretty easy for the dev's of a particular Extension to add it to LibreOffice's lists but just requires remembering (or being nudged into remembering) to do it. I doubt that it's possible to do them all from the LibreOffice's end otherwise it would probably have been done en-masse already. I think the reason for not having those extensions transferred automatically was due to licensing reasons. I think I remember, that LibO only wants to have truly open extensions. But I can be wrong. :) However i think there is already at least one that deals with importing Pdfs so a search might help. I have one called PDF Import 1.0.4 which has a big Oracle logo/icon rather than the sleek elegant LibreOffice or TDF style of logos. It opens Pdfs in Draw rather than Writer so i can't edit text with it (afaik). I can move around blocks of text, pictures and stuff and i think i can add blocks of text or pictures too. I have a funny feeling that i probably didn't need the extension at all as i seem to remember PDF import being added to the main package recently. That's the default behaviour. PDF is a format to describe a graphical layout of a document. And for graphics, Draw is the correct component. It is not meant to edit a file extensively. You can add a few lines of text in a form (I did this just last week) and it works well. If you need to change the whole text, just ask the original creator for a editable file. Sigrid -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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 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 May 2011 07:49 PM, 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 to do this? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I have a problem with the presentation on a monitor and projector
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 ppt to pps just rename the file ;) Both formats are identical except the way they open. Have you looked around in Tools - Options - Impress to see if there are good options for dual-monitors? Also what is your normal language? If you can write to this list in your normal language there might be someone here that can help even though we try to stick to English. There probably is a list for a language that is easier for you so it might be worth asking there too. Good luck and regards from Tom :) From: Yusniel E. Alfonso yespinosa1...@gmail.com To: users@libreoffice.org Sent: Wed, 25 May, 2011 15:12:49 Subject: [libreoffice-users] I have a problem with the presentation on a monitor and projector 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 drew a presentation to the external display and pressing F5 when in presentation mode was coming down in Libreoffice Something similar happens to me except that I get the display on the monitor of the portail and I want to leave the external monitor or projector to be connected. thank you very much. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office Extensions
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 you can find them but if you could contact the devs of your favourite Extensions then they would probably be quite keen to add them to LibreOffice's collection. I have a feeling that it's usually pretty easy for the dev's of a particular Extension to add it to LibreOffice's lists but just requires remembering (or being nudged into remembering) to do it. I doubt that it's possible to do them all from the LibreOffice's end otherwise it would probably have been done en-masse already. I think the reason for not having those extensions transferred automatically was due to licensing reasons. I think I remember, that LibO only wants to have truly open extensions. But I can be wrong. :) However i think there is already at least one that deals with importing Pdfs so a search might help. I have one called PDF Import 1.0.4 which has a big Oracle logo/icon rather than the sleek elegant LibreOffice or TDF style of logos. It opens Pdfs in Draw rather than Writer so i can't edit text with it (afaik). I can move around blocks of text, pictures and stuff and i think i can add blocks of text or pictures too. I have a funny feeling that i probably didn't need the extension at all as i seem to remember PDF import being added to the main package recently. That's the default behaviour. PDF is a format to describe a graphical layout of a document. And for graphics, Draw is the correct component. It is not meant to edit a file extensively. You can add a few lines of text in a form (I did this just last week) and it works well. If you need to change the whole text, just ask the original creator for a editable file. Sigrid I have not tried any real PDF editing in the past 4 to 6 months, or so. I know with Ubuntu, you can get free PDF editing packages. For Windows that may be difficult, or at least the last time I looked for one. I wish CUPS-PDF would orient their PDF output like LibreOffice does with the Export-To-PDF does. LibrO keeps the orientation of the document, but CUPS-PDF will make it Portrait orientation. That becomes hard to read for landscape documentation like pamphlets and brochures. I end up using an external PDF editor to correct that problem in non-LibreO document like prints from Firefox that need to be saved and not waste paper. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Libre Office Extensions
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 +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 you can find them but if you could contact the devs of your favourite Extensions then they would probably be quite keen to add them to LibreOffice's collection. I have a feeling that it's usually pretty easy for the dev's of a particular Extension to add it to LibreOffice's lists but just requires remembering (or being nudged into remembering) to do it. I doubt that it's possible to do them all from the LibreOffice's end otherwise it would probably have been done en-masse already. I think the reason for not having those extensions transferred automatically was due to licensing reasons. I think I remember, that LibO only wants to have truly open extensions. But I can be wrong. :) Yes, this is the problem with both the extensions and templates. Even worse, many of these extensions only carried the author's name with no email or url to track them down. Cheers Marc Hi :) Google or FaceBook can be alarmingly good at finding people, unless they have a common name such as Tom Davies, John Smith and even worse if they don't have a FaceBook account ;) I googled myself but got bored after 6 pages of people with my name. I haven't joined FaceBook as i don't need to show-off how many friends (acquaintances?) i don't/do have ;) Regards from Tom :) -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] installation observations
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 language pack before the help pack, i.e. first the install pack, second the language pack, third the help pack. Suggest this is explain in the instructions. Otherwise, an impressively quick and easy installation (onto mandriva 2010). Tried to obtain the history manager extension originally written for OO, but web site was failing so tried the LO extensions web site (libreplanet wiki). No entry at the web site. Can someone please put a copy of this extension on the LO extensions web site? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] load url bar
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: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] new to list
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 also familiarising myself with LibreOffice. I shall be mostly lurking until I've learnt a bit more about both. Regards, Flos -- Using Opera's revolutionary email client: http://www.opera.com/mail/ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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 the CURRENT date/Month... Since I want prior years sheets to continue to evaluate positive, this will work perfectly for me in this case. On 25 May 2011 at 11:21, Tanstaafl wrote: Date sent:Wed, 25 May 2011 11:21:34 -0400 From: Tanstaafl tansta...@libertytrek.org To: users@libreoffice.org Copies to:Manoharan Durga durgamanoha...@gudalur.net Subject: Re: [libreoffice-users] Calculating the month number Send reply to:users@libreoffice.org 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 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 May 2011 07:49 PM, 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 to do this? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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 cells being referenced, I'm simply evaluating the CURRENT date/Month... Since I want prior years sheets to continue to evaluate positive, this will work perfectly for me in this case. H... Now that I think about it... Do these evaluations occur in context of the *current* year? I'm guessing the answer is yes, that would be the most logical thing to do. If so, I think I will have to specify the year, otherwise, next year, what is now this years sheet will start evaluating to false, since May 2011 is NOT May 2012... Is that correct? Thanks very much for your help in getting this right... -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Compilation Error [make framework]
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 during the build - sorry ! For more help with debugging build errors, please see the section in: http://wiki.documentfoundation.org/Development internal build errors: ERROR: error 65280 occurred while making /source30/libo/framework/prj it seems that the error is inside 'framework', please re-run build inside this module to isolate the error and/or test your fix: --- --- I try to rebuild and shows the error root [ /source30/libo/framework ]# make -r CxxObject/framework/source/services/uriabbreviation.o is linked in by Library/libfwkli.so Library/libfwlli.so /source30/libo/solenv/gbuild/extensions/final_ObjectOwner.mk:43: [ WARN ] !!! [ WARN ] !!! duplicate linked objects [ WARN ] !!! /source30/libo/solenv/gbuild/LinkTarget.mk:194: *** Unable to find generated C++ file /source30/libo/solver/300/unxlngi6.pro/workdir/framework/source/services/uriabbreviation.cxx in WORKDIR.. Stop. root [ /source30/libo/framework ]# sorry my English its no very good.. Thanks for your time -- View this message in context: http://nabble.documentfoundation.org/Compilation-Error-make-framework-tp2984614p2984614.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] new to list
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. 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 also familiarising myself with LibreOffice. I shall be mostly lurking until I've learnt a bit more about both. Regards, Flos -- Using Opera's revolutionary email client: http://www.opera.com/mail/ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] RE: [libreoffice-documentation] changes for this mailing list
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 deliver mail as each individual member arranges) like flo...@libreoffice.org, all the rest of us have to learn how to send mail to mailing-list-n...@global.libreoffice.org when we have struggled already to learn how to work with list mailing-list-n...@libreoffice.org, mailing-list-name+h...@libreoffice.org, etc. And this irreversible change may or may not be disruptive in unexpected ways, but you'll do your best because it is being done by throwing a switch on the universe and Mother Nature can be petulant about such things (not to mention the opportunity it affords for Puck, Kokopelli, and Loki to have a little fun with the foolish humans). So does this mean that the archives will also change their URLs and any linking we have done to existing list posts will be broken? (I mention this as one place where the law of unintended consequences may step in. Will all of the threads be broken too?) Of course, there is already archive.libreoffice.org for those. Do they stay that way? Additional curiosities. Is there some system that has global.libreoffice.org be preferable to lists.libreoffice.org ? Or is this some limitation of how Heinlein Support is working their magic? Maybe what you really want is honorifics, so you can be flo...@founders.libreoffice.org or flo...@members.libreoffice.org and flo...@staff.libreoffice.org (you can go crazy with this, though I recommend against flo...@supremeleader.libreoffice.org ) since you're going to have to redo your stationery and business cards anyhow? Now, I do like affinity forwardings. After all, I get to be dennis.hamil...@acm.org (a forwarding) and also orc...@sourceforge.net and even orc...@google.com (set up as a forwarding too) and, once upon a time, orc...@computer.org. I may even have Facebook and Linked-in affinities, though I haven't bothered to check. I am just looking at the system-engineering aspects of this mid-course correction and how it appears to disrupt the many for the benefit of a few. Odd, that, considering what it is we are out to accomplish and promote and who we say we are? Playfully, - Dennis PS: I do happen to filter on what appears in the To of incoming mail. But it is relatively easy to change those rules since I also use a white-list spam system and the new To and perhaps from e-mail addresses will go to spam until I do something about them. -Original Message- From: Florian Effenberger [mailto:flo...@documentfoundation.org] Sent: Wednesday, May 25, 2011 01:25 To: accessibil...@libreoffice.org; des...@libreoffice.org; documentat...@libreoffice.org; l...@libreoffice.org; market...@libreoffice.org; proje...@libreoffice.org; users@libreoffice.org; webs...@libreoffice.org Subject: [libreoffice-documentation] changes for this mailing list Hello everyone, as part of our membership process, we also would like to give @libreoffice.org e-mail forwarders to our approved members. Thanks to the folks from Heinlein Support in Berlin, who offered to take care of the mail forwarding and to program a web tool to enable users to configure the forwarding! In order to be able to use two different mail servers -- one for mailing lists, and one for the mail forwarders -- we have to change the addresses of a few mailing lists. In a nutshell: All lists currently known as @libreoffice.org will in the future be known as @global.libreoffice.org [ ... ] You do *not* have to un- or resubscribe from any lists, as the list of all recipients will be automatically transferred to the new addresses. The subject prefix, like [libreoffice-website], will also stay the *same*. What *will* change is the address you have to send e-mails to, and the headers like List-Post and List-ID. So, in case you filter your e-mails based on the headers, you *do* need to act. This is most likely the case if you use a local mail client like Thunderbird. Webmail services like Google Mail usually do *not* make use of these headers. The change will be effective during the day of Thursday, June 9th I will send a follow-up e-mail when the addresses have changed. Immediately after that, assume the old addresses will stop working. I will try to set them as aliases for a few days, but I cannot guarantee it will work out. However, *no* e-mail will be lost -- in case there is no alias in place, you will receive a bounce message and can re-send the mail again. Sorry for these inconveniences, but they will help us in providing e-mail forwarders for our members. In case of questions, feel free to ask me directly, or on the website@ mailing list. Florian -- Florian Effenberger flo...@documentfoundation.org
Re: [libreoffice-users] Compilation Error [make framework]
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? Sometimes people here speak more than just English :) Good luck and regards from Tom :) From: kaneda kaneda...@gmail.com To: users@libreoffice.org Sent: Wed, 25 May, 2011 16:03:43 Subject: [libreoffice-users] Compilation Error [make framework] 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 during the build - sorry ! For more help with debugging build errors, please see the section in: http://wiki.documentfoundation.org/Development internal build errors: ERROR: error 65280 occurred while making /source30/libo/framework/prj it seems that the error is inside 'framework', please re-run build inside this module to isolate the error and/or test your fix: --- --- I try to rebuild and shows the error root [ /source30/libo/framework ]# make -r CxxObject/framework/source/services/uriabbreviation.o is linked in by Library/libfwkli.so Library/libfwlli.so /source30/libo/solenv/gbuild/extensions/final_ObjectOwner.mk:43: [ WARN ] !!! [ WARN ] !!! duplicate linked objects [ WARN ] !!! /source30/libo/solenv/gbuild/LinkTarget.mk:194: *** Unable to find generated C++ file /source30/libo/solver/300/unxlngi6.pro/workdir/framework/source/services/uriabbreviation.cxx in WORKDIR.. Stop. root [ /source30/libo/framework ]# sorry my English its no very good.. Thanks for your time -- View this message in context: http://nabble.documentfoundation.org/Compilation-Error-make-framework-tp2984614p2984614.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
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 LibreOffice worry about this? Is the validator an accurate tool? Shouldn't OASIS be providing such a tool??? -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2985444.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] RE: [libreoffice-documentation] changes for this mailing list
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 discussing this quite a lot recently too. Some things had to be set-up fast with the best foresight available at the time. Since then much has changed and grown. Hindsight is fantastic, if only we could have it much much earlier!! Any links that don't work may need a tiny bit of editing but i suspect that the 'global' bit in the middle wont appear on old threads. Part of the problem with Windows systems is that they religiously attempt to stick with legacy systems that really need to be thrown out, for example the registry. As a result they have to put a lot of work into propping up systems that are vulnerable and in constant danger of falling over. Oddly, they also help make Windows unable to run on older hardware because of the immense size of all that legacy bloat. By contrast Linux and OpenSource systems are not afraid to throw something out when it becomes a burden and as a curious result there are a lot of linux distros that run superbly fast on machines that haunt peoples attics or contribute to landfill. It's better to make this change now than wait until the community and supporting websites has doubled in size again. Also Florian is not some supreme master. He is another volunteer who has bravely accepted the job of informing people about things decided by committees that he may not even have attended personally. A thankless task at best! However, re-reading your post again i see that it is probably meant as a humorous and actually very funny gentle-dig-in-the-ribs rather than the attack i first thought it. I guess i am just a 'bit tense' right now as it's the end of a wearying but fun day at the office ;) Good luck and regards from Tom :) From: Dennis E. Hamilton dennis.hamil...@acm.org To: Florian Effenberger flo...@documentfoundation.org Cc: documentat...@libreoffice.org; accessibil...@libreoffice.org; users@libreoffice.org Sent: Wed, 25 May, 2011 18:44:46 Subject: [libreoffice-users] RE: [libreoffice-documentation] changes for this mailing list 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 deliver mail as each individual member arranges) like flo...@libreoffice.org, all the rest of us have to learn how to send mail to mailing-list-n...@global.libreoffice.org when we have struggled already to learn how to work with list mailing-list-n...@libreoffice.org, mailing-list-name+h...@libreoffice.org, etc. And this irreversible change may or may not be disruptive in unexpected ways, but you'll do your best because it is being done by throwing a switch on the universe and Mother Nature can be petulant about such things (not to mention the opportunity it affords for Puck, Kokopelli, and Loki to have a little fun with the foolish humans). So does this mean that the archives will also change their URLs and any linking we have done to existing list posts will be broken? (I mention this as one place where the law of unintended consequences may step in. Will all of the threads be broken too?) Of course, there is already archive.libreoffice.org for those. Do they stay that way? Additional curiosities. Is there some system that has global.libreoffice.org be preferable to lists.libreoffice.org ? Or is this some limitation of how Heinlein Support is working their magic? Maybe what you really want is honorifics, so you can be flo...@founders.libreoffice.org or flo...@members.libreoffice.org and flo...@staff.libreoffice.org (you can go crazy with this, though I recommend against flo...@supremeleader.libreoffice.org ) since you're going to have to redo your stationery and business cards anyhow? Now, I do like affinity forwardings. After all, I get to be dennis.hamil...@acm.org (a forwarding) and also orc...@sourceforge.net and even orc...@google.com (set up as a forwarding too) and, once upon a time, orc...@computer.org. I may even have Facebook and Linked-in affinities, though I haven't bothered to check. I am just looking at the system-engineering aspects of this mid-course correction and how it appears to disrupt the many for the benefit of a few. Odd, that, considering what it is we are out to accomplish and promote and who we say we are? Playfully, - Dennis PS: I do happen to filter on what appears in the To of incoming mail. But it is relatively easy to change those rules since I also use a white-list spam system and the new To and
Re: [libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
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 compressed formats and stuff like saving a jpg as a gif, or saving it as another jpg with even higher compression rates. MSO's odf is inherently broken apparently (as mentioned fairly often by a variety of people) so it's not really a fair contest. A broken jug in millions of pieces can take up a lot less space than a full jug but it probably can't hold water. It was a good idea to test it out tho :) Regards from Tom :) From: plino pedl...@gmail.com To: users@libreoffice.org Sent: Wed, 25 May, 2011 19:09:44 Subject: [libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2 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 LibreOffice worry about this? Is the validator an accurate tool? Shouldn't OASIS be providing such a tool??? -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2985444.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compilation Error [make framework]
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 - -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Libre Office Extensions
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 archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calculating the month number
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 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 is5, 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 the CURRENT date/Month... Since I want prior years sheets to continue to evaluate positive, this will work perfectly for me in this case. H... Now that I think about it... Do these evaluations occur in context of the *current* year? I'm guessing the answer is yes, that would be the most logical thing to do. If so, I think I will have to specify the year, otherwise, next year, what is now this years sheet will start evaluating to false, since May 2011 is NOTMay 2012... One would need to know exactly what the conditions are to meet your needs. =if(a1=date(2011,5,1),100,0) would give 10 for any date on or after 2011/05/01. =if(month(a1)=5,100,0) would give 100 for any date /05/01 thru /12/31 The year would not make any difference. On the other hand, this would take in account the year =IF(AND(MONTH(A1)=5,YEAR(A1)=YEAR(NOW())),100,0) But the problem would be that if you look at the sheet on before 2012/01/01, then date of 5/1/2011 would give true, but then it would give false on 1/1/2012? Instead of using now() in the sheet, you might want to a cell with the current year for that sheet. So, in cell G1, I placed =date(2011,1,1) =IF(AND((MONTH(A1)=5),YEAR(A1)=YEAR($G$1)),100,0) Note the $G$1 is to make the address absolute, so when you copy the formula. This way, within a sheet the function would return the value in regards to the year for that sheet instead of regards to the current year. One needs to be very clear on what one want to do? Is that correct? Thanks very much for your help in getting this right... -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] upgrade path?
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 nonsense. Let me more or less repeat myself: pls stop writing about things that you do not know pretty sure that your ideas are true. You spread a lot of ... i just stick with an older release (3.3.1 on most machines) but if i need to upgrade i tend to try to fit the downloads onto Cd or usb-stick so that i can carry it to various different machines. There is rarely any real need to upgrade. Just because it is there doesn't mean you have to use it! A useful attitude in an open source project is the opposite. Regards from Tom :) PS i just checked and my current Ubuntu is on 3.3.2 somehow, magically. Well well ... Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Libre Office Extensions
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 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 archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Variable field height in LO Base reports
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 big as it needs to be to contain the exact text. STEPS: 1. View the report. It should give you a read-only view in LibreOffice Writer. (I haven't tried this with the Calc view.) 2. Click the Edit File button (the button with the pencil symbol). 3. Do an Edit | Select All (twice to get the entire table selected). 4. Click the Optimize button (the one in the Table toolbar with the check mark). Select the Optimize Row Height case (the symbol of a row with arrows pointing up and down). 5. This procedure should take all of the cells that had the red pointer showing there is more text and expand their row vertically such that all of those cells show the full text and it is word-wrapped as appropriate. I suppose one could come up with a script/macro do this in one step. It will depend very much on your Details layout in the report design to have this work. I had a details of just two fields, one over the other (ID was one, Big Text was the other - a no-brainer demonstration). The fields are each only one line high in the form design. The idea is to expand the fields selectively as needed using the table optimizer, not the report design. - Dennis -Original Message- From: Chad Neeper [mailto:cnee...@level9networks.com] Sent: Wednesday, May 25, 2011 08:00 To: users@libreoffice.org Subject: Re: [libreoffice-users] Variable field height in LO Base reports On Tue, 2011-05-24 at 19:56 -0400, Chad Neeper wrote: I'm investigating the feasibility of using LO Base again after a My first roadblock to printing the reports I need is that I can't seem to find a way to make a memo or text field with a variable height. I have several fields that contain anywhere from a few to hundreds of characters spanning several lines. If I'm forced to create a field in the report that is big enough to display all of the largest entries, I'll be needlessly blowing through reams of paper. I'm sure there must be a way to create a variable height field which will grow to fit the data that needs to be displayed and I'm just not finding it. On 5/25/2011 1:53 AM, Dennis E. Hamilton wrote: I'm not sure how this works through the LO Base user interface, but I have some clues from the ODF 1.2 Committee Specification 01 on what to look for. The only structure I'm aware of that allows variable height (other than the text flow of a document itself) is thedraw:text-box element. You can specify a minimum height and a maximum height. There must be a set maximum if there is a minimum (there's no setting that establishes no maximum). Thedraw:text-box must be within adraw:frame in your report (which is essentially a LibreOffice Writer document embedded in the Base). Thedraw:text-box can contain a paragraph that has some content derived via atext:database-display element. The two questions I can't answer, not using Base myself, are (1) what of the above is supported in the LibreOffice Base implementation and (2) if it is supported, what are the UI ceremonies to exploit the provisions in the design of a report presentation. I see Object Resizing as a formatting option in the Oracle Report Builder, but I have not found something for which those provisions are not greyed out. I've been Googling pretty extensively and as best I can determine, it looks like this feature has been documented and requested, but has not yet been implemented in Oracle Report Builder. http://openoffice.org/bugzilla/show_bug.cgi?id=77605 http://osdir.com/ml/openoffice.dba.user/2007-11/msg00055.html http://www.oooforum.org/forum/viewtopic.phtml?t=93373 It also looks like, while S/ORB has improved considerably, it's still not quite robust enough for what I need. *sigh* So close! Maybe I'll check back in a couple of major revs! Thanks, all. __ *Chad Neeper* Senior Systems Engineer *Level 9 Networks* 740-548-8070 (voice) 866-214-6607 (fax) /Full LAN/WAN consulting services -- Specialized in libraries and schools/ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Writer - envelope printing format problem
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 (Personal) Envelope printed the Sender and | Addressee about 1 to the right of where they should be (opposite Mike's | of being too far to the left. So I opened the Envelope Style and found | that it was set to C6/5 Envelope. I changed it to #6 3/4 (Personal) | Envelope and adjusted the margins to 0.25 (Left, Right, Top, Bottom). I | then 'Insert|Envelope|' and set that to #6 3/4 (Personal) Envelope | printed. The page now prints in the correct positions. | = That did not work. The printing was still too far to the left and off the left edge of the envelope. Ah well... thanks for giving it a try. I guess the next step would be to file a bug report. Open reports that I found: https://bugs.freedesktop.org/buglist.cgi?query_format=specificorder=relevance+descbug_status=__open__product=LibreOfficecontent=envelope Have a look through those to see if one fits; some seem related, but not exact, so it might be good to file one directly. To file a bug report (or add to one) see: http://wiki.documentfoundation.org/BugReport -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
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 smallest (and in addition, valid!) My only concern here is that TDF makes sure that the ODF files created with LibreOffice are valid. It doesn't make sense otherwise. And since Oracle seems to be dropping the ball on OpenOffice it would make sense to have a validation tool on the TDF or LibreOffice site (I wouldn't wait for OASIS...) MSO's odf is inherently broken apparently (as mentioned fairly often by a variety of people) so it's not really a fair contest. A broken jug in millions of pieces can take up a lot less space than a full jug but it probably can't hold water. TBH I'm glad that MS Office 2007/2010 even has ODF support. Of course they aren't going to make it that good... After all it is in their best interest that you use their proprietary file formats :) Cheers! -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2986245.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] upgrade path?
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 if you have a need for the very highest quality version, it can make sense to defer a move until the first or perhaps second minor point release. Synchronizing our time based release schedule with the wider Free Software ecosystem also has huge advantages, by getting our new features, out to users as quickly as possible - with a minimum of distribution cycle lag. In consequence, we will aim at six monthly releases, and over time nudge them to align well with the March / September norms. Note the bit where it says it can make sense to defer a move and the bit where it says about moving to a 6monthly release cycle? LibreOffice is not so flaky that it fails to work after a couple of months and 'must' be upgraded. It keeps working. Please, you do a lot of good work for TDF and there is no need to spoil that with personal attacks in public, spamming the list (ironically). People run different systems in different ways for different reasons. OpenSource is about giving people freedom OF choice. Regards from Tom :) From: Cor Nouws oo...@nouenoff.nl To: users@libreoffice.org Sent: Wed, 25 May, 2011 20:14:43 Subject: Re: [libreoffice-users] upgrade path? 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 nonsense. Let me more or less repeat myself: pls stop writing about things that you do not know pretty sure that your ideas are true. You spread a lot of ... i just stick with an older release (3.3.1 on most machines) but if i need to upgrade i tend to try to fit the downloads onto Cd or usb-stick so that i can carry it to various different machines. There is rarely any real need to upgrade. Just because it is there doesn't mean you have to use it! A useful attitude in an open source project is the opposite. Regards from Tom :) PS i just checked and my current Ubuntu is on 3.3.2 somehow, magically. Well well ... Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] upgrade path?
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 public, spamming the list (ironically). Thanks. Fair enough, my critics on you in this case was too bold. But be fair too, and evaluate your own posts pls. And also, since up until now you do not seem to take into consideration too much what others write, I doubt that I won't be triggered in the future to 'spam'( :-) ) this list again. Regards, Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
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 Office 2003 on a virtual machine, so I wouldn't be able to test with anything later in that department. I don't mind doing a comparison if you post a link to the PPS file. But this only has any usefulness if LO developers consider that optimizing the ODF files is an interesting task. Otherwise it's an academical waste of time ;) -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2986509.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
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 somewhere and send me the link :) But email is fine. I'm a Windows user so I hope it will be considerably easier to handle the pps ;) Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2986763.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
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 OOo with gstreamer. I meant upload it somewhere and send me the link :) But email is fine. I'm a Windows user so I hope it will be considerably easier to handle the pps ;) Cheers, Pedro I'd rather not put it up on a link so sending to you directly. That said, it plays just fine in Powerpoint so no issues there at all. What I meant by getting it to play in OOo w/gstreamer is that I had to sync the extracted wav to OOo (and LO as I've also converted to that as well). OOo/LO doesn't embed the wav file, so you need to have an external wav file then spend time sync'ing the slide captions transitions to the wav as each slide progresses... a real PITA. You need to do the same on Windows, the only difference is that linux uses gstreamer (what a god send compared to the Sun solution) and Win uses mediaplayer or such. You can take the pps then extract to view the jpg's in the presentation per the instructions from the original post. Were LO to use the original jpg files from the pps (or convert them to png's properly) I suspect that the .odt would be close to the original pps. G. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] new to list
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 LibreOffice. For me, I am one of the key people for the North American Community DVD Project. http://libreoffice-na.us/ We have created a DVD distribution that has been developed for the needs of the North American community. There are projects dealing with South American and European communities. Ours currently deals with English, but we are slowly working on Spanish and French versions. The key part of these LibreOffice projects are the extras beyond the install files. We have documentation, extensions, templates, localized language dictionaries, artwork, and even other software packages that may be of use to our user base. Other projects do things that would be useful to their user base. So, here is the first place to find help for features of LibreOffice. Next, look into the WIKI pages to find the other places where you can find LibreOffice related items. http://wiki.documentfoundation.org/ is a good place to start. Then look for any regional group of people that are a part of the LibreOffice community. If you live in the UK or Europe [English folk dancing reference], you should find some people or group not too far away from your region. If you live in Canada or the USA, you will find people there as well that might have some common interests that could help with your individual LibreOffice usage. We are a growing group of people who want to help. We are going to try our best to help anyone who asks. Tim L. Elmira, New York, USA, World. 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. 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 also familiarising myself with LibreOffice. I shall be mostly lurking until I've learnt a bit more about both. Regards, Flos -- Using Opera's revolutionary email client: http://www.opera.com/mail/ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Libre Office Extensions
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 should then get the Extension Manager to open up and install them properly. I did not know LO was at 3.4.5, since 3.4 is in its RC2 stage and should not have gone that high yet. -- View this message in context: http://nabble.documentfoundation.org/Libre-Office-Extensions-tp2984057p2985643.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: upgrade path?
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 Ubuntu releases: quote Synchronizing our time based release schedule with the wider Free Software ecosystem also has huge advantages, by getting our new features, out to users as quickly as possible - with a minimum of distribution cycle lag. In consequence, we will aim at six monthly releases, and over time nudge them to align well with the March / September norms. /quote Seems to indicate that LO are bending over to Ubuntu/possibly other distro release schedules. Let's see... Ubuntu releases are April (hence the LO March time) and October (hence the LO September time)... This was quite apparent with the LO 3.3.2 release in sync with Ubuntu Natty 11.04 with considerable breakage/bugs still in LO 3.3. Please tell me that I'm wrong. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: upgrade path?
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 http://dev-builds.libreoffice.org/pre-releases/ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: upgrade path?
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 approximately 6-7 releases a year. ... No. It means the final releases are (I suspect) in sync with Ubuntu releases: quote Synchronizing our time based release schedule with the wider Free Software ecosystem also has huge advantages, by getting our new features, out to users as quickly as possible - with a minimum of distribution cycle lag. In consequence, we will aim at six monthly releases, and over time nudge them to align well with the March / September norms. /quote Seems to indicate that LO are bending over to Ubuntu/possibly other distro release schedules. Let's see... Ubuntu releases are April (hence the LO March time) and October (hence the LO September time)... This was quite apparent with the LO 3.3.2 release in sync with Ubuntu Natty 11.04 with considerable breakage/bugs still in LO 3.3. Please tell me that I'm wrong. well 3.4 is scheduled to be out around June 1st. We are on RC2 right now. ... That is my opinion - what is yours? My opinion is that you missed my point(s) entirely. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: upgrade path?
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 Pre-Releases page of the website. Where can I get RC2? --Jean http://dev-builds.libreoffice.org/pre-releases/ Thanks! Looks very new, so I expect it will be on the main site before too long. -Jean -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted