[libreoffice-users] Re: a little math problem with Calc
Am 07.07.2012 00:37, alex sato wrote: Regina. I'm writing this email just to say thank you again. About the idea of rewriting math function using string. I may do it but just for fun, not for a serious use. ;-) Programming Basic is no fun. Never. Function Test (n) dim r(3) r(0)=CINT(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=CINT(r(2)) Test = r End Function -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] updated list of KPP English dictionaries for LO
I created a page for the KPP dictionaries, out of the NA-DVD folders. http://libreoffice-na.us/KPP-dictionaries/dictionary.html I have 3 updated dictionaries. The British dictionary now go to 639,116, the Canadian goes to 639,112. The American English one is now 773,407 words. All three dictionaries now include missing words, including open source and FOSS terms. The American English includes a lot more. In a bit, I will be updating the Extension Center with the new versions of the dictionaries. I have to decide how I am going to deal with the page[s] I have there first. I will not be updating the smaller word lists though. The new URL/page will, for now, list all of the KPP dictionaries, old and new. The current 3.5.x NA-DVD dictionary page reflects the updates and will not include the 638K versions, since the 639K version are the updates for the British and Canadian dictionaries. Next week, hopefully, 3.5.5 will be out and then I will create a 3.5.5 version ISO file to upload to the servers for downloading. That will be the one that will have the new dictionaries and the up-to-date documentation list. Impress has a full set of chapters for 3.5.x. Getting Started has Chapters 1-9 except 5 and 7 for 3.5.x. Draw has Chapters 1-3 for 3.5.x. I wish someone would help the documentation writers to get a set of chapters for BASE. There has been no additions since January, and that was a draft file. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macro code to highlight a field on a Form
Hi Andreas, Thanks very much for pointing me to the .setSelection(aSelection) method. I've experimented with it and I can get it to work sometimes but not others. (I think the problem lies within my Form. I have macros that fire when leaving certain fields and have the effect of moving the cursor elsewhere from where I am trying to be!) I'm away for the next week, so I have run out of time. But I'm confident that I'll now be able to sort it out when I return. Regarding the MRI extension, I take it that it is similar to the XRay extension. Is it worth loading both? They seem to do both similar and different things. Thanks again, Noel -- Marion Noel Lodge lodg...@gmail.com On 2 July Andreas Säger ville...@t-online.de viahttp://support.google.com/mail/bin/answer.py?hl=en-GBctx=mailanswer=1311182 global.libreoffice.org wrote: Hello, All you need is the MRI extension. http://extensions.libreoffice.org/extension-center/mri-uno-object-inspection-tool Within seconds it can point you to method http://www.openoffice.org/api/docs/common/ref/com/sun/star/awt/XTextComponent.html#setSelection The .setSelection(aSelection) method takes a struct specifying the start position and the end position of your text selection. MRI also generates snippets like this while using it: Sub Snippet(Optional oInitialTarget As Object) Dim oSource As Object Dim aSelection As New com.sun.star.awt.Selection oSource = oInitialTarget.Source aSelection = oSource.getSelection() End Sub [Tutorial] Introduction into object inspection with MRI http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=49294 Hope this helps, A.S. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] what a year and a day makes
I was looking in my ISO folder and I realized that yesterday was an anniversary. One year and one day ago, I created the first LibreOffice North American Community DVD .iso file. That was for LO 3.3.3. Today, I created an updated 3.5.4 .iso file for my use. Next week will be 3.5.5. One year of making and handing out NA-DVDs to the local community. I do not know how many 100's of DVD I have made in that year's time. I do not remember all the business, government offices, and individuals that I have given a copy of the DVDs to. LibreOffice has grown a lot since then. So has the NA-DVD. Much of the DVD has not changed much, except the theme, the extensions, templates, and other files that are listed in its pages. Old version have been updated, if available. New items added. My, KPP English dictionaries were developed for LO [and OOo/AOO]. And other thing, good and bad, has happened during this past year that has changed the project and myself. The LibreOffice project is coming up on its 2 year anniversary. During that time, OOo has been dropped my Oracle and picked up by Apache and renamed AOO. I started with LO back in its 3.3.0 beta days and dropped OOo then and there. I started working on the idea of a DVD to hand out to friends, family, and business people I knew when LO went to 3.3.1. Then that idea developed into the North American Community DVD Project. Back then, the hope was to put out an English version, A Spanish version, and a French version. Well, at least the English project went ahead. I do not speak or read any other human language. I can only deal with English [human] and programming languages [computer]. I hope that the next year will see a growth in the NA-DVD project and at least 10 times as many users using LibreOffice. Let us all make the next year be a great year for LibreOffice and all of the regional projects for marketing and distribution of LO to their users. Tim Lungstrom Elmira, New York, USA current developer and webmaster of the LO NA-DVD project webmas...@libreoffice-na.us [project email] webmas...@krackedpress.com [list email] . -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] what a year and a day makes
Hi :) +1 A good year on balance i hope :) Seems to have been mostly positive. Good work Tim and much appreciated. Regards from Tom :) --- On Sat, 7/7/12, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: From: webmaster-Kracked_P_P webmas...@krackedpress.com Subject: [libreoffice-users] what a year and a day makes To: LibreO - Users Global users@global.libreoffice.org Date: Saturday, 7 July, 2012, 14:01 I was looking in my ISO folder and I realized that yesterday was an anniversary. One year and one day ago, I created the first LibreOffice North American Community DVD .iso file. That was for LO 3.3.3. Today, I created an updated 3.5.4 .iso file for my use. Next week will be 3.5.5. One year of making and handing out NA-DVDs to the local community. I do not know how many 100's of DVD I have made in that year's time. I do not remember all the business, government offices, and individuals that I have given a copy of the DVDs to. LibreOffice has grown a lot since then. So has the NA-DVD. Much of the DVD has not changed much, except the theme, the extensions, templates, and other files that are listed in its pages. Old version have been updated, if available. New items added. My, KPP English dictionaries were developed for LO [and OOo/AOO]. And other thing, good and bad, has happened during this past year that has changed the project and myself. The LibreOffice project is coming up on its 2 year anniversary. During that time, OOo has been dropped my Oracle and picked up by Apache and renamed AOO. I started with LO back in its 3.3.0 beta days and dropped OOo then and there. I started working on the idea of a DVD to hand out to friends, family, and business people I knew when LO went to 3.3.1. Then that idea developed into the North American Community DVD Project. Back then, the hope was to put out an English version, A Spanish version, and a French version. Well, at least the English project went ahead. I do not speak or read any other human language. I can only deal with English [human] and programming languages [computer]. I hope that the next year will see a growth in the NA-DVD project and at least 10 times as many users using LibreOffice. Let us all make the next year be a great year for LibreOffice and all of the regional projects for marketing and distribution of LO to their users. Tim Lungstrom Elmira, New York, USA current developer and webmaster of the LO NA-DVD project webmas...@libreoffice-na.us [project email] webmas...@krackedpress.com [list email] . -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Macro code to highlight a field on a Form
Hi :) There is an excellent guide on writing Macros https://wiki.documentfoundation.org/Documentation/Publications#Programmers but getting personalised advice from an experienced expert such as Andreas is even better. Still it can be useful to have a guide too. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Macro-code-to-highlight-a-field-on-a-Form-tp3993100p3994218.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Hi :) Nicely done :) The subsequent link you gave was a link to the LO form to fill-in rather than to the specific bug-report you created. Ideally it would be great to have a link to the specific bug report in the one posted to the other project, eg In the MySql report a link given to the report submitted to LO In the LO report a link given to the MySql one. It helps if the devs can get their heads together more easily rather than just blaming the other project ;) I'm not sure devs do that but most people would in similar circumstances. Regards from Tom :) --- On Fri, 6/7/12, leeand00 leean...@gmail.com wrote: From: leeand00 leean...@gmail.com Subject: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter? To: users@global.libreoffice.org Date: Friday, 6 July, 2012, 2:41 Okay for anyone who's interested I submitted the bug here: http://bugs.mysql.com/bug.php?id=65832thanks=sub Enjoy! -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993950.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Specialty Dictionaries
Hi :) It sounds like interesting and useful functionality that might well be worth adding if it hasn't been done already. I think a lot of us here have been focussing on work-arounds to just get the job done. But i think it might be a good idea to post a bug-report and make it a Feature request. Regards from Tom :) --- On Fri, 6/7/12, Simon Cropper simoncrop...@fossworkflowguides.com wrote: From: Simon Cropper simoncrop...@fossworkflowguides.com Subject: Re: [libreoffice-users] Specialty Dictionaries To: users@global.libreoffice.org Date: Friday, 6 July, 2012, 1:19 On 06/07/12 05:26, nvrk wrote: On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper simoncrop...@fossworkflowguides.com wrote: Yeah, I have thought of both these things. Have hacked a standard file before, particularly in MS Word. Easily done assuming it is a text file and not a binary file. The problem is the binomial. I also thought of the concatenation string but most of the single characters have been used for have special meanings in various word processors. Hyphens for example are used in LO as hyphens and so how would you know when removing the character at the end of your report is complete, what is a concatenation character and what is a real hyphen? In other situations I have used =!= as a joining string but as stated it is messy and hard to read. An underscore works well. Yeap, but an underscore gets used a lot in technical reports (e.g. in a URL). If you do a global search and replace to remove the character at the end of writing so the report looks clean and well presented you neuter the URL or corrupt the other text string that uses it. As an alternative to free form typing of jargon or technical terms then running a spell checker, terms could be inserted from a list. This works OK but in the absence of LO integration you can't flag the inserted text as 'hey this is jargon, I just inserted it from a secure source, don't bother spell checking'. This can be done but requires you to manually apply language characteristics to hundreds or thousands of names, or alternatively hit ignore the same number of times with the spell checker. :( Ideally you need a blank concatenation character that is recognizing by LO as linking two words (such as a non-breaking space already available in LO but does not necessarily have to physically bind the words together but would need to be seen by the spell checker as a joining character) AND IS RECOGNIZED by the spell checker, substituted with something like an underscore and compared to the lists in the dic files which would appear as Eucalyptus_vulgaris. I just need someone in the know to be able to insert this functionality and these problems would be solved. -- Cheers Simon Simon Cropper - Open Content Creator Free and Open Source Software Workflow Guides Introduction http://www.fossworkflowguides.com GIS Packages http://www.fossworkflowguides.com/gis bash / Python http://www.fossworkflowguides.com/scripting -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???
Hi :) Ouch, i wish i had time and a stable enough internet connection to work on this. Is the document uploaded to Nabble or somewhere yet? Regards from Tom :) --- On Thu, 5/7/12, Rogier F. van Vlissingen vlisc...@gmail.com wrote: From: Rogier F. van Vlissingen vlisc...@gmail.com Subject: Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output??? To: users@global.libreoffice.org Date: Thursday, 5 July, 2012, 19:58 Hmm, disappointing though. I cannot see how these kinds of things can be avoided if you are editing a manuscript, and I never had such problems in the past with OO in 2002, with a book that certainly went through just as many revisions. I am clueless anymore how to fix it. If I fix one, another one pops up... On Thu, Jul 5, 2012 at 1:12 PM, Fernand Vanrie s...@pmgroup.be wrote: Rogier , Its not worth a issue, its user related due to serial direct formating, spaces folowd by spaces etc..When checking the underlying XML you can sea lots of unused tags and sometimes the PDF-creator is confused :-) The solution and the probable cause... In the end, this problem was fixable, by using 'clear direct formatting' in the areas affected. (Could not do whole doc lest we wipe out italics and such). The amazing fact was that the problem did not manifest in a PDF at the subdocument level, it just showed up in PDF output from the masterdoc. Very likely it was some kind of imperfection with the process of switching fonts somewhere in mid project. Unclear if it is substantial enough to rise to the level of a reportable issue. It probably is, but I would not know how to duplicate it. On Wed, Jul 4, 2012 at 3:37 AM, Fernand Vanrie s...@pmgroup.be wrote: Rogier , We produce about 8000 full color magazine pages a year using OO-LO on Windows, without any PDF anomalies - are you using Windows ? - what Fonts ? you can also send some problematic pages to my personal emailadress Groeten Fernand Back in 2002 I produced a book, going straight to print off a Open Office PDF, and the results were thoroughly satisfactory. In fact, my book at that time was probably the first production book that was fully produced straight from OO, skipping DTP altogether. Today, 10 years later I'm doing a tentative layout for a book in Libre Office, though this time without the intention of going to print from the PDF, but I'm finding out I could not do it if I wanted to for there are some unpredictable anomalies happening in the PDF in LIbre Office. (I have not tried OO yet. Today I would probably use Scribus or Adobe Indesign to prepare a proper print layout.) What is happening is that there are completely unpredictable irregularities in the LO PDF output for which I cannot find any evident cause. - There is irregular line spacing happening in the PDF output for reasons that are entirely unclear in the original. - In some cases opening smart quotes seem to display at a point size about 5 times the size of the text in the PDF (not in the actual document files), which at least provides a visual clue for the irregular line spacing. Does anyone have similar experience, and has anyone perhaps found a workaround, or is this an issue. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** ** org users%2Bhelp@global.**libreoffice.orgusers%252bh...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-* *** http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.**libreoffice.org/get-help/** mailing-lists/how-to-**unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundati**on.org/**http://documentfoundation.org/** Netiquette http://wiki.**documentfoundation.org/**Netiquettehttp://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoff**ice.org/global/users/http://libreoffice.org/global/users/ http://**listarchives.libreoffice.org/**global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Rogier F. van Vlissingen, NY (917) 549 0959 * http://viz.me/vliscony* *www.acimnthomas.com
Re: [libreoffice-users] Specialty Dictionaries
I wonder how hard it would be, or how confusing it would be to make a 2 word reference in the word list file. If the space appears blank, then what would happen if there was some other blank character that looked like the space character. I think the originally defined system came from some other organization, like Hunspell or Myspell. It may take a lot of work, and make all of the current .oxt dictionaries need to be re-done if there was a new formatting system that allowed a 2 word listing. My question is why would one be needed? It the only reason for it is one combination of terms is valid, while a different ending term is not? That would make some real context oriented spelling and worse that figuring out grammar issues. You will need to have defines all the possible two word term combinations instead of having each single word/term checked for proper spelling. The more I think about it, the more I want to cringe over what might be needed to get it working fully and not mess with defined characters for non-English fonts or other issues for taking over a pre-defined character for some internal function, when that character may be mapped for a glyph/letter for some font used by some user. Then that user[s] would have their document messed up in some way. Still, if someone can figure out all the issues and work out a way that they will not cause a set of users problems down the line, then by all means create a request for a modification of the spell checker system. I really doubt that it will be changed form the current system, but you can try. On 07/07/2012 06:22 PM, Tom Davies wrote: Hi :) It sounds like interesting and useful functionality that might well be worth adding if it hasn't been done already. I think a lot of us here have been focussing on work-arounds to just get the job done. But i think it might be a good idea to post a bug-report and make it a Feature request. Regards from Tom :) --- On Fri, 6/7/12, Simon Cropper simoncrop...@fossworkflowguides.com wrote: From: Simon Cropper simoncrop...@fossworkflowguides.com Subject: Re: [libreoffice-users] Specialty Dictionaries To: users@global.libreoffice.org Date: Friday, 6 July, 2012, 1:19 On 06/07/12 05:26, nvrk wrote: On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper simoncrop...@fossworkflowguides.com wrote: Yeah, I have thought of both these things. Have hacked a standard file before, particularly in MS Word. Easily done assuming it is a text file and not a binary file. The problem is the binomial. I also thought of the concatenation string but most of the single characters have been used for have special meanings in various word processors. Hyphens for example are used in LO as hyphens and so how would you know when removing the character at the end of your report is complete, what is a concatenation character and what is a real hyphen? In other situations I have used =!= as a joining string but as stated it is messy and hard to read. An underscore works well. Yeap, but an underscore gets used a lot in technical reports (e.g. in a URL). If you do a global search and replace to remove the character at the end of writing so the report looks clean and well presented you neuter the URL or corrupt the other text string that uses it. As an alternative to free form typing of jargon or technical terms then running a spell checker, terms could be inserted from a list. This works OK but in the absence of LO integration you can't flag the inserted text as 'hey this is jargon, I just inserted it from a secure source, don't bother spell checking'. This can be done but requires you to manually apply language characteristics to hundreds or thousands of names, or alternatively hit ignore the same number of times with the spell checker. :( Ideally you need a blank concatenation character that is recognizing by LO as linking two words (such as a non-breaking space already available in LO but does not necessarily have to physically bind the words together but would need to be seen by the spell checker as a joining character) AND IS RECOGNIZED by the spell checker, substituted with something like an underscore and compared to the lists in the dic files which would appear as Eucalyptus_vulgaris. I just need someone in the know to be able to insert this functionality and these problems would be solved. -- Cheers Simon Simon Cropper - Open Content Creator Free and Open Source Software Workflow Guides Introduction http://www.fossworkflowguides.com GIS Packages http://www.fossworkflowguides.com/gis bash / Pythonhttp://www.fossworkflowguides.com/scripting -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:
Re: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc
i :) I think one advantage of wiki's is that they are easy for anyone to update anytime. Hopefully information from that gets fed into blogs and official documentation and maybe even the help files. Star Trek computers can do pretty much anything by just asking it to do whatever and people seem to expect their machines to be able to do the same. The physics in most sci-fi has been referred to a Want'em Physics I really liked Ken's remarks and agree that the average skill level does appear to have dropped or even plummeted. People are expected to just instantly understand some very complex ideas with no training. Regards from Tom :) --- On Thu, 5/7/12, Ken Springer snowsh...@q.com wrote: From: Ken Springer snowsh...@q.com Subject: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc To: users@global.libreoffice.org Date: Thursday, 5 July, 2012, 14:43 On 7/5/12 2:41 AM, Andreas Säger wrote: snip All this had been written hundreds of times for dozends of spreadsheets applications in books, web-pages, mailing lists and forums. People don't read this. I know, but I have a hard time blaming X percent of them. I run into many users who have no clue such information even exists or go about finding it. They aren't into computers enough to search the web (occasionally they still have dial-up) as computers aren't major parts of their life, and library access can be minimal. And no clue that all of the spreadsheets are very similar. You can make that argument for lots of things. There's hundreds of books on automotive electrical systems, but you still have people wanting a Ford manual to get specific information, for example. I would be willing to bet the computer skills of the average computer user 30 years ago was higher than it is today. They want to have it explained for the exact problem they struggle with *right now* without ever telling any details about their problem. People want computers they can talk to and the machine resolves all the contradictions, completes missing information before it spills out the correct solution. Since today's machines fail at fuzzy logic, they try to find some human to resolve and complete All of this I attribute to the instant gratification we get today with computers and related electronics. Want a book? Download it to an ereader, who has to wait for it to be shipped to you? No need to go to the store and look for something, buy it online. Etc., etc., etc. or even better: write a macro program so a single click substitutes 5 clicks. When I was using my Atari 16/32 bit machines with Neodesk, I had macros for desktop operations all the time, for the very reason you mentioned. These were actions I repeated often. Now, most of those reasons I used macros for are part of the OS and/or software. And I don't do enough repetitive stuff to actually get much value from a macro recorder. I think a certain percentage are too lazy to learn how to do it, and another percentage don't know what a macro is. :-( Rather than write a macro program, I'd download an open source or free one. :-) No offense intended, but to me to suggest writing a macro program, unless you have a very special need, is like reinventing the wheel. :-) IF function with example: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_IF_function Maybe a lot of these types of links could be incorporated into LO's Help pages and/or on a free disk image you can download. Perhaps Webmaster Krackedpress ND DVD too. I don't know what's on that disk. Wiki pages tend to baffle me, I just can never discover any structure like a newsgroup that makes sense to me. And the wasted space. :-( And they are never as efficient in use as a well designed book with a well designed index. -- Ken Mac OS X 10.6.8 Firefox 13.0.1 Thunderbird 13.0.1 LibreOffice 3.5.2.2 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted