[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] Yahoo! Auto Response
Hi Jon will have limited Email access for next two weeks. Please try after that. -30- -- - 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 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!
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] Thank you very much!
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) -- - 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 <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: Windows 8
On Wed, Mar 14, 2012 at 1:03 PM, Bruce Martin 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 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
¡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] Windows 8
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: 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 >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] Information
Dear Mr./Ms., I need information about licensing OpenOffice. Can we use OpenOffice in a company legaly, or we need to buy license for it. I need this information fast. Thank you on understanding. ___ S poštovanjem / Best regards / Mit freundlichen Grüßen, Benjamin Kovačević, dipl. ing. informacionih 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 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] newer version of Open Office
Currently have an older version of Open Office 3.3 installed and have tried to install the latest version. After going thru all the preliminaries and starting the download to my computer ( Windows XP), I get a message that the older version cannot be removed and to contact OO tech support. What do I need to do?-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] document
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.-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Fw: newer version of Open Office
P.S. I have tried to remove the older version with the add-remove programs, but get a message "the featere you are trying to use is on a network resource that is unavailable" and then "Installation files cannot be found" - Original Message - From: Don Mincey To: Sent: Wednesday, March 07, 2012 9:22 AM Subject: newer version of Open Office Currently have an older version of Open Office 3.3 installed and have tried to install the latest version. After going thru all the preliminaries and starting the download to my computer ( Windows XP), I get a message that the older version cannot be removed and to contact OO tech support. What do I need to do?-- - 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] 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: us...@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 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] Please note: us...@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
[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] JAVA runtime problem
I have attempted to use the database on 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 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 - Java. I checked Java Preferences and it says the Java SE 6 is loaded but 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 to recognize the installed Java? David Shipley 719-646-5321 dd.ship...@comcast.net -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] how delete error report
After document recovery an error report appears on my screen. I can't remove it and can't see a send button on it. How do I delete it? Corrie -- - 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 - 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 _ 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] compatibility with AppleWorks
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 -- Prof Ray Morris 14 Pitcairn Ave Kidman Park SA 5025 08 8353 2746 -- - 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 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]
http://wordpress.dutimaju.com/wp-content/plugins/akismet/likeit.php?harder128.img-- - 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: 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 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] Problem with LIbreOffice Fields
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 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: Color of Help-file
2012/2/11 Hemmo Kranenborg > 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 *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] Color of Help-file
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 regardsir. H.J. KranenborgScholeksterlaan 1023645 KE VinkeveenThe NetherlandsPhone: (31)(0) 297 263323e-mail: h.j.kranenb...@casema.nl
[users] Re: Page Break Lines OOCalc
Hi Mark, Tools / option / calc / view. Uncheck 'Page Breaks' under 'Visual Aids'. tc > > From: Mark LaPierre >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: writer
2012/2/11 Vladimir Ivanov > > > > > > Оригинално писмо > >От: 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: 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: 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 >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
On Saturday, February 11, 2012 06:10:15 PM M Henri Day wrote: > 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.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
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
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.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: Digest for list us...@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 Ivanov 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] 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
[users] writer
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 ! -- - 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 Wed, Feb 08, 2012 at 01:26:45PM -0200, Sylvia S�nchez wrote: > > >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: 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: 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: 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] Help!!
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!!! WHYhelp me please!! THANKS A LOT! -- - 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?
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" 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]
-- - 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] Where Do Base Reports Store The Desired Query?
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! -- - 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] Data Base Litriture
Is there a book that I can purchase with instructions for using your data base? Brian Smith -- - 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 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] Page Headings - How?
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 Fuchs London, 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" > 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" > > 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: > > > > <http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports> > > More: > > <http://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=openoffice+%2Bbase+%2Bcalculations> > > and for dates, try: > > <http://www.google.com/search?sclient=psy-ab&hl=en&biw=1173&bih=675&source=hp&q=openoffice+%2Bbase+%2Bdate+%2Bcalculations&pbx=1&oq=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
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" 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" > 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: > > <http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports> > More: > <http://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=openoffice+%2Bbase+%2Bcalculations> > and for dates, try: > <http://www.google.com/search?sclient=psy-ab&hl=en&biw=1173&bih=675&source=hp&q=openoffice+%2Bbase+%2Bdate+%2Bcalculations&pbx=1&oq=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
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" > 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: > > <http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports> > More: > <http://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=openoffice+%2Bbase+%2Bcalculations> > and for dates, try: > <http://www.google.com/search?sclient=psy-ab&hl=en&biw=1173&bih=675&source=hp&q=openoffice+%2Bbase+%2Bdate+%2Bcalculations&pbx=1&oq=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: 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
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 Q&A, 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: 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" 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: <http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports> More: <http://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=openoffice+%2Bbase+%2Bcalculations> and for dates, try: <http://www.google.com/search?sclient=psy-ab&hl=en&biw=1173&bih=675&source=hp&q=openoffice+%2Bbase+%2Bdate+%2Bcalculations&pbx=1&oq=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
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: <http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports> More: <http://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=openoffice+%2Bbase+%2Bcalculations> and for dates, try: <http://www.google.com/search?sclient=psy-ab&hl=en&biw=1173&bih=675&source=hp&q=openoffice+%2Bbase+%2Bdate+%2Bcalculations&pbx=1&oq=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
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: 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] My database woes
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. -- - 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: 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] Consulta
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 gracias de antemando. Ximena. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] question
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 The universe is full of magical things patiently waiting for our wits to grow sharper-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Yahoo! Auto Response
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 -- - 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: 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 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
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 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: countif on multiple items
On Mon, Jan 30, 2012 at 03:35, Brian Barker 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: 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 Thu, Jan 26, 2012 at 20:11, 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 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
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--B result is "A/no space/em dash/no space/B" A – B - typed A--B result is "A/space/en dash/space/B" tc >____ > From: thomas steel >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) is"A/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: >> >> Format>AutoCorrect>WhileTyping 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: hyphens
Thanks! At last I understand. BUT the setting I am trying to return to (& have used in OOWriter for years) is"A/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: Format>AutoCorrect>WhileTyping 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
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: Format>AutoCorrect>WhileTyping 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
Format>AutoCorrect>WhileTyping 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: 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: 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] Freezing columns in Calc
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? -- - 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: 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 >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: 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] 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: Printer always selects "PDF" instead of Postscript
On Monday 23 January 2012 17:22:06 John Jason Jordan wrote: > 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] Yahoo! Auto Response
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 -- - 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 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: 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] countif on multiple items
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? 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: 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 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 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