[users] Re: Thank you very much!
Dear Jeff: I also have used Oo for presentations during the 4 years I was in Toastmasters. At that time I was using it on an XT platform. Since the purchase of Sun by Oracle, I have gone to LibreOffice, but much is the same. I also use LibO on Fedora 16, and with double screens on my laptop, I use the external screen for the audience (or it could equally be a projector) and the Laotop screen for the speaker's screen. When I use my presenter, both screens change in synchronism. On the speaker's screen there are 3 parts: 1) is a small image of the image on the audience screen, so I can see where that is at without the need to turn my back to the audience. 2) is a similar image, but of the next screen to come up. 3) is a larger window with the annotatons (AKA teleprompter). This is a real help if the content of the speech/presentation is complex. Also it can speed getting back on track if you have an unexpected audience distraction. One more thing I have seen a great and too often neglected need for: Wherever in a speech or presentation, the content is dependent on the audience grasping the interrelations between a complex (often circumstantial) arrangement of interacting concepts, especially if those concepts are abstract ones, I have developped a strategy based on Draw. I call this organnigrammes. Organnigrammes is simply the French word for flowcharts. I used the French word in English to infer a distinction between traditional flowcharts and what I have done. First, I downloaded a simple screen of traditional flowchart symbols from the web. I then vectorised them and thence made variations of my vectorisations to represent added Graphic vocabulary to the project. More recently, I had to add symbols for the Boolean algebra concepts, AND, OR, NOT. For this, being an electronic technician, I vectorised they symbols used for AND and OR gates, added the little circle when a negation or inversion was needed, added text labels inside, and there it was. I also had created symbols to indicate reiterative loops and a few more. Aside from technical presentations, I see this as being a practical way to efficiently document and communicate personality sketches between managers, HR people and psychologists. (Note the ethical considerations are independent of the tools, as only humans can make such moral judgements, thus abrogating any such complaints that could be made against the tools rather than the user's use of them.) Since I save all the vectorised pieces in all the Draw work I do, they add ongoing to my working library. I also have a lot of tricks I use to do the tasks that a true CAD app would do better, and Draw does not do directly. Note that scale is a setting of Draw, not the .ODG file, so it may be expedient to have an extra page at the end for scraps and annotations of such items as scale and grid settings used for each file. To me the biggest caveat is that Draw has a math accuracy limit of only about 3 decimal places, rather than, say 12 for a true CAD app. Therefore in some cases I have to use a callout to show exact dims. This may help some out there who do presentations. On 3/15/2012 00:31, Jeffrey Deutsch wrote: Hello, Some time back, I posted asking for advice with OpenOffice.org's Impress. I just wanted to thank all of you for your help - my presentation was a huge success! Keep up the good work! Jeff Deutsch Speaker Life Coach A SPLINT - ASPies LInking with NTs http://www.asplint.com Your mood can affect how you read this e-mail. Please read it with a smile. (http://tonecheck.com) -- Best Regards, Bruce Martin -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Windows 8
On 3/14/2012 9:22 PM, Bruce Martin wrote: Dear Kay: Thanks for your reply. I will have to search AOO on my available Linux repositories to see what they come up with. to me, the main reason so many went from Oo th LibO is because when Oracle bought out sun, people were afraid that Oo would (figuratively) become less open. I tend to feel that a main open source app of this importance should be a true .ORG with no possibility of being used as a front (i.e. repeated enticement) to get people to go for paid products. Ads on the side of the web page just enough to pay for the site, is one thing, but I think more than that, many people are silently fearful of too much commercial aggressiveness, direct or indirect. Actually my background is more industrial electronics and heavy industry than true IT. Now retired, I tend to make some gadgets myself from scratch, or near scratch, especially if, by doing so I can have added benefits from them in terms of: -durability -interchangeability -home shop repairability -other features not available on the market, especially if I think those features are ones that the market may be reluctant to make available, possibly because they would be market busters and jeopardise the sales of existing products. I have been doing this for decades, and some of these items have been in service for as much as 40 years. I also make some of my own tools. Out of the box? Yes! Best Regards, all Bruce M. On 3/14/2012 18:58, Kay Schenk wrote: On Wed, Mar 14, 2012 at 1:03 PM, Bruce Martin brucemarti...@gmail.com mailto:brucemarti...@gmail.com wrote: ¡Hola! Luiz y todos: This is interesting because the last comments I had bumped into in regards to win 8 were much more negative. We will see how it goes. At present, I am using a combination of XP and Fedora (32 and 64 bit). LibO comes by default with Fedora 32 or 64 bit, Version 15 and up. There is a whole new system every 6 months. Best Regards, Bruce M. Bruce and other Linux users -- You can, of course, install AOO on your own... Developer builds are available now and Apache OpenOffice would love to hear from you. See Testing Developer Installation Sets on the Source page... http://incubator.apache.org/openofficeorg/source.html On 3/14/2012 10:11, Luis E Vásquez r wrote: Medellín, marzo 14 de 2012 Hello, friends I've been testing intensively the latest versions of Libre Office 3.5. X and the version of Apache developers, known as AOO 3.4. both in Windows environment 8 (previous version user) and the results obtained with both products have been fairly regular,stable and also very good level of performance (Libo 3.5 Rc2 bit slow). In general the result has been satisfactory. I will keepin the operation ofboth tests andI will tell later. Best Regards,Cordialmente, Luis E. Vásquez R. OpenOffice.org/Libre Office Volunteer Support Este mensaje se ha enviado desde Medellín, Colombia /*13 Años usando exitosamente OpenOffice.org/Libre Office libre, seguro y abierto*/ To all: I have attended a class on the present version of Windows 8 and I'm not impressed with it at all, no more than I was with Vista which I didn't buy either! I think Microsoft has made a big mistake, because Windows 8, at least as it now stands, restricts your computer, which has to be updated anyway with touch screen capability, to only that OS. You cannot dual boot, for instance, and if you have legacy programs you can't use them. At least, as of now, anyway.:-) -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Thank you very much!
Oh, great! Is good to know that our list could help you. Regards and Good luck! Sylvia El 15/03/12 01:31, Jeffrey Deutsch escribi: Hello, Some time back, I posted asking for advice with OpenOffice.org's Impress. I just wanted to thank all of you for your help - my presentation was a huge success! Keep up the good work! Jeff Deutsch Speaker Life Coach A SPLINT - ASPies LInking with NTs http://www.asplint.com Your mood can affect how you read this e-mail. Please read it with a smile. (http://tonecheck.com)
[users] Re: Windows 8
¡Hola! Luiz y todos: This is interesting because the last comments I had bumped into in regards to win 8 were much more negative. We will see how it goes. At present, I am using a combination of XP and Fedora (32 and 64 bit). LibO comes by default with Fedora 32 or 64 bit, Version 15 and up. There is a whole new system every 6 months. Best Regards, Bruce M. On 3/14/2012 10:11, Luis E Vásquez r wrote: Medellín, marzo 14 de 2012 Hello, friends I've been testing intensively the latest versions of Libre Office 3.5. X and the version of Apache developers, known as AOO 3.4. both in Windows environment 8 (previous version user) and the results obtained with both products have been fairly regular,stable and also very good level of performance (Libo 3.5 Rc2 bit slow). In general the result has been satisfactory. I will keepin the operation ofboth tests andI will tell later. Best Regards,Cordialmente, Luis E. Vásquez R. OpenOffice.org/Libre Office Volunteer Support Este mensaje se ha enviado desde Medellín, Colombia /*13 Años usando exitosamente OpenOffice.org/Libre Office libre, seguro y abierto*/ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Windows 8
On Wed, Mar 14, 2012 at 1:03 PM, Bruce Martin brucemarti...@gmail.comwrote: ¡Hola! Luiz y todos: This is interesting because the last comments I had bumped into in regards to win 8 were much more negative. We will see how it goes. At present, I am using a combination of XP and Fedora (32 and 64 bit). LibO comes by default with Fedora 32 or 64 bit, Version 15 and up. There is a whole new system every 6 months. Best Regards, Bruce M. Bruce and other Linux users -- You can, of course, install AOO on your own... Developer builds are available now and Apache OpenOffice would love to hear from you. See Testing Developer Installation Sets on the Source page... http://incubator.apache.org/openofficeorg/source.html On 3/14/2012 10:11, Luis E Vásquez r wrote: Medellín, marzo 14 de 2012 Hello, friends I've been testing intensively the latest versions of Libre Office 3.5. X and the version of Apache developers, known as AOO 3.4. both in Windows environment 8 (previous version user) and the results obtained with both products have been fairly regular,stable and also very good level of performance (Libo 3.5 Rc2 bit slow). In general the result has been satisfactory. I will keep in the operation of both tests and I will tell later. Best Regards,Cordialmente, Luis E. Vásquez R. OpenOffice.org/Libre Office Volunteer Support Este mensaje se ha enviado desde Medellín, Colombia *13 Años usando exitosamente OpenOffice.org/Libre Office libre, seguro y abierto* -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Windows 8
Dear Kay: Thanks for your reply. I will have to search AOO on my available Linux repositories to see what they come up with. to me, the main reason so many went from Oo th LibO is because when Oracle bought out sun, people were afraid that Oo would (figuratively) become less open. I tend to feel that a main open source app of this importance should be a true .ORG with no possibility of being used as a front (i.e. repeated enticement) to get people to go for paid products. Ads on the side of the web page just enough to pay for the site, is one thing, but I think more than that, many people are silently fearful of too much commercial aggressiveness, direct or indirect. Actually my background is more industrial electronics and heavy industry than true IT. Now retired, I tend to make some gadgets myself from scratch, or near scratch, especially if, by doing so I can have added benefits from them in terms of: -durability -interchangeability -home shop repairability -other features not available on the market, especially if I think those features are ones that the market may be reluctant to make available, possibly because they would be market busters and jeopardise the sales of existing products. I have been doing this for decades, and some of these items have been in service for as much as 40 years. I also make some of my own tools. Out of the box? Yes! Best Regards, all Bruce M. On 3/14/2012 18:58, Kay Schenk wrote: On Wed, Mar 14, 2012 at 1:03 PM, Bruce Martin brucemarti...@gmail.com mailto:brucemarti...@gmail.com wrote: ¡Hola! Luiz y todos: This is interesting because the last comments I had bumped into in regards to win 8 were much more negative. We will see how it goes. At present, I am using a combination of XP and Fedora (32 and 64 bit). LibO comes by default with Fedora 32 or 64 bit, Version 15 and up. There is a whole new system every 6 months. Best Regards, Bruce M. Bruce and other Linux users -- You can, of course, install AOO on your own... Developer builds are available now and Apache OpenOffice would love to hear from you. See Testing Developer Installation Sets on the Source page... http://incubator.apache.org/openofficeorg/source.html On 3/14/2012 10:11, Luis E Vásquez r wrote: Medellín, marzo 14 de 2012 Hello, friends I've been testing intensively the latest versions of Libre Office 3.5. X and the version of Apache developers, known as AOO 3.4. both in Windows environment 8 (previous version user) and the results obtained with both products have been fairly regular,stable and also very good level of performance (Libo 3.5 Rc2 bit slow). In general the result has been satisfactory. I will keepin the operation ofboth tests andI will tell later. Best Regards,Cordialmente, Luis E. Vásquez R. OpenOffice.org/Libre Office Volunteer Support Este mensaje se ha enviado desde Medellín, Colombia /*13 Años usando exitosamente OpenOffice.org/Libre Office libre, seguro y abierto*/ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Information
Hello Benjamin, Everyone is free to use openoffice in any environment. You can read the license here: http://www.openoffice.org/license.html tc From: Benjamin Kovacevic benjamin.kovace...@remex.ba To: users@openoffice.org Sent: Monday, March 12, 2012 5:27:25 AM Subject: [users] Information Dear Mr./Ms., I need info rmation about licensing OpenOffice. Can we use OpenOffice in a company legaly, or we need to buy license for it. I need this info rmation fast. Thank you on understanding. ___ S poštovanjem / Best regards / Mit freundlichen Grüßen, Benjamin Kovačević, dipl. ing. info rmacionih tehnologija / Bachelor of Information Technology Manager prodaje / Sales Manager e-mail: benjamin.kovace...@remex.ba REMEX d.o.o. Prodaja filtera za sve vrste teretnih i putničkih vozila, građevinskih i rudarskih mašina i originalnih autodijelova za iste Husinskih rudara 351, 75000 Tuzla Tel: +387 (0)35 302 000 Tel/fax: +387 (0)35 302 002 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Open office quit enexpectedly
On Wed, Mar 7, 2012 at 1:21 PM, Molly Uridil muri...@spsne.org wrote: I have installed OpenOffice on my Mac and it won't allow me to open it. An error message keeps popping up that OpenOffice.org quit unexpectedly. I try to click to reopen and the error pops up again. I have reinstalled it and it still pops up with the error. How do I go about fixing this problem. Thank You Molly Uridil Sutton Public Schools muri...@spsne.org Molly-- Can you tell use what version you were trying to install? If you can provide the complete URL (location and complete name of the install file) this would help. And more about your specific Mac platform. Really, it would also be VERY helpful if you could file an issue on this through BugZilla, the bug reporting system. The link for this is: https://issues.apache.org/ooo/enter_bug.cgi You will need to register for an account first, however. Once you do this, please choose the installation category, choose the version you were trying to install (otherwise just leave the default), change the platform to Mac, then fill out the rest and submit. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: document
On 07-03-12 11:24, Ir. R. Minczeles wrote: Beste mensen, ik heb het volgende probleem. Als ik in de Windows Verkenner een OpenOffice-document open wil maken, dan krijg ik het bericht dat ik de daarvoor benodigde bevoegdheden niet heb. Ik ben toch de auteur van het document, de eigenaar en de administrator !! Dit document in OpenOffice te openen, dat geeft echter geen probleem. Ik begrijp het niet. Met dank voor Uw belangstelling, R. Minczeles, man, 80 jaar. Mr. Minczeles, Vor uw informatie: dit is een alleen Engels mail-lijst. Bovendien wordt hij binnen enkele weken opgeheven. Mijn advies is Libre Office te downloaden: www.libreof...@e.org/download/ Daarvoor bestaat ook een nederlandse mail lijst: us...@global.libreoffice.org. Het programma is een stuk beter dan de oude OpenOffice. Uit uw vraag begrijp ik dat U Windows gebruikt. Helaas ken ik dat OS onvoldoende om een zinnig antwoord te geven. Met vriendelijke groet, dr. J.L. Blom (bouwjaar 1938) -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Reg: Help
If you have Excel files that are encrypted with a password, those files cannot be opened by current OpenOffice.org releases under any conditions. If you have Excel files with protected fields or have a fully-protected (read-only) document, it is true that those Excel files are no longer protected when opened in current OpenOffice.org versions. (Some protections of Word documents are honored in some releases.) If this is of critical importance to you, please consider requesting an improvement in the issue tracking (Bugzilla) systems of the Apache OpenOffice project and/or The Document Foundation LibreOffice project, where future versions of OpenOffice-lineage software is being developed. http://www.openoffice.org/qa/issue_handling/pre_submission.html http://wiki.documentfoundation.org/BugReport - Dennis ADDITIONAL INFORMATION: DO NOT ASSUME TOO MUCH The use of a password to lock the protection of fields or make read-only documents is not a security provision in OpenOffice.org ODF Spreadsheet files (.ods) nor in Excel OOXML (.xslx) and binary (.xsl) files. It is a safeguard against accidental alteration of fields that should not change for the spreadsheet to work properly. Experts can remove, alter, and restore the protection of such fields without knowing the password. Also, the passwords used are not particularly safe from discovery. If you have protected fields of documents in Excel or in OpenOffice, please do not use those passwords for more-important purposes. -Original Message- From: Neeraj Kumar [mailto:neeraj.ku...@lavazza.co.in] Sent: Sunday, March 04, 2012 21:56 To: users@openoffice.org Cc: 'Prashant.Madollapa' Subject: [users] Reg: Help Dear Sir/Madam I am looking of your Kind guidance In terms of using the Free Open office. I have some query regarding to opening the Ms Office Password protected files into Open office. When I am opening any Password protected Ms Office Excel files into Open office then we can unprotect it with out asking Password. So in this case we loose the purpose of security. Is we had any kind of method, in which any password protected files of ms office which we are using into Open office, it should ask the password. Without password it should not allowed to editing the files. As well as after opening the file into open Office when we are using this file into Ms Office then it will become unprotected while it should ask password. I am Looking of your kind response and help as usual. Regards Neeraj Kumar -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Please note: users@openoffice.org list to be retired on March 15th
Hello, Sorry to learn this, but put me on the NEW list. Let me know... Thank you, Inquire_98 This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to which they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error, please contact the sender and delete the material from your computer. Please note that any view or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of Primes. (Primes) and/or its subsidiaries. Finally, the recipient should check this e-mail and any attachments for the presence of viruses. Primes accepts no liability for any damage caused by any virus transmitted by this e-mail. From: Rob Weir robw...@apache.org To: users@openoffice.org Sent: Thursday, March 1, 2012 5:40 AM Subject: [users] Please note: users@openoffice.org list to be retired on March 15th Please note: The time has come for this list to be retired. It will be shutdown on or soon after March 15th. All of the legacy OpenOffice.org email lists will be shutdown at that time. The good news is that we have an equivalent list for Apache OpenOffice and you are welcome to subscribe to that list. To join the new list, send an email to ooo-users-subscr...@incubator.apache.org. This should be done from the email account where you want to receive the list messages. This will generate a confirmation email which will be sent to your email address. You will need to reply to the confirmation email in order to complete your subscription to the new list. To send posts to the new list, you will mail them to the following address: ooo-us...@incubator.apache.org And if you ever want to unsubscribe to the new list, you can do so by sending an email to: ooo-users-unsubscr...@incubator.apache.org Regards, -Rob -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: JAVA runtime problem
OOo 3.2.1 can't find the latest Java on Macs. Update to OOo 3.3. There is a hack to OOo to get older versions to recognize Java but you would be better off getting u[dating to OOo 3.3. On 2012-02-29 9:30 PM David Shipley wrote: I have attempted to use the database on OpenOffice.org http://OpenOffice.org 3.2.1. I am running OS 10.6.8. Every time I try to run a portion of the database I get an error message OpenOffice.org http://OpenOffice.org requires a Java runtime environment (JRE) to perform this task. The selected JRE is defective. Please select another version of install a new JRE and select it under Tools - Options - OpenOffice.org http://OpenOffice.org - Java. I checked Java Preferences and it says the Java SE 6 is loaded but OpenOffice.org http://OpenOffice.org Java options does not list it. I have no idea where Java SE 6 is installed so I cannot Add... it. How do I get OpenOffice.org http://OpenOffice.org to recognize the installed Java? /David Shipley/ 719-646-5321 dd.ship...@comcast.net mailto:dd.ship...@comcast.net -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: compatibility with AppleWorks
On Sun, 2012-02-19 at 19:53 +1030, Morris, Ray (Health) wrote: Hi, Just downloaded OpenOffice hoping that it MAY enable me to open many AppleWorks Drawing docs on my new MacBook, so running OS-X Lion (10.7.3). Any tips would be appreciated, Sincerely, Ray Sorry, but AppleWorks is a proprietary software that AOO does not open. You will need to search for Easy Dream (recommended by MacWorld), but this costs $95. Otherwise search for appleworks graphic format (without the quotes. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: compatibility with AppleWorks
On 2012-02-19 3:23 AM Morris, Ray (Health) wrote concerning compatibility with AppleWorks: Just downloaded OpenOffice hoping that it MAY enable me to open many AppleWorks Drawing docs on my new MacBook, so running OS-X Lion (10.7.3). Any tips would be appreciated, OOo doesn't open AppleWorks Drawing docs. Search with Google for appleworks drawing replacement. EazyDraw and Intaglio both claim to open AppleWorks Drawing documents. I haven't used either. iWorks will open AppleWorks word-processing, spreadsheet, and presentation documents if you also have those type of documents. -- As a courtesy I have sent a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at users@openoffice.org - replies to my personal email address will be ignored. Since you are not subscribed to this list you may not see all the replies to your query.To subscribe send an email to users-subscr...@openoffice.org _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Problem with LIbreOffice Fields SOLVED
On Wed, Feb 15, 2012 at 2:17 PM, Dan Lewis elderdanle...@gmail.com wrote: On Tue, 2012-02-14 at 18:38 -0500, Pat Brown wrote: I'm running LibreOffice 3.4.4. In the last day when I try to put page numbers or dates or anything from Fields, into a document, instead of getting an actual number or date I get this: Date (fixed) Page numbers Time (fixed) It also shows this when I open someone else's document so it's not restricted to my own documents. Has anyone ever seen this problem before? Pat Brown This happens to the best of us every once in a while. I have done this, and I have seen posts earlier where others have done this. Try either one of these (they do the same thing): 1) View Field names. 2) Control+F9 (hold down the Control key while typing the F9 key) Thanks, that was the solution. I'm glad to hear it happens to others and I'm not alone in my dumbness. :-) Pat Brown http://pabrown.com/ A professional writer is an amateur who didn’t quit. Richard Bach -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Problem with LIbreOffice Fields
On Tue, 2012-02-14 at 18:38 -0500, Pat Brown wrote: I'm running LibreOffice 3.4.4. In the last day when I try to put page numbers or dates or anything from Fields, into a document, instead of getting an actual number or date I get this: Date (fixed) Page numbers Time (fixed) It also shows this when I open someone else's document so it's not restricted to my own documents. Has anyone ever seen this problem before? Pat Brown This happens to the best of us every once in a while. I have done this, and I have seen posts earlier where others have done this. Try either one of these (they do the same thing): 1) View Field names. 2) Control+F9 (hold down the Control key while typing the F9 key) --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Problem with LIbreOffice Fields
On 2/15/2012 11:17 AM, Dan Lewis wrote: On Tue, 2012-02-14 at 18:38 -0500, Pat Brown wrote: I'm running LibreOffice 3.4.4. In the last day when I try to put page numbers or dates or anything from Fields, into a document, instead of getting an actual number or date I get this: Date (fixed) Page numbers Time (fixed) It also shows this when I open someone else's document so it's not restricted to my own documents. Has anyone ever seen this problem before? Pat Brown This happens to the best of us every once in a while. I have done this, and I have seen posts earlier where others have done this. Try either one of these (they do the same thing): 1) View Field names. 2) Control+F9 (hold down the Control key while typing the F9 key) --Dan To all: I am confused. Is this the Open office users group for the LibreOffice users group?:-\ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Problem with LIbreOffice Fields
On Wed, 2012-02-15 at 14:06 -0800, John Boyle wrote: On 2/15/2012 11:17 AM, Dan Lewis wrote: On Tue, 2012-02-14 at 18:38 -0500, Pat Brown wrote: I'm running LibreOffice 3.4.4. In the last day when I try to put page numbers or dates or anything from Fields, into a document, instead of getting an actual number or date I get this: Date (fixed) Page numbers Time (fixed) It also shows this when I open someone else's document so it's not restricted to my own documents. Has anyone ever seen this problem before? Pat Brown This happens to the best of us every once in a while. I have done this, and I have seen posts earlier where others have done this. Try either one of these (they do the same thing): 1) View Field names. 2) Control+F9 (hold down the Control key while typing the F9 key) --Dan To all: I am confused. Is this the Open office users group for the LibreOffice users group?:-\ Perhaps, the OP is a member of both user groups; or perhaps, the OP things that OOo and LO are basically the same. Regardless, the instructions I gave apply to both. Seems like people can have the same problem regardless of which of the two office suites they are using. I remember seeing a similar request for how to do this very thing several years ago on this mailing list. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Color of Help-file
2012/2/11 Hemmo Kranenborg h.j.kranenb...@casema.nl Hello, My computer is an Apple MacBook Pro, with operating system OS X, Lion vs. 10.7.2. When I open the Help-file of OpenOffice.org it alms totally unreadable. The background color of the file is black, the text is dark green and the links are deep blue. The combination is almost unreadable. What can be the problem ? Am I doing something wrong, and/or is there a way to change these colors? Met vriendelijke groet / Best regard Hi Hemmo, The normal presentation of the Help window is the same as that of a normal document window, at least it is on my MBP with Lion, OS X 10.7.2. How does your normal page template (Writer) look, i.e. when you open a new Writer document? Maybe you can take a look at your prefs: (top left menu) LibO Preferences (Voorkeuren) LibO Appearance (Vormgeving) check the colour for Document background (Documentachtergrond), Font color (Kleur lettertype), Unvisited links (Niet-bezochte koppelingen). I suppose other users can help you along further, but this info may be useful... -- Guy using LibO 3.4.5 3.5 on a iMac Intel DualCore Lion -- please reply only to us...@global.libreoffice.org -- Dodoes can't afford to have headaches -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Page Break Lines OOCalc [SOLVED]
On 02/11/2012 11:22 PM, Anthony Chilco wrote: Hi Mark, Tools / option / calc / view. Uncheck 'Page Breaks' under 'Visual Aids'. tc *From:* Mark LaPierre marklap...@aol.com *To:* *Sent:* Saturday, February 11, 2012 10:03:32 PM *Subject:* [users] Page Break Lines OOCalc Does anyone know how to turn off the appearance of page break lines on OO Calc? When I go to View/Page Break Preview the work sheet is displayed with all the page breaks and the page numbers in phantom gray as would be expected, but when I switch back to View/Normal the page breaks are still visible. They look like I set a border around each page. Notice the vertical and horizontal line to the left and below the selected cell on the attached screen shot. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registerd Linux user No #267004 -- - To unsubscribe send email to users-unsubscr...@openoffice.org mailto:users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org mailto:sy...@openoffice.org with Subject: help Thank you. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registerd Linux user No #267004 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Digest for list users@openoffice.org
Vladimir, You might want to check the Libre Office users list for help. The various L.O. lists are at: http://www.libreoffice.org/get-help/mailing-lists/ --David On 2/11/2012 6:36 AM, users-requ...@openoffice.org wrote: Table of contents: 1. [users] writer - Vladimir Ivanovvladi@abv.bg End of digest for list users@openoffice.org - Sat, 11 Feb 2012 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: writer
2012/2/10 Vladimir Ivanov vladi@abv.bg Hello ! How to open word document with one too large table on the many pages ? I use LibreOffice 3.4.4. With Microsoft Office 2003 I have not any trouble but I want migrate to Libre Thanks ! Valdimir, as you are using LibreOffice, you might want to direct your query to the Document Foundation forum - disc...@documentfoundation.org Henri -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Looking for a couple of functions in Calc
On Sat, 2012-02-11 at 08:52 -0700, John Meyer wrote: 1. (noob alert). I'm looking for a function where I can check a particular cell for text and color the cell based upon that value. 2. I'm also looking for a function that can either list the unique values in a column, or the count of unique values in a column. Have you looked in the Calc Guide. The things you want are called conditional formatting. This guide describes how to do this. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: writer
On Saturday, February 11, 2012 06:10:15 PM M Henri Day wrote: 2012/2/10 Vladimir Ivanov vladi@abv.bg Hello ! How to open word document with one too large table on the many pages ? I use LibreOffice 3.4.4. With Microsoft Office 2003 I have not any trouble but I want migrate to Libre Thanks ! Valdimir, as you are using LibreOffice, you might want to direct your query to the Document Foundation forum - disc...@documentfoundation.org Henri better place to get answer maybe: CODE - us...@global.libreoffice.org /CODE - Russ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Looking for a couple of functions in Calc
Hi John, http://openoffice.blogs.com/openoffice/2008/05/copying-only-th.html The link above will take you to a blog that explains how to achieve #2. As someone else pointed out, for #1, check the help for conditional formatting . tc From: John Meyer pueblonat...@opensuse.us To: users@openoffice.org Sent: Saturday, February 11, 2012 10:52:46 AM Subject: [users] Looking for a couple of functions in Calc 1. (noob alert). I'm looking for a function where I can check a particular cell for text and color the cell based upon that value. 2. I'm also looking for a function that can either list the unique values in a column, or the count of unique values in a column. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: writer
Оригинално писмо От: M Henri Day Относно: [users] Re: writer До: users@openoffice.org Изпратено на: Събота, 2012, Февруари 11 19:10:15 EET 2012/2/10 Vladimir Ivanov Hello ! How to open word document with one too large table on the many pages ? I use LibreOffice 3.4.4. With Microsoft Office 2003 I have not any trouble but I want migrate to Libre Thanks !Valdimir, as you are using LibreOffice, you might want to direct your query to the Document Foundation forum - disc...@documentfoundation.orghen Thanks Henry, but I have the same problem with OpenOffice too -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: writer
2012/2/11 Vladimir Ivanov vladi@abv.bg Оригинално писмо От: M Henri Day Относно: [users] Re: writer До: users@openoffice.org Изпратено на: Събота, 2012, Февруари 11 19:10:15 EET 2012/2/10 Vladimir Ivanov Hello ! How to open word document with one too large table on the many pages ? I use LibreOffice 3.4.4. With Microsoft Office 2003 I have not any trouble but I want migrate to Libre Thanks !Valdimir, as you are using LibreOffice, you might want to direct your query to the Document Foundation forum - disc...@documentfoundation.orghen Thanks Henry, but I have the same problem with OpenOffice too Vladimir, given the common origin of these two office suites, the problems one encounters in LibreOffice are, as you surely know, very likely to be encountered in OpenOffice as well. The reason I suggested you post to a LibreOffice forum is that I have found fellow users there to be very helpful. But the choice is, of course, yours Henri (with «i») -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Page Break Lines OOCalc
Hi Mark, Tools / option / calc / view. Uncheck 'Page Breaks' under 'Visual Aids'. tc From: Mark LaPierre marklap...@aol.com To: Sent: Saturday, February 11, 2012 10:03:32 PM Subject: [users] Page Break Lines OOCalc Does anyone know how to turn off the appearance of page break lines on OO Calc? When I go to View/Page Break Preview the work sheet is displayed with all the page breaks and the page numbers in phantom gray as would be expected, but when I switch back to View/Normal the page breaks are still visible. They look like I set a border around each page. Notice the vertical and horizontal line to the left and below the selected cell on the attached screen shot. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registerd Linux user No #267004 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Data Base Litriture
Usually that depends on the country you're living. Where are you? El 05/02/12 12:21, Brian Smith escribi: Is there a book that I can purchase with instructions for using your data base? Brian Smith
[users] Re: Data Base Litriture
On Wed, Feb 08, 2012 at 01:26:45PM -0200, Sylvia S�nchez wrote: html head meta content=text/html; charset=ISO-8859-1 http-equiv=Content-Type ..snip. D*O N*O*T P*O*S*T I*N H*T*M*L! -- Bob Holtzman If you think you're getting free lunch, check the price of the beer. Key ID: 8D549279 signature.asc Description: Digital signature
[users] Re: Where Do Base Reports Store The Desired Query?
Girvin, thank you very much. I never noticed that the query (field = xxx) was buried in that Content statement. I made the change and it worked as expected in the report. I am going to make sure I save your response for future reference. On 2/7/12 6:36 AM, users-requ...@openoffice.org wrote: Subject: [users] Re: Where Do Base Reports Store The Desired Query? From: Girvin R. Herr girvin.h...@sbcglobal.net Date: 2/6/12 6:30 PM To: users@openoffice.org Michael Reich wrote: I've been using a Base database for my stamp collection and each year, I copy the previous year's report structure to a new object for the current year. At the same time, I copy/edit the previous year's Query to a current year query, and edit it to reflect selection of the current year () for the query. The query then selects the right records. However, each year I struggle with updating the report format so it knows to use the most current query to produce the report. I have no idea how I managed to edit the previous report structures to do what I want, but I did. Unfortunately, I'm stuck this year and can't get the report for 2012 to show the 2012 records (it shows the 2011 records, because the 2012 query was a copy of the 2011 query). I don't know why OO has to be as obtuse as it is in making such a basic edit in a report definition, but I can't find it. How do you edit a report to change the query it should use (where is this setting hidden)? Can someone point me in the right direction to make this edit? Thanks for any help! Michael, I have not had to do this yet, so this procedure is not proven and others in this group may add or subtract from it. It does work when I copy a report or form and have to point the new report or form to another, identical structure, database. Here is what I discovered: Right click on the report name in the main window. Chose edit. When the report editing window comes up, left click somewhere in the center window, not on an object, just the background will do. In the right pane, you should see tabs with General and Data names. Click on Data. Edit the Content field to your new query name. That should do it, after you save the report. Don't forget to click on the save icon in the main window also. Both saves must be done to properly save the changes. Note: this process should also work for forms, although I had to right click on an object in the form, not the background, in order to get the Data tab. You must make sure the Data is for the entire report/form, not just the field. HTH Girvin Herr -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Help!!
On Mon, 2012-02-06 at 18:53 +, ELE v. wrote: Ciao non so se parlate italiano o inglese e non so nemmeno se leggerete mai questa mail..ma io sono disperata e provo lo stesso! Ho bisogno di un'informazione importantissima: il mio open office non mi numera le ultime pagine di un documento di 52 pagine. Ho fatto partire la numerazione dal numero 3, mettendo come correzione nei comandi di campo +2...dal 3 al 52 le numera...53 e 54 no! perchè? aiutatemi per favore!!! Hi, i don't know if you speak italian or english and i don't know if you will read this mail..but i'm going to be crazy so i try to send it! I need a very important information: my open office program don't want to put numbers in the last two pages of my document, made of 52 pages. The first page begin with the number 3 and from number 3 to 52 there aren't problems...but the last two pages, 54 and 55, are without number!!! WHY help me please!! THANKS A LOT! You did not say where your page numbers are located. Are they in the header or footer perhaps? I'm not sure what your problem is, but it sounds like the last two pages have a different page style than pages numbered 3 through 52. If the page numbers are in the header or footer and the last two pages are a different page style, do the header or footer have a page number field? --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Help!!
At 18:53 06/02/2012 +, Elena Vonly wrote: i don't know if you speak italian or english ... I can do English! ... and i don't know if you will read this mail..but I'm going [] crazy so i try to send it! I need a very important information: my open office program don't want to put numbers in the last two pages of my document, made of 52 pages. The first page begin with the number 3 and from number 3 to 52 there aren't problems...but the last two pages, 54 and 55, are without number! WHY? You have probably set the page number to start other than at 1 using the Offset value in the Edit Fields panel. Perversely, it seems that page numbers set this way cannot exceed the actual number of pages in the document. There are 52 pages in your document and no page number larger than 52 will be displayed. Possible workarounds: o Create two empty pages at the start of your document. o Number the pages normally. o Print only pages 3 to 54 - numbered 3 to 54. o Put the cursor at the start of your document. o Go to Insert | Manual Break... . o Select Page break. o Under Style, select your existing page style from the drop-down list. o Tick Change page number. o Set the value below to be 3. o Print all but the first (empty) page. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Data Base Litriture
On Sun, 2012-02-05 at 14:21 +, Brian Smith wrote: Is there a book that I can purchase with instructions for using your data base? Brian Smith We are in the process of writing the Base Guide, but there is not a book yet. You are free to download any of these. Introducing Base is basically ready for publication although it is still classified as a Draft. The same is true for Getting Started with Base chapter. This is the first chapter of the future Base Guide: Introducing Base with the accompany database. http://www.odfauthors.org/openoffice.org/english/userguide3/db3/dbg3_draft/introducing-base/view http://www.odfauthors.org/openoffice.org/english/userguide3/db3/dbg3_draft/flat-database-example/view Another suggestion is this link: http://www.odfauthors.org/openoffice.org/english/userguide3/gs3/V3_3_revisions/0108GS3-GettingStartedWithBase.odt/view . This is the Getting Started with Base chapter of the Getting Started Guide. http://www.odfauthors.org/openoffice.org/english/userguide3/db3/dbg3_draft/datatbase-for-getting-started-with-base/view. This is the database that goes with Getting Started with Base. Also contained in the draft folder (link below) are chapters 2-4 of the Base Guide in Draft form which you can also download if you want. The names of the chapters are Planning/Designing your Database, Data Input and Removal, and Data Output respectively. If you download any of these, you should also download Relational database example as these chapters refer to this database. http://www.odfauthors.org/openoffice.org/english/userguide3/db3/dbg3_draft/ --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Where Do Base Reports Store The Desired Query?
Michael Reich wrote: I've been using a Base database for my stamp collection and each year, I copy the previous year's report structure to a new object for the current year. At the same time, I copy/edit the previous year's Query to a current year query, and edit it to reflect selection of the current year () for the query. The query then selects the right records. However, each year I struggle with updating the report format so it knows to use the most current query to produce the report. I have no idea how I managed to edit the previous report structures to do what I want, but I did. Unfortunately, I'm stuck this year and can't get the report for 2012 to show the 2012 records (it shows the 2011 records, because the 2012 query was a copy of the 2011 query). I don't know why OO has to be as obtuse as it is in making such a basic edit in a report definition, but I can't find it. How do you edit a report to change the query it should use (where is this setting hidden)? Can someone point me in the right direction to make this edit? Thanks for any help! Michael, I have not had to do this yet, so this procedure is not proven and others in this group may add or subtract from it. It does work when I copy a report or form and have to point the new report or form to another, identical structure, database. Here is what I discovered: Right click on the report name in the main window. Chose edit. When the report editing window comes up, left click somewhere in the center window, not on an object, just the background will do. In the right pane, you should see tabs with General and Data names. Click on Data. Edit the Content field to your new query name. That should do it, after you save the report. Don't forget to click on the save icon in the main window also. Both saves must be done to properly save the changes. Note: this process should also work for forms, although I had to right click on an object in the form, not the background, in order to get the Data tab. You must make sure the Data is for the entire report/form, not just the field. HTH Girvin Herr -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Page Headings - How?
On Friday 03 Feb 2012 15:33:49 Harold Fuchs wrote: OOo 3.2.1 (I know!) on Win XP Pro Please, how do I actually tell OOo what the *text* is I want in my page headers? In my page footers? Separately for left/right page headers? Separately for left/right page footers? Separately for different page styles? My point is that I can't find anywhere that links the (text + fields + attributes) of the header/footer to the particular style. I thought that when I specify, for example, a Page Header style I'd get the chance to specify the text/fields/attributes and where (left/centre/right) I want them. But no. I'm obviously missing something fundamental. What, please? Oh, by attributes I mean things like font size, font, boldness/underlined/... etc. etc Harold : Like Mike Scott m...@scottsonline.org.uk said, I am probably being naive, and am not understanding the *whole* issue: I am able to get the right/left headers (and/or footers) to have specific attributes that I can set. Here is how: Disclaimer :- NOT on OOo, but on Libre: however, I do not think that there should be too many differences as far as these operations are concerned. My apologies : the text following this may seem to be far too detailed, and pedantic, for an apparent simple solution. 0. Open a new document 1. Invoke the Styles and Formatting window (F11) 2a. Choose Page Styles 2b. Choose Left Page, right click, and choose New 2c. In organizer: Name the style to something appropriate 2d. In Header/Footer, choose the Header On, and Footer On options 2e. Set whatever you need to set in the headers/footers in terms of background lines, line colors, position of lines etc by choosing the More button, and save 2f. Repeat steps 2b to 2e for Right Page, and save 2g. Select the newly created Left Page (say harold-left-page), right click, and choose modify 2h. In Organizer, select the newly created Right Page (say, harold-right-page) as the Next Style, and save 2g. In Organizer, select the newly created harold-right-page, and, by following 2h above, set the Next Style to harold-left-page /* ** This should complete the page setup : please set margins, ** page sizes etc., appropriately */ 3a. Choose Paragraph Styles 3b. There should be Footer Left and Footer Right styles. If these styles do NOT exist, then, choose Footer, right click, and choose New. Otherwise, go to 3f. 3c. In the organizer, set the name to be (say) harold-left-page-header [or footer, as the case may be] 3d. Set the font, and other attributes (spacing, alignment, borders etc etc) to suit your requirements 3e. Repeat 3c and 3d for the footer style 3f. If styles Footer Left and Footer Right already exist, then, for each of these styles, right click, choose new, and repeat 3c, 3d /* ** You should now have the header and footer attributes set as ** per your requirements. Modify these styles (i.e., what you ** created - the harold-left-page-header etc.) when you want ** any changes to be effected. */ 4. Place the cursor on the page that is visible to you (remember, it is a new document!), and, in the Page Styles (repeat, PAGE style), double click on the newly created harold-left-page. 4a. The page should show the attributes for the Left Page. 4b. Place cursor in the header area 4c. In the Para Styles, choose the header that you created as a part of step 3c. 4d. Repeat 4b and 4c for the Footer, choosing the appropriate footer paragraph style /* ** The para style for the headers and footers should now be set ** for all LEFT pages */ 5. Fill in the page with text as you may normally do, so that OOo would insert a new page, or force insert a new page by using Insert - Manual Break - Page Break : in the Style box, choose the RIGHT page you created as a part of Step 3c. 6. Repeat steps 4b through 4d for the RIGHT page. 7. From this point on, the page header/footer for each of the Right and Left pages should be automatically inserted as and when the respective pages are filled, and a new page automatically inserted : the trick is in the Next Style that we choose as a part of 2h and 2g. Once again, my apologies for a very long (and probably unnecessary) explanation. Hope that this helps. Pradeep Srinivas on Feb 05 2012, Sunday, 18:20 IST (which is GMT +05:30) -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Page Headings - How?
On 03/02/12 10:03, Harold Fuchs wrote: OOo 3.2.1 (I know!) on Win XP Pro Please, how do I actually tell OOo what the *text* is I want in my page headers? In my page footers? Separately for left/right page headers? Separately for left/right page footers? Separately for different page styles? My point is that I can't find anywhere that links the (text + fields + attributes) of the header/footer to the particular style. I thought that when I specify, for example, a Page Header style I'd get the chance to specify the text/fields/attributes and where (left/centre/right) I want them. But no. I'm obviously missing something fundamental. What, please? Oh, by attributes I mean things like font size, font, boldness/underlined/... etc. etc Hi Harold. Maybe I'm being naive and am misunderstanding, but I can't see the issue. I've just tried an experiment. New document. I set up left and right page styles to 'ping pong' as usual, and put different daft margins in so I can be sure which style is in use. I created a some pages, then went to a 'left' page, and did 'Insert header' and put some text with a crazy style; then went to a right page and did something differently peculiar. It all seems to 'just work' - all 'left' pages now have the one header and style, all 'right' pages the other. And if I change a page style with the stylist, the header contents and style change to match (eg jam the 'right' style onto a 'left' page -- everything switches around.) I do notice also that 'Insert header' now has 3 sub entries - 'default', 'left' and 'right' corresponding to the page styles in use. Am I missing something you need, or maybe you're trying to make it too complex?? (I /do/ have an issue with the way page styles chain one to the next, but that's something separate I reckon.) -- Mike Scott Harlow, Essex, England -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: My database woes
After some tinkering, I was able to create a database that will do at least some of the things you want it to do. In the end, I created a form that contains (as the main form) the Author's name, Book Title, Editor's name. As the sub form, it shows the query results which include Date Assigned to the Editor, Date Editing Completed, Due Date, Days of Editing allowed, Days of Editing done. Is this something that you could use? I could send it to you off list. With your mathematical background, perhaps you will be able to follow my logic in the way I created the queries and tables. --Dan On Wed, 2012-02-01 at 19:44 -0800, Jeffrey Needle wrote: Well, I need to set aside time to see if it all will work. I'm not at all negative about the idea, and yes, my background is in mathematics. Thanks for all the help. - Original Message - From: Dan Lewis elderdanle...@gmail.com To: users@openoffice.org Sent: Wednesday, February 1, 2012 6:07:57 PM Subject: [users] Re: My database woes How do you know they won't do what you want to do? Have you given up before you even try them? I have a form in which I can enter information into a table and also has the results of a query based upon that table. When I enter data into the table, the query updates itself. Planning/Designing a database takes time. I gave you one way to get what you wanted with some limitations. There are other ways to do it. Sometimes it pays to have a good mathematical background to accomplish what you want to do. For example, you mentioned that you needed to know what date is a specific number of days after a given day. You also mentioned needing to know the difference between two dates. Base has a function DATEDIFF that can be used to do both of these things. In the second one, you will need a table that contains the beginning and ending dates. This function will tell you the difference. In the first case, you need two fields: one for the beginning date, and another field contains dates into the future for the ending date. Then the query can use DATEDIFF('dd',beginning date,ending date) = n where n is the number of days. With some time, I can probably create what you want. But then again, I think I can do it. If you have a math background as it sounds like you do, you should be able to do it also. But if you don't think you can, you won't. One more thing. Another thing. Base uses the HSQLDB database engine version 1.8. The online User Guide is here: http://hsqldb.org/doc/guide/guide.html. Chapter 9 has the built-in date functions and how to use them. I could also send you a copy of the user guide for HSQLDB 1.8. It is a PDF. --Dan On Wed, 2012-02-01 at 13:53 -0800, Jeffrey Needle wrote: Thanks so much. These are a help. Queries are good, but they don't end up doing what I really want to do -- just enter the data in a form and have the calculation done for you live. Other pages you offer give me some ideas. Many thanks again. - Original Message - From: NoOp gl...@sbcglobal.net To: users@openoffice.org Sent: Wednesday, February 1, 2012 12:13:59 PM Subject: [users] Re: My database woes On 01/31/2012 06:02 PM, Jeffrey Needle wrote: Using OpenOffice 3.2 on a Linux system. This may sound a bit like a whine; it's actually a plea for help. OpenOffice's database has some fine features, but, amazingly, you can't do simple calculations -- especially date calculations -- in the database module. Sure you can: ttp://openoffice.blogs.com/openoffice/2007/03/creating_calcul.html http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports More: http://www.google.com/#sclient=psy-abhl=ensource=hpq=openoffice+%2Bbase+%2Bcalculations and for dates, try: http://www.google.com/search?sclient=psy-abhl=enbiw=1173bih=675source=hpq=openoffice+%2Bbase+%2Bdate+%2Bcalculationspbx=1oq=openoffice+%2Bbase+%2Bdate+%2Bcalculations Samples: http://user.services.openoffice.org/en/forum/viewtopic.php?t=6754 http://www.oooforum.org/forum/viewtopic.phtml?t=67907 http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Yahoo! Auto Response
David B Teague sr wrote: On 1/27/2012 7:36 AM, birdie...@prodigy.net wrote: MESSAGE FAILURE NOTICE ; Yahoo domains currently sends a bounce-back reply even though the messages are being received. Office Hours; Tuesday 8:30-4:30pm Thursday 8:30am-6pm Friday's 8:30am-7pm Is there anything I need to do? David Teague No, someone's mail is bouncing list mail. There's nothing you can do. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: My database woes
On Tue, 2012-01-31 at 18:02 -0800, Jeffrey Needle wrote: Using OpenOffice 3.2 on a Linux system. This may sound a bit like a whine; it's actually a plea for help. OpenOffice's database has some fine features, but, amazingly, you can't do simple calculations -- especially date calculations -- in the database module. I'm a book review editor. I assign books to reviewers, and I need to calculate the date the review is due based on the date the book is received by the reviewer. I need to calculate how long the book has been out to the reviewer. Etc., etc. Now, all of this is done simply in the spreadsheet, but the interface lacks the kind of visual clarity that the database gives me. Scrolling across the screen to get data is distracting and annoying. So, my question. I think I can create a database and link it to a spreadsheet. If I enter data in the database, will it obey the commands I have set up in the spreadsheet? Will it display the calculations in real time? I don't know if it's possible. Any help will be appreciated. Thanks. When you use Base to connect to a spreadsheet, the tables are read only. You can not add nor modify data in the spreadsheet using Base. What you can do is create the spreadsheet in Calc (which I think you may have already done). Use Calc to update the spreadsheet. Also use Base to connect to the spreadsheet which creates a .odb database document file. Using this file you can create forms, queries, and or reports of the spreadsheet. One slight problem that I have noticed. When Base opens the database file, it gathers information from the spreadsheet at that time. But any updating of the spreadsheet is not reflected in tables of the .odb file. After updating the spreadsheet, Base must be closed and then opened to show the updated data. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: My database woes
On 01/31/2012 06:02 PM, Jeffrey Needle wrote: Using OpenOffice 3.2 on a Linux system. This may sound a bit like a whine; it's actually a plea for help. OpenOffice's database has some fine features, but, amazingly, you can't do simple calculations -- especially date calculations -- in the database module. Sure you can: ttp://openoffice.blogs.com/openoffice/2007/03/creating_calcul.html http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports More: http://www.google.com/#sclient=psy-abhl=ensource=hpq=openoffice+%2Bbase+%2Bcalculations and for dates, try: http://www.google.com/search?sclient=psy-abhl=enbiw=1173bih=675source=hpq=openoffice+%2Bbase+%2Bdate+%2Bcalculationspbx=1oq=openoffice+%2Bbase+%2Bdate+%2Bcalculations Samples: http://user.services.openoffice.org/en/forum/viewtopic.php?t=6754 http://www.oooforum.org/forum/viewtopic.phtml?t=67907 http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions ... -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: My database woes
Thanks so much. These are a help. Queries are good, but they don't end up doing what I really want to do -- just enter the data in a form and have the calculation done for you live. Other pages you offer give me some ideas. Many thanks again. - Original Message - From: NoOp gl...@sbcglobal.net To: users@openoffice.org Sent: Wednesday, February 1, 2012 12:13:59 PM Subject: [users] Re: My database woes On 01/31/2012 06:02 PM, Jeffrey Needle wrote: Using OpenOffice 3.2 on a Linux system. This may sound a bit like a whine; it's actually a plea for help. OpenOffice's database has some fine features, but, amazingly, you can't do simple calculations -- especially date calculations -- in the database module. Sure you can: ttp://openoffice.blogs.com/openoffice/2007/03/creating_calcul.html http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports More: http://www.google.com/#sclient=psy-abhl=ensource=hpq=openoffice+%2Bbase+%2Bcalculations and for dates, try: http://www.google.com/search?sclient=psy-abhl=enbiw=1173bih=675source=hpq=openoffice+%2Bbase+%2Bdate+%2Bcalculationspbx=1oq=openoffice+%2Bbase+%2Bdate+%2Bcalculations Samples: http://user.services.openoffice.org/en/forum/viewtopic.php?t=6754 http://www.oooforum.org/forum/viewtopic.phtml?t=67907 http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions ... -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: My database woes
When you use Base to connect to a spreadsheet, the tables are read only. You can not add nor modify data in the spreadsheet using Base. What you can do is create the spreadsheet in Calc (which I think you may have already done). Use Calc to update the spreadsheet. Also use Base to connect to the spreadsheet which creates a .odb database document file. Using this file you can create forms, queries, and or reports of the spreadsheet. One slight problem that I have noticed. When Base opens the database file, it gathers information from the spreadsheet at that time. But any updating of the spreadsheet is not reflected in tables of the .odb file. After updating the spreadsheet, Base must be closed and then opened to show the updated data. --Dan Thanks so much for the information. I'm understanding more and more that base won't do what I'd love to do -- have a live database in front of me that updates information as you enter it. The Linux world is absolutely miserable when it comes to offering database clients. Lots of SQL stuff, some embedded code, etc. The old DOS world was perfect -- had lots of offerings, like QA, Alpha Four, File Express, etc. It seems we've moved beyond the simple. It's a pity. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Consulta
Hello Ximena, On Tue, Jan 31, 2012 at 12:03:53PM -0400, Ximena Moreta wrote: Good afternoon, Progress4gl work with and I'm doing reports in OpenOffice, where I can find information about the commands for programming in progress with openoffice as: chWorkSheet: getCellByPosition hDesktop: loadComponentFromURL it looks you're doing something similar to http://www.oehive.org/files/calcUtils.i.txt I know nothing about Progress4gl but it looks similar to the ole bridge. First you have to create the ServiceManager: CREATE com.sun.star.ServiceManager chOpenOffice CONNECT NO-ERROR. Then use the ServiceManager to instantiate services, like the Desktop service com.sun.star.frame.Desktop: chDesktop = chOpenOffice:createInstance(com.sun.star.frame.Desktop) This service is documented at http://www.openoffice.org/api/docs/common/ref/com/sun/star/frame/Desktop.html A service implements interfaces, that define methods (and sometime attributes). In this case, the Desktop service implements * com.sun.star.frame.XDesktop * com.sun.star.frame.XComponentLoader This last one is the one that defines the loadComponentFromURL method: http://www.openoffice.org/api/docs/common/ref/com/sun/star/frame/XComponentLoader.html#loadComponentFromURL So, resuming: find a service documentation and look at the interfaces it implements. Then invoke this method on the instance you created: chWorkBook = chDesktop:loadComponentFromURL(private:factory/scalc,_blank, 0, cc). In this case, as you are loading a Spreadsheet document, you get a com.sun.star.sheet.SpreadsheetDocument http://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/SpreadsheetDocument.html You can also search a specific method in the Index: for example, getCellByPosition under G http://www.openoffice.org/api/docs/common/ref/index-files/index-7.html will lead you to getCellByPosition() - function in interface ::com::sun::star::table::XCellRange getCellByPosition() - function in interface ::com::sun::star::sheet::XCellRangesAccess ... OpenOffice API is a little complicated, you may find useful reading the OOo Basic documentation or the Developer's Guide (it has examples in Java). Regards -- Ariel Constenla-Haile La Plata, Argentina pgpcYNU0ASfJr.pgp Description: PGP signature
[users] Re: My database woes
How do you know they won't do what you want to do? Have you given up before you even try them? I have a form in which I can enter information into a table and also has the results of a query based upon that table. When I enter data into the table, the query updates itself. Planning/Designing a database takes time. I gave you one way to get what you wanted with some limitations. There are other ways to do it. Sometimes it pays to have a good mathematical background to accomplish what you want to do. For example, you mentioned that you needed to know what date is a specific number of days after a given day. You also mentioned needing to know the difference between two dates. Base has a function DATEDIFF that can be used to do both of these things. In the second one, you will need a table that contains the beginning and ending dates. This function will tell you the difference. In the first case, you need two fields: one for the beginning date, and another field contains dates into the future for the ending date. Then the query can use DATEDIFF('dd',beginning date,ending date) = n where n is the number of days. With some time, I can probably create what you want. But then again, I think I can do it. If you have a math background as it sounds like you do, you should be able to do it also. But if you don't think you can, you won't. One more thing. Another thing. Base uses the HSQLDB database engine version 1.8. The online User Guide is here: http://hsqldb.org/doc/guide/guide.html. Chapter 9 has the built-in date functions and how to use them. I could also send you a copy of the user guide for HSQLDB 1.8. It is a PDF. --Dan On Wed, 2012-02-01 at 13:53 -0800, Jeffrey Needle wrote: Thanks so much. These are a help. Queries are good, but they don't end up doing what I really want to do -- just enter the data in a form and have the calculation done for you live. Other pages you offer give me some ideas. Many thanks again. - Original Message - From: NoOp gl...@sbcglobal.net To: users@openoffice.org Sent: Wednesday, February 1, 2012 12:13:59 PM Subject: [users] Re: My database woes On 01/31/2012 06:02 PM, Jeffrey Needle wrote: Using OpenOffice 3.2 on a Linux system. This may sound a bit like a whine; it's actually a plea for help. OpenOffice's database has some fine features, but, amazingly, you can't do simple calculations -- especially date calculations -- in the database module. Sure you can: ttp://openoffice.blogs.com/openoffice/2007/03/creating_calcul.html http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports More: http://www.google.com/#sclient=psy-abhl=ensource=hpq=openoffice+%2Bbase+%2Bcalculations and for dates, try: http://www.google.com/search?sclient=psy-abhl=enbiw=1173bih=675source=hpq=openoffice+%2Bbase+%2Bdate+%2Bcalculationspbx=1oq=openoffice+%2Bbase+%2Bdate+%2Bcalculations Samples: http://user.services.openoffice.org/en/forum/viewtopic.php?t=6754 http://www.oooforum.org/forum/viewtopic.phtml?t=67907 http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions ... -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: My database woes
Well, I need to set aside time to see if it all will work. I'm not at all negative about the idea, and yes, my background is in mathematics. Thanks for all the help. - Original Message - From: Dan Lewis elderdanle...@gmail.com To: users@openoffice.org Sent: Wednesday, February 1, 2012 6:07:57 PM Subject: [users] Re: My database woes How do you know they won't do what you want to do? Have you given up before you even try them? I have a form in which I can enter information into a table and also has the results of a query based upon that table. When I enter data into the table, the query updates itself. Planning/Designing a database takes time. I gave you one way to get what you wanted with some limitations. There are other ways to do it. Sometimes it pays to have a good mathematical background to accomplish what you want to do. For example, you mentioned that you needed to know what date is a specific number of days after a given day. You also mentioned needing to know the difference between two dates. Base has a function DATEDIFF that can be used to do both of these things. In the second one, you will need a table that contains the beginning and ending dates. This function will tell you the difference. In the first case, you need two fields: one for the beginning date, and another field contains dates into the future for the ending date. Then the query can use DATEDIFF('dd',beginning date,ending date) = n where n is the number of days. With some time, I can probably create what you want. But then again, I think I can do it. If you have a math background as it sounds like you do, you should be able to do it also. But if you don't think you can, you won't. One more thing. Another thing. Base uses the HSQLDB database engine version 1.8. The online User Guide is here: http://hsqldb.org/doc/guide/guide.html. Chapter 9 has the built-in date functions and how to use them. I could also send you a copy of the user guide for HSQLDB 1.8. It is a PDF. --Dan On Wed, 2012-02-01 at 13:53 -0800, Jeffrey Needle wrote: Thanks so much. These are a help. Queries are good, but they don't end up doing what I really want to do -- just enter the data in a form and have the calculation done for you live. Other pages you offer give me some ideas. Many thanks again. - Original Message - From: NoOp gl...@sbcglobal.net To: users@openoffice.org Sent: Wednesday, February 1, 2012 12:13:59 PM Subject: [users] Re: My database woes On 01/31/2012 06:02 PM, Jeffrey Needle wrote: Using OpenOffice 3.2 on a Linux system. This may sound a bit like a whine; it's actually a plea for help. OpenOffice's database has some fine features, but, amazingly, you can't do simple calculations -- especially date calculations -- in the database module. Sure you can: ttp://openoffice.blogs.com/openoffice/2007/03/creating_calcul.html http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports More: http://www.google.com/#sclient=psy-abhl=ensource=hpq=openoffice+%2Bbase+%2Bcalculations and for dates, try: http://www.google.com/search?sclient=psy-abhl=enbiw=1173bih=675source=hpq=openoffice+%2Bbase+%2Bdate+%2Bcalculationspbx=1oq=openoffice+%2Bbase+%2Bdate+%2Bcalculations Samples: http://user.services.openoffice.org/en/forum/viewtopic.php?t=6754 http://www.oooforum.org/forum/viewtopic.phtml?t=67907 http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions ... -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: question
Jill Cannon wrote: Hello: I just downloaded OpenOffice to use on my computer...very nice. My question is can I delete the installation file now? Both the app and the installation folder are sitting on my desktop and I have often made the mistake of opening the installation folder rather than the app folder. I look forward to your response. Jill cannon Yes, it can be removed. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Yahoo! Auto Response
On 1/27/2012 7:36 AM, birdie...@prodigy.net wrote: MESSAGE FAILURE NOTICE ; Yahoo domains currently sends a bounce-back reply even though the messages are being received. Office Hours; Tuesday 8:30-4:30pm Thursday 8:30am-6pm Friday's 8:30am-7pm Is there anything I need to do? David Teague -- nil significat nisi oscillat -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: countif on multiple items
At 22:31 29/01/2012 -0600, Wade Smart wrote: On Thu, Jan 26, 2012 at 20:07, Brian Barker wrote: At 19:21 26/01/2012 -0600, Wade Smart wrote: I need a total based on two columns. For example: A1 = Black A3 = Dk Blue A9 = White C1 = x C3 = C9 = x If a1=Black AND c1 = x then count this as one. Can you count if with two columns? Yes: =SUMPRODUCT(A1:A99=Black;C1:C99=x) The conditions are either TRUE or FALSE. Â When interpreted as numbers, these values are 1 and 0 respectively. Â The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. Â The resulting true (=1) values are then summed. I need to add one more step to this. I have another column.. D lets say. It has a number in it. In my original example I needed to count a entry if it was active. So I have a lot of entries with Black as one indicator and some of those Black entries will have an x in another column. I needed to sum those up. And sumproduct() did great. Now I would like to see if there is a automated way of doing this next step: If A1=Black and C1=x, I need to sum column. AB. (Er, is that D or AB?) Easy: =SUMPRODUCT(A1:A99=Black;C1:C99=x;AB1:AB99) SUMPRODUCT() can take more than two arguments. As before, the product of the first two logical tests is either TRUE (1) or FALSE (0). Now we multiply each value in column AB by this switch and then sum the results. I trust this also helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: countif on multiple items
On Mon, Jan 30, 2012 at 03:35, Brian Barker b.m.bar...@btinternet.com wrote: At 22:31 29/01/2012 -0600, Wade Smart wrote: On Thu, Jan 26, 2012 at 20:07, Brian Barker wrote: At 19:21 26/01/2012 -0600, Wade Smart wrote: I need a total based on two columns. For example: A1 = Black A3 = Dk Blue A9 = White C1 = x C3 = C9 = x If a1=Black AND c1 = x then count this as one. Can you count if with two columns? Yes: =SUMPRODUCT(A1:A99=Black;C1:C99=x) The conditions are either TRUE or FALSE. Â When interpreted as numbers, these values are 1 and 0 respectively. Â The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. Â The resulting true (=1) values are then summed. I need to add one more step to this. I have another column.. D lets say. It has a number in it. In my original example I needed to count a entry if it was active. So I have a lot of entries with Black as one indicator and some of those Black entries will have an x in another column. I needed to sum those up. And sumproduct() did great. Now I would like to see if there is a automated way of doing this next step: If A1=Black and C1=x, I need to sum column. AB. (Er, is that D or AB?) Easy: =SUMPRODUCT(A1:A99=Black;C1:C99=x;AB1:AB99) SUMPRODUCT() can take more than two arguments. As before, the product of the first two logical tests is either TRUE (1) or FALSE (0). Now we multiply each value in column AB by this switch and then sum the results. I trust this also helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help Oh! That is great! I have a lot of uses for this. Thanks Brian! Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Back Button
On 1/30/2012 10:50 AM, Tom Cole wrote: Does Open Office have a back/undo/return button/arrow in there spreadsheet? Tom Undo should be the first option on the drop down menu under edit . David Teague -- nil significat nisi oscillat -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Back Button
On Mon, 2012-01-30 at 15:03 -0500, David B Teague sr wrote: On 1/30/2012 10:50 AM, Tom Cole wrote: Does Open Office have a back/undo/return button/arrow in there spreadsheet? Tom Undo should be the first option on the drop down menu under edit . David Teague -- nil significat nisi oscillat The Undo button is just to the right of the cut, copy, and paste buttons. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Back Button
On 1/30/2012 5:06 PM, Dan Lewis wrote: On Mon, 2012-01-30 at 15:03 -0500, David B Teague sr wrote: On 1/30/2012 10:50 AM, Tom Cole wrote: Does Open Office have a back/undo/return button/arrow in there spreadsheet? Tom Undo should be the first option on the drop down menu under edit . David Teague -- nil significat nisi oscillat The Undo button is just to the right of the cut, copy, and paste buttons. --Dan SO it is. I never use that particular button. It's the one with a sort of a hook one way for undo and the other for re-do. --David -- nil significat nisi oscillat -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Back Button
David B Teague sr wrote: On 1/30/2012 5:06 PM, Dan Lewis wrote: On Mon, 2012-01-30 at 15:03 -0500, David B Teague sr wrote: On 1/30/2012 10:50 AM, Tom Cole wrote: Does Open Office have a back/undo/return button/arrow in there spreadsheet? Tom Undo should be the first option on the drop down menu under edit . David Teague -- nil significat nisi oscillat The Undo button is just to the right of the cut, copy, and paste buttons. --Dan SO it is. I never use that particular button. It's the one with a sort of a hook one way for undo and the other for re-do. --David So far, nobody's mentioned this, but Ctrl-Z should undo also, if you prefer the keyboard over the mouse. Girvin Herr -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Back Button
On Mon, 2012-01-30 at 18:51 -0800, Girvin R. Herr wrote: David B Teague sr wrote: On 1/30/2012 5:06 PM, Dan Lewis wrote: On Mon, 2012-01-30 at 15:03 -0500, David B Teague sr wrote: On 1/30/2012 10:50 AM, Tom Cole wrote: Does Open Office have a back/undo/return button/arrow in there spreadsheet? Tom Undo should be the first option on the drop down menu under edit . David Teague -- nil significat nisi oscillat The Undo button is just to the right of the cut, copy, and paste buttons. --Dan SO it is. I never use that particular button. It's the one with a sort of a hook one way for undo and the other for re-do. --David So far, nobody's mentioned this, but Ctrl-Z should undo also, if you prefer the keyboard over the mouse. Girvin Herr While we are at it, Control+Y is redo. For the Mac: Command+Z for Undo Command+Shift+Z for Redo. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: countif on multiple items
On Thu, Jan 26, 2012 at 20:11, Wade Smart wadesm...@gmail.com wrote: On Thu, Jan 26, 2012 at 20:07, Brian Barker b.m.bar...@btinternet.com wrote: At 19:21 26/01/2012 -0600, Wade Smart wrote: I need a total based on two columns. For example: A1 = Black A3 = Dk Blue A9 = White C1 = x C3 = C9 = x If a1=Black AND c1 = x then count this as one. Can you count if with two columns? Yes: =SUMPRODUCT(A1:A99=Black;C1:C99=x) The conditions are either TRUE or FALSE. When interpreted as numbers, these values are 1 and 0 respectively. The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. The resulting true (=1) values are then summed. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help Great! Thanks for that Brian :D -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 I need to add one more step to this. I have another column.. D lets say. It has a number in it. In my original example I needed to count a entry if it was active. So I have a lot of entries with Black as one indicator and some of those Black entries will have an x in another column. I needed to sum those up. And sumproduct() did great. Now I would like to see if there is a automated way of doing this next step: If A1=Black and C1=x, I need to sum column. AB. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens apostrophes
thomas steel: *From:* THOMAS STEEL mailto:t.st...@virgin.net *Sent:* Friday, January 27, 2012 9:44 AM *To:* users-h...@openoffice.org mailto:users-h...@openoffice.org *Subject:* hyphens apostrophes I am struggling to recustomise OOWriter for a new computer after burglary. Am trying (1) to enable replacement of some hyphens by em en dashes (used to work by hitting hyphen twice). As Anthony pointed out, make sure Format menu AutoCorrect While Typing is ticked (click the menu item to toggle it if not). If that doesn't work, check that the specific options are set... From the Tools menu AutoCorrect Options Options tab, tick the box in the [T] column next to Replace dashes. Clicking the Help button in that dialog gives a description of the options, including which combinations of dashes are replaced. Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. From the same dialog (Tools AutoCorrect Options), but on the Custom Quotes tab, tick Replace for the types of quotes (single or double) you want to replace. You can also check that the replacement characters are correct (not easy to tell in the dialog, but clicking them shows the currently selected characters more clearly and allows you to change them). Have spent hours using Help to no effect. Please can someone help me? TM Steel Hope that helps, Mark. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Freezing columns in Calc
Jeffrey Needle: I'm using OpenOffice 3.2 on a Linux system. Freezing the top row of data is very easy. But it has become necessary for me also to freeze the first column of data, in order to keep it visible no matter how far I scroll to the right. I can't see a way to do that. Is it possible? Click in the top-left cell you want to be in the scrollable area, then enable Window Freeze. All columns to the left of the selected cell will remain fixed, as will all rows above. e.g. if you want freeze column A, and rows 1-4, click in cell B5 then Window Freeze. Hope that helps. Mark. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Freezing columns in Calc
On Sat, 2012-01-28 at 12:08 +, openoffice.mbou...@spamgourmet.com wrote: Jeffrey Needle: I'm using OpenOffice 3.2 on a Linux system. Freezing the top row of data is very easy. But it has become necessary for me also to freeze the first column of data, in order to keep it visible no matter how far I scroll to the right. I can't see a way to do that. Is it possible? Click in the top-left cell you want to be in the scrollable area, then enable Window Freeze. All columns to the left of the selected cell will remain fixed, as will all rows above. e.g. if you want freeze column A, and rows 1-4, click in cell B5 then Window Freeze. Hope that helps. Mark. Worked! Wonderful! Thanks so much. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens
FormatAutoCorrectWhileTyping is ticked, but it doesn't work. You advise that I 'Check that the specific options are set'. I suspect that the problem lies here. Can you tell me how to do that? I'd be so grateful. TS -Original Message- From: openoffice.mbou...@spamgourmet.com Sent: Saturday, January 28, 2012 11:36 AM To: users@openoffice.org Subject: [users] Re: hyphens apostrophes thomas steel: *From:* THOMAS STEEL mailto:t.st...@virgin.net *Sent:* Friday, January 27, 2012 9:44 AM *To:* users-h...@openoffice.org mailto:users-h...@openoffice.org *Subject:* hyphens apostrophes I am struggling to recustomise OOWriter for a new computer after burglary. Am trying (1) to enable replacement of some hyphens by em en dashes (used to work by hitting hyphen twice). As Anthony pointed out, make sure Format menu AutoCorrect While Typing is ticked (click the menu item to toggle it if not). If that doesn't work, check that the specific options are set... From the Tools menu AutoCorrect Options Options tab, tick the box in the [T] column next to Replace dashes. Clicking the Help button in that dialog gives a description of the options, including which combinations of dashes are replaced. Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. From the same dialog (Tools AutoCorrect Options), but on the Custom Quotes tab, tick Replace for the types of quotes (single or double) you want to replace. You can also check that the replacement characters are correct (not easy to tell in the dialog, but clicking them shows the currently selected characters more clearly and allows you to change them). Have spent hours using Help to no effect. Please can someone help me? TM Steel Hope that helps, Mark. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens
The specific options I was referring to are those under the Tools menu AutoCorrect Options, which I described below. Apologies that wasn't clear. For the replace dashes option, make sure it's ticked under [T] and not just [M] - options under [T] affect text as you type, while those under [M] only have an effect when you use Format AutoCorrect Apply. If they're all set and it's still not working, perhaps you could show an example of what you're typing and expect to be changed? e.g. A - B (A space dash space B space) should replace the dash with an en-dash A-B (A dash B space) - note no spaces around the dash is not expected to change the dash, even with the options set Mark. thomas steel: FormatAutoCorrectWhileTyping is ticked, but it doesn't work. You advise that I 'Check that the specific options are set'. I suspect that the problem lies here. Can you tell me how to do that? I'd be so grateful. TS -Original Message- From: openoffice.mbou...@spamgourmet.com Sent: Saturday, January 28, 2012 11:36 AM To: users@openoffice.org Subject: [users] Re: hyphens apostrophes thomas steel: I am struggling to recustomise OOWriter for a new computer after burglary. Am trying (1) to enable replacement of some hyphens by em en dashes (used to work by hitting hyphen twice). As Anthony pointed out, make sure Format menu AutoCorrect While Typing is ticked (click the menu item to toggle it if not). If that doesn't work, check that the specific options are set... From the Tools menu AutoCorrect Options Options tab, tick the box in the [T] column next to Replace dashes. Clicking the Help button in that dialog gives a description of the options, including which combinations of dashes are replaced. Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. From the same dialog (Tools AutoCorrect Options), but on the Custom Quotes tab, tick Replace for the types of quotes (single or double) you want to replace. You can also check that the replacement characters are correct (not easy to tell in the dialog, but clicking them shows the currently selected characters more clearly and allows you to change them). Have spent hours using Help to no effect. Please can someone help me? TM Steel Hope that helps, Mark. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens
Thanks! At last I understand. BUT the setting I am trying to return to ( have used in OOWriter for years) isA/no space/em dash/no space/B (which used to work simply by typing 2 hyphens). That seems to have been removed from the normal auto options. How can I recreate it? TS -Original Message- From: openoffice.mbou...@spamgourmet.com Sent: Saturday, January 28, 2012 3:12 PM To: users@openoffice.org Subject: [users] Re: hyphens The specific options I was referring to are those under the Tools menu AutoCorrect Options, which I described below. Apologies that wasn't clear. For the replace dashes option, make sure it's ticked under [T] and not just [M] - options under [T] affect text as you type, while those under [M] only have an effect when you use Format AutoCorrect Apply. If they're all set and it's still not working, perhaps you could show an example of what you're typing and expect to be changed? e.g. A - B (A space dash space B space) should replace the dash with an en-dash A-B (A dash B space) - note no spaces around the dash is not expected to change the dash, even with the options set Mark. thomas steel: FormatAutoCorrectWhileTyping is ticked, but it doesn't work. You advise that I 'Check that the specific options are set'. I suspect that the problem lies here. Can you tell me how to do that? I'd be so grateful. TS -Original Message- From: openoffice.mbou...@spamgourmet.com Sent: Saturday, January 28, 2012 11:36 AM To: users@openoffice.org Subject: [users] Re: hyphens apostrophes thomas steel: I am struggling to recustomise OOWriter for a new computer after burglary. Am trying (1) to enable replacement of some hyphens by em en dashes (used to work by hitting hyphen twice). As Anthony pointed out, make sure Format menu AutoCorrect While Typing is ticked (click the menu item to toggle it if not). If that doesn't work, check that the specific options are set... From the Tools menu AutoCorrect Options Options tab, tick the box in the [T] column next to Replace dashes. Clicking the Help button in that dialog gives a description of the options, including which combinations of dashes are replaced. Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. From the same dialog (Tools AutoCorrect Options), but on the Custom Quotes tab, tick Replace for the types of quotes (single or double) you want to replace. You can also check that the replacement characters are correct (not easy to tell in the dialog, but clicking them shows the currently selected characters more clearly and allows you to change them). Have spent hours using Help to no effect. Please can someone help me? TM Steel Hope that helps, Mark. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens
Hi Thomas, It appears that it only works when the two hyphens are preceded by a space. So you must type a space, the two hyphens then another space to get the em dash.. To get what you want, you'll the have to remove the extra spaces. I just did some experimenting and got the results below. I don't know i\f the formatting will survive the list, so I've described the results as well. A—B - typed A--Bspace result is A/no space/em dash/no space/B A – B - typed Aspace--spaceB result is A/space/en dash/space/B tc From: thomas steel t.st...@virgin.net To: users@openoffice.org Sent: Saturday, January 28, 2012 10:37:48 AM Subject: [users] Re: hyphens Thanks! At last I understand. BUT the setting I am trying to return to ( have used in OOWriter for years) isA/no space/em dash/no space/B (which used to work simply by typing 2 hyphens). That seems to have been removed from the normal auto options. How can I recreate it? TS -Original Message- From: openoffice.mbou...@spamgourmet.com Sent: Saturday, January 28, 2012 3:12 PM To: users@openoffice.org Subject: [users] Re: hyphens The specific options I was referring to are those under the Tools menu AutoCorrect Options, which I described below. Apologies that wasn't clear. For the replace dashes option, make sure it's ticked under [T] and not just [M] - options under [T] affect text as you type, while those under [M] only have an effect when you use Format AutoCorrect Apply. If they're all set and it's still not working, perhaps you could show an example of what you're typing and expect to be changed? e.g. A - B (A space dash space B space) should replace the dash with an en-dash A-B (A dash B space) - note no spaces around the dash is not expected to change the dash, even with the options set Mark. thomas steel: FormatAutoCorrectWhileTyping is ticked, but it doesn't work. You advise that I 'Check that the specific options are set'. I suspect that the problem lies here. Can you tell me how to do that? I'd be so grateful. TS -Original Message- From: openoffice.mbou...@spamgourmet.com Sent: Saturday, January 28, 2012 11:36 AM To: users@openoffice.org Subject: [users] Re: hyphens apostrophes thomas steel: I am struggling to recustomise OOWriter for a new computer after burglary. Am trying (1) to enable replacement of some hyphens by em en dashes (used to work by hitting hyphen twice). As Anthony pointed out, make sure Format menu AutoCorrect While Typing is ticked (click the menu item to toggle it if not). If that doesn't work, check that the specific options are set... From the Tools menu AutoCorrect Options Options tab, tick the box in the [T] column next to Replace dashes. Clicking the Help button in that dialog gives a description of the options, including which combinations of dashes are replaced. Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. From the same dialog (Tools AutoCorrect Options), but on the Custom Quotes tab, tick Replace for the types of quotes (single or double) you want to replace. You can also check that the replacement characters are correct (not easy to tell in the dialog, but clicking them shows the currently selected characters more clearly and allows you to change them). Have spent hours using Help to no effect. Please can someone help me? TM Steel Hope that helps, Mark. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Printer always selects PDF instead of Postscript
On Monday 23 January 2012 17:22:06 John Jason Jordan wrote: Twice I tried to send this to the new list, and both times it bounced. I give up on the new list. Libreoffice 3.4.4 on Fedora 16, x86_64. Printer: Laserjet 4M+ (Postscript Level 2) I used OOo for many years and never had this problem until I switched to Libreoffice. Whenever I print to this printer I must remember to go into Properties Options Device and change the print type from PDF to Postscript. If I do not the text will fail to be kerned according to the font metrics; that is, a proportional font will be spaced as though it was a monospace font. All other applications print fine. There is no setting for this in the driver, which uses a PPD file. I looked everywhere for a setting to set it to use Postscript as the default, but I can't find it. It is extra work to have to change this setting all the time. And usually I forget to change the setting and have to print the page again after I realize that I forgot. This is very annoying, and it wastes paper, toner and electricity. I really hope someone can tell me how to change the default behavior, else I will have to remove Libreoffice and reinstall OOo. You need to open a new blank document and go File Printer settings... Properties Device and select the desired Postscript settings click OK twice to save and clear the dialogs Go to File Templates Save... give your template a name and click OK to save Now you can use File New Templates and Documents to select your new template to create a document Alternatively, if as you suggest, you require this template to be default then go to File Templates Organise... select your template click the Commands drop down list and select Set As Default Template -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens apostrophes
On 1/27/2012 5:34 PM, thomas steel wrote: *From:* THOMAS STEEL mailto:t.st...@virgin.net *Sent:* Friday, January 27, 2012 9:44 AM *To:* users-h...@openoffice.org mailto:users-h...@openoffice.org *Subject:* hyphens apostrophes I am struggling to recustomise OOWriter for a new computer after burglary. Am trying (1) to enable replacement of some hyphens by em en dashes (used to work by hitting hyphen twice). Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. Have spent hours using Help to no effect. Please can someone help me? TM Steel Tom, Good to hear from you. Are you using OO.o or LibreOffice? I have LibreOffice, but I wind up inserting the em- and en- dashes by hand from the menu. You can assign key strokes to enter these using a macro. And OO.o used to replace two dashes (I insist they are minus signs) with an em-dash automatically if I pressed space after the next word, but that has stopped working. The OO.o code basd has been donated by Oracle (who bought Sun and Open Office .org) to the Apache foundation. I'll look for the address to subscribe to that mailing list as this one will go away in the not too distant future. I hope somone here will answer Tom's question in a more useful fashion and will find that address and post it before I do. With warmest regard David Teauge -- nil significat nisi oscillat -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens apostrophes
Hi Thomas, I have OOo 3.0 (build 9358) at home and 3.3 (build 9567) at work. In both, the first auto-correct item is em-dash for two hyphens. In order to have the substitution made as you type check Format - AutoFormat - While Typing. tc From: thomas steel t.st...@virgin.net To: users@openoffice.org Sent: Friday, January 27, 2012 5:34:16 PM Subject: [users] hyphens apostrophes From: THOMAS STEEL Sent: Friday, January 27, 2012 9:44 AM To: users-h...@openoffice.org Subject: hyphens apostrophes I am struggling to recustomise OOWriter for a new computer after burglary. Am trying (1) to enable replacement of some hyphens by em en dashes (used to work by hitting hyphen twice). Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. Have spent hours using Help to no effect. Please can someone help me? TM Steel -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: countif on multiple items
At 19:21 26/01/2012 -0600, Wade Smart wrote: I need a total based on two columns. For example: A1 = Black A3 = Dk Blue A9 = White C1 = x C3 = C9 = x If a1=Black AND c1 = x then count this as one. Can you count if with two columns? Yes: =SUMPRODUCT(A1:A99=Black;C1:C99=x) The conditions are either TRUE or FALSE. When interpreted as numbers, these values are 1 and 0 respectively. The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. The resulting true (=1) values are then summed. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: countif on multiple items
On Thu, Jan 26, 2012 at 20:07, Brian Barker b.m.bar...@btinternet.com wrote: At 19:21 26/01/2012 -0600, Wade Smart wrote: I need a total based on two columns. For example: A1 = Black A3 = Dk Blue A9 = White C1 = x C3 = C9 = x If a1=Black AND c1 = x then count this as one. Can you count if with two columns? Yes: =SUMPRODUCT(A1:A99=Black;C1:C99=x) The conditions are either TRUE or FALSE. When interpreted as numbers, these values are 1 and 0 respectively. The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. The resulting true (=1) values are then summed. I trust this helps. Brian Barker -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help Great! Thanks for that Brian :D -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Printer always selects PDF instead of Postscript
On Monday, January 23, 2012 05:22:06 PM John Jason Jordan wrote: Twice I tried to send this to the new list, and both times it bounced. I give up on the new list. Libreoffice 3.4.4 on Fedora 16, x86_64. Printer: Laserjet 4M+ (Postscript Level 2) I used OOo for many years and never had this problem until I switched to Libreoffice. Whenever I print to this printer I must remember to go into Properties Options Device and change the print type from PDF to Postscript. If I do not the text will fail to be kerned according to the font metrics; that is, a proportional font will be spaced as though it was a monospace font. All other applications print fine. There is no setting for this in the driver, which uses a PPD file. I looked everywhere for a setting to set it to use Postscript as the default, but I can't find it. It is extra work to have to change this setting all the time. And usually I forget to change the setting and have to print the page again after I realize that I forgot. This is very annoying, and it wastes paper, toner and electricity. I really hope someone can tell me how to change the default behavior, else I will have to remove Libreoffice and reinstall OOo. You may want to ask thsi on the LibreOffice list: us...@global.libreoffice.org I have a Xerox Phaser 6120 and it is also defaulting to pdf but I never have to change it to print from LibreOffice, and it is a postscript level 3 printer. Are you using CUPS for printing? I have used this printer since 2006 on various openSUSE releases with the original Xerox supplied ppd and/or one supplied from the openprinting.org. I am presenly on LibreOffice downloaded from there website. Version LibreOffice 3.4.5 OOO340m1 (Build:502) I have experienced no problem printing. I just printed a copy of this email in LibreOffice writer wit the setting at PDF, came out ok. What version of LibreOffice are you using? Do you have latest PPD file? -- Russ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Online updates
On Mon, Jan 23, 2012 at 04:20:14PM -0800, Dennis E. Hamilton wrote: What link do you mean? ooo-users-subscr...@incubator.apache.org is an e-mail address and I just tested it by successfully subscribing under one of my own addresses. ..snip That link is dead on the apache site. Sorry for not being clear. The link I was referring to is the link on the apache site pointing to mailing lists for openoffice. Not sure why I had such brain fade. Maybe I'm older than I thought. Apologies again. -- Bob Holtzman If you think you're getting free lunch, check the price of the beer. Key ID: 8D549279 signature.asc Description: Digital signature
[users] Re: Online updates
On 2012-01-24 1:37 PM Robert Holtzman wrote: Sorry for not being clear. The link I was referring to is the link on the apache site pointing to mailing lists for openoffice. Which page on the Apache site? The links to OOo mailing lists I have checked work. -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Online updates
Hello, Robert , and others -- Yes...the update service went kaput for the time being. Do, reconfig so OOo isn't checking for auto updates and jsut wait for a new release. This is one of the orphaned services that hasn't re-emerged. I'll bring it up again to see what we can do in the meantime. On Tue, Jan 24, 2012 at 11:37 AM, Robert Holtzman hol...@cox.net wrote: On Mon, Jan 23, 2012 at 04:20:14PM -0800, Dennis E. Hamilton wrote: What link do you mean? ooo-users-subscr...@incubator.apache.org is an e-mail address and I just tested it by successfully subscribing under one of my own addresses. ..snip That link is dead on the apache site. Sorry for not being clear. The link I was referring to is the link on the apache site pointing to mailing lists for openoffice. Not sure why I had such brain fade. Maybe I'm older than I thought. Apologies again. -- Bob Holtzman If you think you're getting free lunch, check the price of the beer. Key ID: 8D549279 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Online updates
On Sun, 2012-01-22 at 15:37 -0500, Michael McCracken wrote: Hello group, I have a similar problem about online updates that I saw is the users forum (list: org.openoffice.users) but I could not find an answer anywhere. Here is the problem: Could not establish network connection to update36.services.openoffice.org I am using: OpenOffice 3.3.0 : Windows 7 Ultimate w/SP1 : Firefox 9.0.1 :Avira Antivirus 10.2.0.704 :Intel Pentium 4, 3.0GHz CPU, 2.5GB RAM OpenOffice.org is allowed through Windows firewall Cannot locate ooupdater (if there is such a file in the directories) There is no selection within Avira to choose what programs are allowed, it appears to default to Windows firewall settings. Anyone have a suggestion on how to get this to work? Thanks, Mike Since Oracle gave OOo to Apache last year, there has not been a new version. Until that happens, there are no updates. Suggestion: turn the autoupdate off. (Tools Options OpenOffice.org Online Update.) Another point: Since Apache now has OOo, they have opened another mailing list of OOo. This new mailng list is much more active than this one has become. They will be closing down this mailing list in the future. To subscribe to the Apache mailin list for click the following link: ooo-users-subscr...@incubator.apache.org. It will create a new email with only an email address. Send it as it. Soon afterwards you will receive a confirmation email. When you get it, click Reply and send. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Online updates
On Mon, Jan 23, 2012 at 02:02:36PM -0500, Dan Lewis wrote: ..snip. Since Oracle gave OOo to Apache last year, there has not been a new version. Until that happens, there are no updates. Suggestion: turn the autoupdate off. (Tools Options OpenOffice.org Online Update.) Another point: Since Apache now has OOo, they have opened another mailing list of OOo. This new mailng list is much more active than this one has become. They will be closing down this mailing list in the future. To subscribe to the Apache mailin list for click the following link: ooo-users-subscr...@incubator.apache.org. It will create a new email with only an email address. Send it as it. Soon afterwards you will receive a confirmation email. When you get it, click Reply and send. That link is dead on the apache site. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- Bob Holtzman If you think you're getting free lunch, check the price of the beer. Key ID: 8D549279 signature.asc Description: Digital signature
[users] Re: Online updates
What link do you mean? ooo-users-subscr...@incubator.apache.org is an e-mail address and I just tested it by successfully subscribing under one of my own addresses. - Dennis -Original Message- From: Robert Holtzman [mailto:hol...@cox.net] Sent: Monday, January 23, 2012 13:33 To: users@openoffice.org Subject: [users] Re: Online updates On Mon, Jan 23, 2012 at 02:02:36PM -0500, Dan Lewis wrote: ..snip. Since Oracle gave OOo to Apache last year, there has not been a new version. Until that happens, there are no updates. Suggestion: turn the autoupdate off. (Tools Options OpenOffice.org Online Update.) Another point: Since Apache now has OOo, they have opened another mailing list of OOo. This new mailng list is much more active than this one has become. They will be closing down this mailing list in the future. To subscribe to the Apache mailin list for click the following link: ooo-users-subscr...@incubator.apache.org. It will create a new email with only an email address. Send it as it. Soon afterwards you will receive a confirmation email. When you get it, click Reply and send. That link is dead on the apache site. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- Bob Holtzman If you think you're getting free lunch, check the price of the beer. Key ID: 8D549279 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: CLI Interface Question
On 01/23/2012 06:37 PM, Mark LaPierre wrote: Hey Y'all, Is there any way to tell Oo how to open a file? when I open a .txt file with this command line: openoffice.org -writer -o ${JPATH}/${JFILE} I get an ASCII Filter Options dialog where I have to select my Char set, Defaut font, and Language. I don't need this dialog. I just want it to open my text document without arguing with me. Linux mushroom.patch 2.6.32-220.2.1.el6.i686 #1 SMP Thu Dec 22 18:50:52 GMT 2011 i686 i686 i386 GNU/Linux CentOS 6.2 Oo 3.2.1 On Fedora, I tried soffice -o foo.txt and it opened the file without asking me questions. How is your file encoded? Is it really straight ASCII? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Online updates
On Mon, 2012-01-23 at 16:20 -0800, Dennis E. Hamilton wrote: What link do you mean? ooo-users-subscr...@incubator.apache.org is an e-mail address and I just tested it by successfully subscribing under one of my own addresses. - Dennis I'm thinking the link meant is the link used when you go to Tools Options OpenOffice.org Online Update and click the Check Now button. When this is done, no connection is made. At the top of this page, there is a choice of how often to check for an updated version. It would attempt to make a connection to www.openoffice.org without any success. --Dan -Original Message- From: Robert Holtzman [mailto:hol...@cox.net] Sent: Monday, January 23, 2012 13:33 To: users@openoffice.org Subject: [users] Re: Online updates On Mon, Jan 23, 2012 at 02:02:36PM -0500, Dan Lewis wrote: ..snip. Since Oracle gave OOo to Apache last year, there has not been a new version. Until that happens, there are no updates. Suggestion: turn the autoupdate off. (Tools Options OpenOffice.org Online Update.) Another point: Since Apache now has OOo, they have opened another mailing list of OOo. This new mailng list is much more active than this one has become. They will be closing down this mailing list in the future. To subscribe to the Apache mailin list for click the following link: ooo-users-subscr...@incubator.apache.org. It will create a new email with only an email address. Send it as it. Soon afterwards you will receive a confirmation email. When you get it, click Reply and send. That link is dead on the apache site. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- Bob Holtzman If you think you're getting free lunch, check the price of the beer. Key ID: 8D549279 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Spreadsheet just continues to open columns
Take a look at the forums and these pages: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=47015 http://user.services.openoffice.org/en/forum/viewforum.php?f=9 Sometimes this problem may be related to automatic updating of cells on load of the document. There is some additional information that would help us narrow this down: 1. What is your computer operating system. 2. Which version of OpenOffice.org is giving you trouble with Calc opening. 3. Where did you obtain that version (download from where, on a CD from whom?) 4. What is the previous version, if any, that you had installed where Calc did operate properly. 5. Are you opening Calc with no spreadsheet or are you opening Calc with an existing document. 6. For an existing document, had you opened/created it successfully before? 7. Do you have macros enabled? 8. What other things have changed since it was working and now it isn't. Crashes. Unsuccessful close of a document, anything like that? - Dennis -Original Message- From: Wayne [mailto:wayne.labomb...@gmail.com] Sent: Saturday, January 21, 2012 09:27 To: users@openoffice.org Subject: [users] Spreadsheet just continues to open columns When I go into the spreadsheet program it opens and starts running as if a key is stuck opening columns and never stops. It does NOT happen in any other programs. Write works fine I've uninstalled and reinstalled with no luck it started about a week ago. Please help Wayne -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: How to make a base form editable
* Dan Lewis elderdanle...@gmail.com [120118 18:05]: There are two ways to do this. One is to create a new empty database. Then open the database with the dbf-derived table in it. Copy and paste this table into the empty database. When you do so, the Copy Table wizards. In the first page of the wizard make sure Definition and data is selected. Also check Create primary key. Suggested name for the primary key is ID. You can change this name if you want to do so. Then work your way through the wizard to create the dbf-derived table in this new database. (The directions on copying tables are found in the Getting Started with Base chapter of the Getting Started Guide.) Now you should have the table you want with a primary key. You will want to edit this table in Design View (also described in the above chapter). There set the AutoValue to Yes, save the table changes and close the dialog. Be absolutely certain to save the database after you save the table changes. Otherwise, the changes to the table will not written to the new database file! Thank you for these detailed instructions Dan. I really appreciate the time you have given me. regards -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: How to make a base form editable
On Tue, 2012-01-17 at 16:53 -0900, Tim Johnson wrote: Using open office 3.30 on Mac OSX 10.7 (Lion). I've imported a csv file into a Database. My intention is to create a form for both adding new records and editing existing ones. Try as I might, I keep ending up with what appears to be readonly. To create such a form, I use the wizard 1)Adding all fields with Field Selection 2)Pick an entry layout with Arrange Controls 3)From Set Data Entry choose The form is to display all data Making sure that none of the checkboxes below the control are **unchecked** But when the form is presented to me, I cannot enter or change any data! What else needs to be done? thanks -- Tim There are two types of data sources that Base accesses which are read only: text files, and spreadsheets. CSV is a text file format. To accomplish what you want, open the CSV file in Calc. Then use Save As to save the data in dBase format. First create a folder to hold the file. Now access the dBase file with Base. Create the form as you did before. You will be able to add, modify, or delete data in this form. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: How to make a base form editable
* Dan Lewis elderdanle...@gmail.com [120118 07:03]: On Tue, 2012-01-17 at 16:53 -0900, Tim Johnson wrote: There are two types of data sources that Base accesses which are read only: text files, and spreadsheets. CSV is a text file format. To accomplish what you want, open the CSV file in Calc. Then use Save As to save the data in dBase format. First create a folder to hold the file. Now access the dBase file with Base. Create the form as you did before. You will be able to add, modify, or delete data in this form. Thank you Dan. I found that I could paste directly in the Base pane for a new database. That got me working. I have tried your method and it works more simply. Is it possible to add a column to this new dbf-derived table? thanks again -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: How to make a base form editable
On Wed, 2012-01-18 at 11:46 -0900, Tim Johnson wrote: * Dan Lewis elderdanle...@gmail.com [120118 07:03]: On Tue, 2012-01-17 at 16:53 -0900, Tim Johnson wrote: There are two types of data sources that Base accesses which are read only: text files, and spreadsheets. CSV is a text file format. To accomplish what you want, open the CSV file in Calc. Then use Save As to save the data in dBase format. First create a folder to hold the file. Now access the dBase file with Base. Create the form as you did before. You will be able to add, modify, or delete data in this form. Thank you Dan. I found that I could paste directly in the Base pane for a new database. That got me working. I have tried your method and it works more simply. Is it possible to add a column to this new dbf-derived table? thanks again -- Tim Yes, you can add another column to the table. You can also create one or more tables with as many columns (fields) as you want. --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: How to make a base form editable
* Dan Lewis elderdanle...@gmail.com [120118 13:15]: On Wed, 2012-01-18 at 11:46 -0900, Tim Johnson wrote: * Dan Lewis elderdanle...@gmail.com [120118 07:03]: On Tue, 2012-01-17 at 16:53 -0900, Tim Johnson wrote: There are two types of data sources that Base accesses which are read only: text files, and spreadsheets. CSV is a text file format. To accomplish what you want, open the CSV file in Calc. Then use Save As to save the data in dBase format. First create a folder to hold the file. Now access the dBase file with Base. Create the form as you did before. You will be able to add, modify, or delete data in this form. Thank you Dan. I found that I could paste directly in the Base pane for a new database. That got me working. I have tried your method and it works more simply. Is it possible to add a column to this new dbf-derived table? thanks again -- Tim Yes, you can add another column to the table. You can also create one or more tables with as many columns (fields) as you want. Sorry Dan. I didn't ask that questions correctly. What I should have said How can I add a autoincrement primary key :) Right clicking on the table icon does show me the feature to add a 'row', but I don't see anything like an autoincrement datatype. And I'm not sure if I will need it in this case... but would be handy. -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: How to make a base form editable
On Wed, 2012-01-18 at 13:38 -0900, Tim Johnson wrote: * Dan Lewis elderdanle...@gmail.com [120118 13:15]: On Wed, 2012-01-18 at 11:46 -0900, Tim Johnson wrote: * Dan Lewis elderdanle...@gmail.com [120118 07:03]: On Tue, 2012-01-17 at 16:53 -0900, Tim Johnson wrote: There are two types of data sources that Base accesses which are read only: text files, and spreadsheets. CSV is a text file format. To accomplish what you want, open the CSV file in Calc. Then use Save As to save the data in dBase format. First create a folder to hold the file. Now access the dBase file with Base. Create the form as you did before. You will be able to add, modify, or delete data in this form. Thank you Dan. I found that I could paste directly in the Base pane for a new database. That got me working. I have tried your method and it works more simply. Is it possible to add a column to this new dbf-derived table? thanks again -- Tim Yes, you can add another column to the table. You can also create one or more tables with as many columns (fields) as you want. Sorry Dan. I didn't ask that questions correctly. What I should have said How can I add a autoincrement primary key :) Right clicking on the table icon does show me the feature to add a 'row', but I don't see anything like an autoincrement datatype. And I'm not sure if I will need it in this case... but would be handy. -- Tim There are two ways to do this. One is to create a new empty database. Then open the database with the dbf-derived table in it. Copy and paste this table into the empty database. When you do so, the Copy Table wizards. In the first page of the wizard make sure Definition and data is selected. Also check Create primary key. Suggested name for the primary key is ID. You can change this name if you want to do so. Then work your way through the wizard to create the dbf-derived table in this new database. (The directions on copying tables are found in the Getting Started with Base chapter of the Getting Started Guide.) Now you should have the table you want with a primary key. You will want to edit this table in Design View (also described in the above chapter). There set the AutoValue to Yes, save the table changes and close the dialog. Be absolutely certain to save the database after you save the table changes. Otherwise, the changes to the table will not written to the new database file! --Dan -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Openoffice has stopped working
Hi, Further to my last email - I checked the task manager, and Openoffice didn't feature in the Applications tab, though it did in the Processes tab - I stopped all the processes connected to openoffice, and then restarted the program, and now it's fine - do you have any idea what happened? William On 9 January 2012 12:40, William Wheeler wahwhee...@googlemail.com wrote: Hi, I've had openoffice on my computer for about 4 months (I have Windows 7). It's suddenly stopped opening - whether I click on the program, or try to open a file. Why is this happening and how can it be resolved? Cheers, William -- William Wheeler 18 Victoria Road London N4 3SQ 07903 089 324 -- William Wheeler 18 Victoria Road London N4 3SQ 07903 089 324 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Openoffice has stopped working
I have no idea. But it when something like that happens it it best to uninstall OO then install it again. I have both OO and Libre Office installed but I only use Libre Office - they are 99% the same but Libre seems a bit faster to me. Get the latest version from: http://www.openoffice.org/download/ http://www.libreoffice.org/ Good Luck On Mon, Jan 9, 2012 at 2:46 AM, William Wheeler wahwhee...@googlemail.comwrote: Hi, Further to my last email - I checked the task manager, and Openoffice didn't feature in the Applications tab, though it did in the Processes tab - I stopped all the processes connected to openoffice, and then restarted the program, and now it's fine - do you have any idea what happened? William On 9 January 2012 12:40, William Wheeler wahwhee...@googlemail.comwrote: Hi, I've had openoffice on my computer for about 4 months (I have Windows 7). It's suddenly stopped opening - whether I click on the program, or try to open a file. Why is this happening and how can it be resolved? Cheers, William -- William Wheeler 18 Victoria Road London N4 3SQ 07903 089 324 -- William Wheeler 18 Victoria Road London N4 3SQ 07903 089 324 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Question about closing a grey page
On 12/01/12 08:56, Steven Holbert wrote: I recently found a grey page on my desktop labelled Untitled 1 - OpenOffice.org Writer I can not discard or close it, and I have no idea how it opened on the computer in the first place. Efforts to find something in the help section are unsuccessful. Thank you. Seven Hoblert G'day Seven, Please advise your OS Do you know haw to open a command window? Regards Keith Bainbridge PO Box 324 BELMONT Vic 3216 Australia +61 (0)408 522 706 ke...@akrb.name -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: spam via kenai server
Mike Scott wrote: The question in my mind is, how come a spammer has got hold of my OOo-forum-specific email address? Your address is available to everyone who reads this list, whenever you post a message. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: spam via kenai server
On 13/01/12 15:40, James Knott wrote: Mike Scott wrote: The question in my mind is, how come a spammer has got hold of my OOo-forum-specific email address? Your address is available to everyone who reads this list, whenever you post a message. Please read posts first :-) I was talking about the address for registering on a forum - although probably I should have said bugzilla. I certainly didn't mention this list (for which one doesn't register anyway; one subscribes. Oddly, I use my normal address here.) So the problem remains - spam originating within openoffice. -- Mike Scott Harlow, Essex, England -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: spam via kenai server
Please forward a plaintext copy of the complete spam message with its headers to me, if you don't mind. Also, which OOo forum are you talking about? This: http://user.services.openoffice.org/en/forum/? - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: Mike Scott [mailto:m...@scottsonline.org.uk] Sent: Friday, January 13, 2012 07:26 To: users@openoffice.org Subject: [users] spam via kenai server Hmmm. I usually use unique email addresses when registering on websites and the like. I did this for the OOo forum. And guess what? spam email addressed to that address, sent via mailout01.kenai.com [192.9.171.172]. 'received' headers before the last are probably unreliable. The 'to' header suggests a number of others have had the same email (subject RE: Assessment Education). The question in my mind is, how come a spammer has got hold of my OOo-forum-specific email address? -- Mike Scott Harlow, Essex, England -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: deleting
same i just keep getting all this stuff and i dont know how to unsubscribe - Original Message - From: margaret.bea...@bigpond.com To: users@openoffice.org Sent: Wednesday, December 28, 2011 9:12 AM Subject: [users] deleting I have now subscribed to this email address, but am not sure what it entitles me to. I don't want to receive a lot of unwanted information. All I want is ocasional help with Open Office - eg. I want to know how to delete a document from File - can't find this anyway in Help or other instruction booklets.Thanking you, Margaret Beale-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: deleting
Try http://user.services.openoffice.org/en/forum/viewtopic.php?f=49t=46294p=214453hilit=unsubscribe#p214453 On 30 December 2011 13:36, Sheona Baldacchino slbaldacch...@bigpond.comwrote: ** same i just keep getting all this stuff and i dont know how to unsubscribe - Original Message - *From:* margaret.bea...@bigpond.com *To:* users@openoffice.org *Sent:* Wednesday, December 28, 2011 9:12 AM *Subject:* [users] deleting I have now subscribed to this email address, but am not sure what it entitles me to. I don't want to receive a lot of unwanted information. All I want is ocasional help with Open Office - eg. I want to know how to delete a document from File - can't find this anyway in Help or other instruction booklets.Thanking you, Margaret Beale -- * Ian D. Samson http://www.lp2cd.za.net/index.htm* -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: deleting
margaret.bea...@bigpond.com wrote: I have now subscribed to this email address, but am not sure what it entitles me to. I don't want to receive a lot of unwanted information. All I want is ocasional help with Open Office - eg. I want to know how to delete a document from File - can't find this anyway in Help or other instruction booklets.Thanking you, Margaret Beale You have subscribed to a mail list, where people discuss using OpenOffice.org. So, you will receive all the messages as long as you're subscribed. As for deleting a file within OOo, just use File Open and when you see the file you want to delete, just right click on it and select delete. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: deleting
Just highlight the one you want to delete then right click on it. A drop down will appear and just click on delete.t has always worked for me. OJ From: margaret.bea...@bigpond.com Sent: Tuesday, December 27, 2011 3:42 PM To: users@openoffice.org Subject: [users] deleting I have now subscribed to this email address, but am not sure what it entitles me to. I don't want to receive a lot of unwanted information. All I want is ocasional help with Open Office - eg. I want to know how to delete a document from File - can't find this anyway in Help or other instruction booklets.Thanking you, Margaret Beale-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: deleting
On 12/27/2011 05:42 PM, margaret.bea...@bigpond.com wrote: I have now subscribed to this email address, but am not sure what it entitles me to. I don't want to receive a lot of unwanted information. All I want is ocasional help with Open Office - eg. I want to know how to delete a document from File - can't find this anyway in Help or other instruction booklets.Thanking you, Margaret Beale Linux or Unix: open a terminal. cd/directory where the file is saved. Type rm filename (RTN) where filename is the complete name, with whatever extension you have used to save the file (.doc, .rtf, whatever). In Windows, just open the directory where the file is, highlight the file, right click, and select delete (RTN). Either way, the file will be gone. Actually, you should be able to do this in your GUI in Linux also--if you are using Dolphin, you should be able to use the Windows method. hth--doug -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: deleting
Hi Margaret, 1. If you would rather not receive mail except for topics that you have requested help for, you might find the OpenOffice Community Forums more to your liking: http://user.services.openoffice.org/en/forum/. 2. About deleting files. a. There is no direct way to delete already-saved files from the OpenOffice File menu. b. If you know where the file is stored, you can use your operating system to do it. c. If you are on Windows there are a couple of ways to accomplish this with the File menu too. (i) Use the File | Open ... dialog to navigate to folders and right click on the file you want to delete. Use the context menu to delete the selected file. Then cancel the Open operation. (ii) If you are not certain where a file is stored but you know of a recent file that is in the same place, use the File | Recent Documents ... dialog to open a file from the same location that you *don't* want to delete. Then select File } Save As ... and delete the same way as in (i). Then cancel the Save As ... operation. Your mileage will vary if you are running on a different operating system. Others here can help with that if you say what system you are running. - Dennis -Original Message- From: margaret.bea...@bigpond.com [mailto:margaret.bea...@bigpond.com] Sent: Tuesday, December 27, 2011 14:42 To: users@openoffice.org Subject: [users] deleting I have now subscribed to this email address, but am not sure what it entitles me to. I don't want to receive a lot of unwanted information. All I want is ocasional help with Open Office - eg. I want to know how to delete a document from File - can't find this anyway in Help or other instruction booklets.Thanking you, Margaret Beale -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: News about LibreOffice : 3.5.0, bug hunting and features
Hi, I must say that I don't like this kind of LO advertisement here, but anyway - there has been no update to OOo since almost 1 year, so what... It will take some time until a first Apache release of OOo will be available, so meanwhile, some people might want to get fixes for latest security issues - which have been integrated into LO. If you are only interested in security fixes (and some selected bug fixes), w/o having all the many different changes incorporated into LO, you might also want to give White Label Office a try. http://teamopenoffice.org/en/free-download.html?id=48:downloadmatrix-encatid=14:pages From what I understand, it's basically OOo 3.3 with some bug fixes, including the latest security fixes. Hey - also the colored document icons are back :) The name has changed to White Label Office because of trademark issues. Some information here: http://www.zdnet.de/news/41558995/release-candidate-von-openoffice-nachfolger-white-label-office-erschienen.htm Sorry, I didn't find a good English article yet. If you find some, feel free to post here :) Please keep in mind that the new place for OOo is with Apache: http://incubator.apache.org/openofficeorg/ And don't forget that you should already have been subscribed to the Apache Open Office lists, as the old lists are EOL: http://incubator.apache.org/openofficeorg/mailing-lists.html Best regards, Malte. On 23.12.2011 11:48, Cor Nouws wrote: Hi, I think it is good to send a little note here for those interested, but maybe not regularly see news about what is going on in LibreOffice. Currently we prepare version 3.5.0, already the third major version after the 'split-off' We will have a (hopefully) very big bug hunting session, next weeks Tuesday and Friday. Details are on the wiki: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 New features and enhancements will be tested. Information is here http://wiki.documentfoundation.org/ReleaseNotes/3.5 (not yet fully styled, worked out). Hope you like it. Kind regards, -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Now available: Apache OpenOffice Announcement List
On 2011-12-26 6:29 PM Rob Weir wrote: The Apache OpenOffice Project Management Committee is pleased to announce the availability of our new Announcement mailing list. Will this new list be available through Gmane? -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: News about LibreOffice : 3.5.0, bug hunting and features
Cor Nouws wrote (23-12-11 11:48) We will have a (hopefully) very big bug hunting session, next weeks Tuesday and Friday. Already confused now with all special day's and activities: it will be on Wednesday and Tuesday :-) Details are on the wiki: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 Ah, that is correct ;-) -- - Cor - http://nl.libreoffice.org -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Downloading extra copies
On 21/12/11 22:04, Tim Deaton wrote: *OpenOffice* (www.openoffice.org) and it's more-updated descendant *LibreOffice* (www.libreoffice.org) are both free software no matter how many copies you use. A little history might be in order: Sun Microsystems, which created *OpenOffice*, was bought by Oracle 2 years ago. Oracle had little use for *OpenOffice*, so most of those involved in its development created a new group (The Document Foundation) and used the then-current *OpenOffice* code as the starting point for *LibreOffice*. Since then, *LibreOffice* has continued to develop while *OpenOffice* has been in limbo. Oracle eventually gave the *OpenOffice* code and trademark to the Apache Foundation, which will probably resume development on *OpenOffice* in the near future. But as things stand now, *LibreOffice* is the more up-to-date product. A little more history: Star Division in Germany - Hamburg I believe - created Star Office; the company was subsequently bought by Sun who then made the code open source, leading to Open Office. Peter HB [cut] -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help