Re: [users] Calc AVERAGE function faulty
At 10:08 13/01/2009 +0200, Hylton Conacher wrote: I have merged a few cells and entered a SUM formula in there to provide a numerical result. I have a column next to that that takes the AVERAGE of all the merged cells and represents it as a single number. I recently added a 10th merged cell to the AVERAGE formula and the result came back that it cannot divide by zero, however the result is far far away from zero if I calculate manually. The result of the average is not particularly relevant, of course. The AVERAGE() function would not be trying to divide anything by this final result. Instead, AVERAGE() needs to divide by the number of elements it is given, of course, so the obvious possibility is that you are asking it to average a set with no elements. If you give the AVERAGE() function a set of cells that contain nothing numerical, it will count the number of values as zero and divide the (zero) sum by that zero to get its result - with exactly the effect you describe. Its not clear what you are merging here, but my guess is that you have merged a number of cells that previously contained numerical values. There are two alternatives when you do this: did you leave the values in the hidden cells or did you allow the merge to move them into the visible, merged cell? If the latter, what you now have is not any numbers but a text item, formed by concatenating the former numerical values with intervening spaces. An attempt to average this will find no values and certainly give you a #DIV/0! error. It would be nice to know that the functions included in Calc actually work though, without having to know a long work around. It may still be that AVERAGE() is doing the right thing with what you have given it ... I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] problems with time operations on OOcalc 3
Hi all. I'm new in this list. I use OOcalc 3 and I don't know how make this operation with hours: one cell have 1650:00:00 other cell (C1 for example )is =sum (a1:a5) with this result 168:45:00 If I write other cell with = 1650 - C1 I obtain 39431:45:00. Cell has time format If I write other cell with = 1650:00:00 - C1 I obtain Err:502. What I do wrong? Please any help... Thanks Chena - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] File type window does not show on installation of OO3
I have used Open Office for a number of years now and since upgrading to 3.0 recently, find all my files saved with a .doc extension are no longer opened by OO automatically, as used to be the case. I have looked at the help pages and it seems that the Setup Type window that I have used to set the default during installation up to now, should be in this version but appears to be missing. Is there something wrong with my installation or is this a bug? Many thanks. Rick Johnson
[users] Registration
I went to register for the open open office and I fat fingered the email address. So, as a result I did not get the password. When I tried to register again, it said that the username was already registered. How do I correct the email address with the username I used. -- Jack Kepple jkepp...@gmail.com 571-213-5956
[users] Open Office - download failure
11th January 2009. 20.51hrs. I have been trying for the last few hours, in vain, to download Open Office, so that I can use Java. Please advise. Thanks. Sheila De Ciantis
[users] Accountant Payable and Receivable
Hi, Please be send me work sheet relevant to accountant payable and receivables Expenses reports, Revenue reports and Cash fund logs Thanking you ! Regards Gamini Get your preferred Email name! Now you can @ymail.com and @rocketmail.com. http://mail.promotions.yahoo.com/newdomains/aa/
[users] spellchecking
i have tried everything but my spellchecker does not work .gone into tools-spell grammar options wont let me tick anythingi if i go into spellcheck it sayes spellcheck is complete but nothing is happening .and i know i have made mistakes. help.. andrea
[users] [moderated]
I purchased Open Office online, but when I attempted to download, I received the message that it was an Illegal Operation, and the download did not occur. Please advise. Marsha Springs mspri...@mindspring.com EarthLink Revolves Around You.
RE: [users] font size
Sarah, Google 'OoO Line spacing' Shawn Sarah Wrote: Now.I have another frustrating problem which I'm sure someone can help me to solve. There again, in working on a document I have inadvertantly done something that caused the line spacing to jump from single to 1 1/2 spacing. I haven't found out how to change it back. Can you give me a solution? Thanks again. Sarah - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] From Julien Machot - Merge
Hi there, a little problem with OpenOffice mail merge in the Writer. I have always been successful using the mail merge before to print out invitations. But today, for some strange reasons I am stuck. I created a document (a standard invitation letter with only text) and I have an excel spreadsheet with 62 addresses of my contacts. I start the mail merge and everything seems alright, I match fields, and here it goes well but when I want to click continue or next, the button is not in clickable. What am I doing wrong? Best regards, Julien Machot, MSc, MA MBA Center Frankfurt Stiftstraße 14 60313 Frankfurt am Main T: +49 (0) 69 9864 6230 M: +49 (0)151 2096 6119 Fax: +49 (0)69 291 055 E-mail: frankf...@mba-center.net Website: www.mba-center.net MBA Center Group on Xing: www.xing.com/net/mbacenter Linkedin Profile: www.linkedin.com/in/jmachot - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] [moderated]
paid an downloaded open office. i have vista home premium, i am sure ur add said vista was ok, but the files/ read me doc,t say up to xp only, please help, did i download the wrong item, stuart. very urgent
[users] Installing 3.0
Hi, I just installed 3.0 and have two observations: 1) It did NOT install in the folder I specified. It put the entire installation into C:\ProgramFiles. It DID put the decompressed files in the folder I specified but did not allow me to tell it where to put the actual installation. 2) It did not create a desktop icon as requested. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] OOo2 OOo3 preferences error?
Hello Folks I've just moved from OOo2 OOo3. I simply moved my personal preference files under ~/.openoffice.org2.0/ to ~/.openoffice.org/3/ . Every thing seems to work fine - except I get 2 error windows when I start OOo fresh. Screen shots of the error windows are attached, but the list probably wont carry them so their text is: 1 Error loading BASIC of document file:///usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/script.xlb/: General Error. General input/output error. [OK] 2 Error loading BASIC of document file:///usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/dialog.xlb/: General Error. General input/output error. [OK] The location /usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/ no longer exists, so those files can't be the problem, so there must be something pointing to them in my user preferences (~/.openoffice.org/3/). Does anybody have any idea what? Also, does anyone know of a little howto anywhere of what exactly to prune edit moving OOo2 preferences to OOo3? Thanks all, Morgan. -- Getting errors: There are problems with the signature (or similar)? Update your system by installing certificates from CAcert Inc, see here: http://wiki.cacert.org/wiki/BrowserClients?#head-259758ec5ba51c5205cfb179cf60e0b54d9e378b Or, if Internet Explorer is your default browser, simply click this link: http://www.cacert.org/index.php?id=17 Morgan Read NEW ZEALAND mailto:mstuffATreadDOTorgDOTnz fedora + freedom; fact || fiction? http://fedoraproject.org/wiki/Overview get freed-ora! http://www.fsfla.org/svnwiki/selibre/linux-libre/freed-ora - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] OOo2 OOo3 user preferences error?
Hello Folks I've just moved from OOo2 OOo3. I simply moved my personal preference files under ~/.openoffice.org2.0/ to ~/.openoffice.org/3/ . Every thing seems to work fine - except I get 2 error windows when I start OOo fresh. Screen shots of the error windows are attached, but the list probably wont carry them so their text is: 1 Error loading BASIC of document file:///usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/script.xlb/: General Error. General input/output error. [OK] 2 Error loading BASIC of document file:///usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/dialog.xlb/: General Error. General input/output error. [OK] The location /usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/ no longer exists, so those files can't be the problem, so there must be something pointing to them in my user preferences (~/.openoffice.org/3/). Does anybody have any idea what? Also, does anyone know of a little howto anywhere of what exactly to prune edit moving OOo2 preferences to OOo3? Thanks all, Morgan. -- Getting errors: There are problems with the signature (or similar)? Update your system by installing certificates from CAcert Inc, see here: http://wiki.cacert.org/wiki/BrowserClients?#head-259758ec5ba51c5205cfb179cf60e0b54d9e378b Or, if Internet Explorer is your default browser, simply click this link: http://www.cacert.org/index.php?id=17 Morgan Read NEW ZEALAND mailto:mstuffATreadDOTorgDOTnz fedora + freedom; fact || fiction? http://fedoraproject.org/wiki/Overview get freed-ora! http://www.fsfla.org/svnwiki/selibre/linux-libre/freed-ora smime.p7s Description: S/MIME Cryptographic Signature
Re: [users] Suppressing zeros in cells containing a formula
Harold, thank you for replying to your own post! It did the trick... almost. I wanted to force the display of zeros to the right of the decimal if the amount was 1.00, so I changed the #'s to the right of the decimal in the expression you gave me to #.00 and it worked. Thanks again! Stan - Original Message - From: Harold Fuchs To: users@openoffice.org Cc: stanc...@gmail.com Sent: Sunday, January 11, 2009 5:20 AM Subject: Re: [users] Suppressing zeros in cells containing a formula On 11/01/2009 02:33, Stan Labinsky Jr. wrote: Hello all; Using Writer 3.0, how can I suppress the display of a zero value in a cell containing the product (or sum) of a group of other cells? Sorry to reply to my own post but ... Better: In the number formatting pane choose User Defined and enter [0]#.##;[=0] into the Format Code box. This is conditional formatting. It's in two parts separated by semi-colon. The first part says #.## if the number is not zero. The second part says (4 spaces) if the number is zero. For more details read up on Conditional Formatting in the Help. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
Re: [users] [moderated]
2009/1/13 STUART MACKENZIE mackenzie...@btinternet.com paid an downloaded open office. i have vista home premium, i am sure ur add said vista was ok, but the files/ read me doc,t say up to xp only, please help, did i download the wrong item, stuart. very urgent I am not sure why or who you paid for OpenOffice. You don't need to pay to download or use the software; it's completely free from www.openoffice.org. Support and documentation are also free. There are organisations that sell OpenOffice on CD for a small amount. This provides a useful service to those who have slow/expensive/unreliable internet connections. There are other organisations that sell either modified/enhanced versions of OpenOffice or the standard version but with extra services such as training and/or installation support. This may or may not be of value to you. Unfortunately there is a third class of organisation that sells the standard software and relies on the customer not realising that it can be had for free. Under the terms of the licence this is legal ... If you have bought from such an organisation I'm afraid we can't help you. You must take the matter up with the vendor. If you paid by credit card then, depending on the consumer protection laws in you country, you may be able to get your money back. To reiterate, you can download OpenOffice for free from www.openoffice.org. The Windows version works on Vista. Click the Download *tab* (top right) and then click on System Requirements in the column of links on the right of the page that opens. You will also find a link to detailed installation instructions in that same column. OpenOffice.org is free to use on as many computers as you like in any context you like - business, personal, education, ... Documentation is free on the we (same column of links). Support is free via this mail list run by users who volunteer time to help others. There are also other forums and groups who provide free support. A list is available from that same column of links. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
Re: [users] Open Office - download failure
Sheila De Ciantis wrote: 11th January 2009. 20.51hrs. I have been trying for the last few hours, in vain, to download Open Office, so that I can use Java. Please advise. Please describe what's happening, when you try to download. Also, are you on a broadband or dial up modem internet connection? BTW, you don't have to download OpenOffice.org, if all you want is Java. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [moderated]
Marsha Springs wrote: I purchased Open Office online, but when I attempted to download, I received the message that it was an Illegal Operation, and the download did not occur. Please advise. OpenOffice.org is a free download from www.openoffice.org. There is no charge for it. That site where you paid for it is run by someone who charges for something that you can obtain for free. You'll have to contact them or failing that, get the credit card charge reversed. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [moderated]
STUART MACKENZIE wrote: paid an downloaded open office. i have vista home premium, i am sure ur add said vista was ok, but the files/ read me doc,t say up to xp only, please help, did i download the wrong item, stuart. very urgent 1) The last few versions of OpenOffice.org have been optimized for Vista and I have installed it on Vista a couple of times. 2) OpenOffice.org is a free download from www.openoffice.org. You did not have to pay anyone for it. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] problems with time operations on OOcalc 3
At 10:30 14/01/2009 +0100, Chema wrote: I use OOcalc 3 and I don't know how make this operation with hours: one cell have 1650:00:00 other cell (C1 for example )is =sum (a1:a5) with this result 168:45:00 If I write other cell with = 1650 - C1 I obtain 39431:45:00. Cell has time format If I write other cell with = 1650:00:00 - C1 I obtain Err:502. What I do wrong? When you type something like 1650:00:00 into a cell, it is interpreted and shown as a time. But the cell does not really have in it what you see: it has the time expressed as a number of days and it is the cell formatting - as Time - that cause the display to appear as it does. Your problem is that without the colons, your 1650 is interpreted as days, not hours. And the format of three numbers separated by colons is not recognised as a time in a formula. You can see this by using the formula =68.75-C1 instead, which will work. The 68.75 here is your 1650 hours expressed as a number of days. But that is messy. Better, if you want to put a fixed time into a formula, you can do this in two easy ways, either: =TIME(1650;0;0)-C1 where the parameters are the separate numbers of hours, minutes, and seconds, or: =TIMEVALUE(1650:00:00)-C1 where the single parameter is a text string in the same format in which you would enter it into a cell. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] font size
Shawn Taylor wrote: Sarah, Google 'OoO Line spacing' Shawn Sarah Wrote: Now.I have another frustrating problem which I'm sure someone can help me to solve. There again, in working on a document I have inadvertantly done something that caused the line spacing to jump from single to 1 1/2 spacing. I haven't found out how to change it back. Can you give me a solution? Thanks again. Press the F1 key to open Help and search on line spacing for the information you want. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] English Interface
Dear Sir, i have just installed the open office arabic edition, but i need it with English menus, and when i go to language settings i do not find english in the interface language list. how can i add this. thanks _ Windows Live™ Hotmail®: Chat. Store. Share. Do more with mail. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_hm_justgotbetter_explore_012009
Re: [users] spellchecking
2009/1/12 andrea ruming ah_rum...@bigpond.com i have tried everything but my spellchecker does not work .gone into tools-spell grammar options wont let me tick anythingi if i go into spellcheck it sayes spellcheck is complete but nothing is happening .and i know i have made mistakes. help.. andrea Hello Andrea Language in OpenOffice.org is an attribute of the character/letter, and you would typically include it in a Paragraph style (see first icon on Format toolbar, and droplist next to it / or click F11) • Take a look at Format Character Font type Western text Language. You should find a list of languages there - some have an ABC-V sign in front of them, which means that the spellcheck dictionary is installed for this language (you may find English-US, English-UK etc.) • You choose the language you'll use most of the time in Tools Options Language settings Languages Default language Western. Again, you'll see (or not) the ABC-V sign next to the dictionaries that are installed. You can also choose Asiatic and Complex scripts, and determine a default language in these scripts. • If you have the Status bar active (bottom of OOo window), you'll see in the third rectangle the language of the paragraph the cursur is in. • If dictionaries you need aren't installed yet, you can do this in the following way: - in OOo up to version 2.4.2 with the Dictionary Wizard (File Wizard or Assistant Install dictionary from the Web) - from OOo 3.0.0 onwards, dictionaries come as extensions, and you can find them at http://extensions.services.openoffice.org/dictionary HTH -- Guy using dutch OOo Aqua 3.0.1 on a iMac Intel DualCore Leopard and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches
[users] Re: English Interface
George Awad wrote: i have just installed the open office arabic edition, but i need it with English menus, and when i go to language settings i do not find english in the interface language list. how can i add this. You will have to install the English version to get English menus. Note that you will be able to type in Arabic just as well in the English version as in the Arabic version. Just be sure to go into Tools → Options... → Language Settings → Languages and click on the box marked as “Enabled for complex text layout (CTL)” so that it is checked. Also set CTL under “Default languages for documents” to the form of Arabic you wish to use. You may also want to make some changes under “Language of”. As you appear not to be subscribed to this forum, I am sending a copy of my response to you directly. If you have any further questions or comments, please send them directly to users@openoffice.org, not to my own email address. Jim Allan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] problems with time operations on OOcalc 3
Brian Barker escribió: At 10:30 14/01/2009 +0100, Chema wrote: I use OOcalc 3 and I don't know how make this operation with hours: one cell have 1650:00:00 other cell (C1 for example )is =sum (a1:a5) with this result 168:45:00 If I write other cell with = 1650 - C1 I obtain 39431:45:00. Cell has time format If I write other cell with = 1650:00:00 - C1 I obtain Err:502. What I do wrong? When you type something like 1650:00:00 into a cell, it is interpreted and shown as a time. But the cell does not really have in it what you see: it has the time expressed as a number of days and it is the cell formatting - as Time - that cause the display to appear as it does. Your problem is that without the colons, your 1650 is interpreted as days, not hours. And the format of three numbers separated by colons is not recognised as a time in a formula. You can see this by using the formula =68.75-C1 instead, which will work. The 68.75 here is your 1650 hours expressed as a number of days. But that is messy. Better, if you want to put a fixed time into a formula, you can do this in two easy ways, either: =TIME(1650;0;0)-C1 where the parameters are the separate numbers of hours, minutes, and seconds, or: =TIMEVALUE(1650:00:00)-C1 where the single parameter is a text string in the same format in which you would enter it into a cell. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Thanks,really it's works Regards Chema - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] problems with time operations on OOcalc 3
Brian Barker escribió: At 10:30 14/01/2009 +0100, Chema wrote: I use OOcalc 3 and I don't know how make this operation with hours: one cell have 1650:00:00 other cell (C1 for example )is =sum (a1:a5) with this result 168:45:00 If I write other cell with = 1650 - C1 I obtain 39431:45:00. Cell has time format If I write other cell with = 1650:00:00 - C1 I obtain Err:502. What I do wrong? When you type something like 1650:00:00 into a cell, it is interpreted and shown as a time. But the cell does not really have in it what you see: it has the time expressed as a number of days and it is the cell formatting - as Time - that cause the display to appear as it does. Your problem is that without the colons, your 1650 is interpreted as days, not hours. And the format of three numbers separated by colons is not recognised as a time in a formula. You can see this by using the formula =68.75-C1 instead, which will work. The 68.75 here is your 1650 hours expressed as a number of days. But that is messy. Better, if you want to put a fixed time into a formula, you can do this in two easy ways, either: =TIME(1650;0;0)-C1 where the parameters are the separate numbers of hours, minutes, and seconds, or: =TIMEVALUE(1650:00:00)-C1 where the single parameter is a text string in the same format in which you would enter it into a cell. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Hi again. I receive a message that say me that with version 2 my formula works but not works on version 3... Is this a bug? Regards Chema - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] English Interface
George Awad wrote: Dear Sir, i have just installed the open office arabic edition, but i need it with English menus, and when i go to language settings i do not find english in the interface language list. how can i add this. thanks _ Windows Live™ Hotmail®: Chat. Store. Share. Do more with mail. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_hm_justgotbetter_explore_012009 Hi George, try to download the english language pack for your OOo version. Regards Olaf http://www.openoffice.org/ http://qa.openoffice.org/ooQAReloaded/FrameworkTeamsite/ooQA-TeamFramework.html -- Sun Microsystems GmbH Olaf Felka Nagelsweg 55Quality Assurance Engineer 20097 Hamburg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: English Interface
2009/1/14 Jim Allan jal...@smartdm.ca George Awad wrote: i have just installed the open office arabic edition, but i need it with English menus, and when i go to language settings i do not find english in the interface language list. how can i add this. You will have to install the English version to get English menus. Note that you will be able to type in Arabic just as well in the English version as in the Arabic version. Just be sure to go into Tools → Options... → Language Settings → Languages and click on the box marked as Enabled for complex text layout (CTL) so that it is checked. Also set CTL under Default languages for documents to the form of Arabic you wish to use. You may also want to make some changes under Language of. As you appear not to be subscribed to this forum, I am sending a copy of my response to you directly. If you have any further questions or comments, please send them directly to users@openoffice.org, not to my own email address. Jim Allan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Forwarding to unsubscribed OP. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
Re: [users] Accountant Payable and Receivable
gamini karunasena wrote: Hi, Please be send me work sheet relevant to accountant payable and receivables Expenses reports,  Revenue reports and Cash fund logs Thanking you ! Regards Gamini Check out: http://www.freebyte.com/office/ and http://smalldataproblem.org/ooextras/downloads/english/ and http://documentation.openoffice.org/Samples_Templates/User/template/index.html There are many others. Try Google searching on OOo Accounting spreadsheet which got 261,000 hits in 0.24 seconds. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Accountant Payable and Receivable
On 01/11/2009 04:52 AM, gamini karunasena wrote: Hi, Please be send me work sheet relevant to accountant payable and receivables Expenses reports, Revenue reports and Cash fund logs Thanking you ! Regards Gamini Get your preferred Email name! Now you can @ymail.com and @rocketmail.com. http://mail.promotions.yahoo.com/newdomains/aa/ OK. http://www.gnucash.org/ - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: OOo2 OOo3 preferences error?
On 01/11/2009 12:21 AM, Morgan Read wrote: Hello Folks I've just moved from OOo2 OOo3. I simply moved my personal preference files under ~/.openoffice.org2.0/ to ~/.openoffice.org/3/ . Every thing seems to work fine - except I get 2 error windows when I start OOo fresh. I don't think that you can just move your preferences from Ooo2 to OOo3, there are issues with extensions. Instead, I'd recommend renaming your OOo3 ~/.openoffice.org/3/ folder, restart OOo3 and use the dialog to import your preferences from OOo2. You'll then need to reinstall your extentions in OOo3. Screen shots of the error windows are attached, but the list probably wont carry them so their text is: 1 Error loading BASIC of document file:///usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/script.xlb/: General Error. General input/output error. [OK] 2 Error loading BASIC of document file:///usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/dialog.xlb/: General Error. General input/output error. [OK] The location /usr/lib/openoffice.org/basis3.0/ share/basic/Launcher/ no longer exists, so those files can't be the problem, so there must be something pointing to them in my user preferences (~/.openoffice.org/3/). Does anybody have any idea what? Also, does anyone know of a little howto anywhere of what exactly to prune edit moving OOo2 preferences to OOo3? Thanks all, Morgan. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: problems with time operations on OOcalc 3
On 01/14/2009 07:39 AM, Chema wrote: [snip] Hi again. I receive a message that say me that with version 2 my formula works but not works on version 3... Is this a bug? Regards Chema From F1 (Help): TIME TIME returns the current time value from values for hours, minutes and seconds. This function can be used to convert a time based on these three elements to a decimal time value. Syntax TIME(Hour; Minute; Second) Use an integer to set the Hour. Use an integer to set the Minute. Use an integer to set the Second. Examples =TIME(0;0;0) returns 00:00:00 =TIME(4;20;4) returns 04:20:04 Note the semicolons in the function argument. TIMEVALUE TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format. The internal number indicated as a decimal is the result of the date system used under OpenOffice.org to calculate date entries. Syntax TIMEVALUE(Text) Text is a valid time expression and must be entered in quotation marks. Examples =TIMEVALUE(4PM) returns 0.67. When formatting in time format HH:MM:SS, you then get 16:00:00. =TIMEVALUE(24:00) returns 1. If you use the HH:MM:SS time format, the value is 00:00:00. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Mass Printing
Using WinXP Pro, I have a folder with 62 .odf files. I select all of them, right click, choose PRINT. I get only one document printed, not all of them. How can I get all of them to print without loading each one individually and then print them individually? What have I missed? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: The open clipart library.
On 01/13/2009 08:06 PM, John Boyle wrote: To whomever can help: How does one install the library, so that it can be seen as clipart and not gibberish? Where does one install it, besides the desktop? :-[ On linux (ubuntu): sudo apt-get install openclipart-openoffice.org openclipart-svg openclipart-png (all one line). Then set your gallery paths to /usr/share/openclipart/png and /svg plus /usr/lib/openoffice/share/gallery - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: The open clipart library.
On 01/14/2009 10:22 AM, NoOp wrote: On 01/13/2009 08:06 PM, John Boyle wrote: To whomever can help: How does one install the library, so that it can be seen as clipart and not gibberish? Where does one install it, besides the desktop? :-[ On linux (ubuntu): sudo apt-get install openclipart-openoffice.org openclipart-svg openclipart-png (all one line). Then set your gallery paths to /usr/share/openclipart/png and /svg plus /usr/lib/openoffice/share/gallery Added info: http://www.openclipart.org/wiki/FAQ - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Mass Printing
JOE Conner wrote: Using WinXP Pro, I have a folder with 62 .odf files. I select all of them, right click, choose PRINT. I get only one document printed, not all of them. How can I get all of them to print without loading each one individually and then print them individually? What have I missed? Try selecting all the documents and then dragging them to the printer. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] spellchecking
See also: http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=67 Hagar Le 12.01.2009 06:54, andrea ruming a écrit : i have tried everything but my spellchecker does not work .gone into tools-spell grammar options wont let me tick anythingi if i go into spellcheck it sayes spellcheck is complete but nothing is happening .and i know i have made mistakes. help.. andrea - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: problems with time operations on OOcalc 3
NoOp escribió: On 01/14/2009 07:39 AM, Chema wrote: [snip] Hi again. I receive a message that say me that with version 2 my formula works but not works on version 3... Is this a bug? Regards Chema From F1 (Help): TIME TIME returns the current time value from values for hours, minutes and seconds. This function can be used to convert a time based on these three elements to a decimal time value. Syntax TIME(Hour; Minute; Second) Use an integer to set the Hour. Use an integer to set the Minute. Use an integer to set the Second. Examples =TIME(0;0;0) returns 00:00:00 =TIME(4;20;4) returns 04:20:04 Note the semicolons in the function argument. TIMEVALUE TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format. The internal number indicated as a decimal is the result of the date system used under OpenOffice.org to calculate date entries. Syntax TIMEVALUE(Text) Text is a valid time expression and must be entered in quotation marks. Examples =TIMEVALUE(4PM) returns 0.67. When formatting in time format HH:MM:SS, you then get 16:00:00. =TIMEVALUE(24:00) returns 1. If you use the HH:MM:SS time format, the value is 00:00:00. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org I'm sorry for my ignorance,but I don't understand what's means your comment about my mail. I talk about in version 2 OOcalc the formula = (1600:00:00 - A1) (A1 is other cell with value 160:00:00) works and I can see a result and in version 3 OOcalc the same formula has result Err:502... Regards Chema - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: The open clipart library.
NoOp wrote: On 01/14/2009 10:22 AM, NoOp wrote: On 01/13/2009 08:06 PM, John Boyle wrote: To whomever can help: How does one install the library, so that it can be seen as clipart and not gibberish? Where does one install it, besides the desktop? :-[ On linux (ubuntu): sudo apt-get install openclipart-openoffice.org openclipart-svg openclipart-png (all one line). Then set your gallery paths to /usr/share/openclipart/png and /svg plus /usr/lib/openoffice/share/gallery Added info: http://www.openclipart.org/wiki/FAQ - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org To NoOp: Thanks for the info, it clearly shows this particular library is not ready for OOo ver. 3 as yet, which is what I needed to know! Again, Thanks. :-) -- Old Sarge-John Boyle - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] problems with time operations on OOcalc 3
On 01/14/2009 07:39 AM, Chema wrote: I receive a message that say me that with version 2 my formula works but not works on version 3... Is this a bug? At 22:17 14/01/2009 +0100, Chema wrote: I talk about in version 2 OOcalc the formula = (1600:00:00 - A1) (A1 is other cell with value 160:00:00) works and I can see a result and in version 3 OOcalc the same formula has result Err:502... Whatever may or may not have worked in version 2, in version 3 you cannot (apparently) include a time expressed as 1600:00:00 in a formula. You need to use either TIME(1600;0;0) or else TIMEVALUE(1600:00:00) - whichever you prefer. Another way would be to put the constant value in a cell and then refer to that cell in the formula. Is it a bug? No: it's a feature! I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Mass Printing
James Knott wrote: JOE Conner wrote: Using WinXP Pro, I have a folder with 62 .odf files. I select all of them, right click, choose PRINT. I get only one document printed, not all of them. How can I get all of them to print without loading each one individually and then print them individually? What have I missed? Try selecting all the documents and then dragging them to the printer. This failed UGLY. Each document created an error: soffice.bin - Application Error This application failed to initialize properly (0xc0fd). Click OK to terminate the application. 62 clicks later on the OK button finally cleaned and closed it out. Any other suggestions? Have I discovered another bug in OOo v3? Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: problems with time operations on OOcalc 3
On 01/14/2009 01:17 PM, Chema wrote: NoOp escribió: On 01/14/2009 07:39 AM, Chema wrote: [snip] Hi again. I receive a message that say me that with version 2 my formula works but not works on version 3... Is this a bug? Regards Chema From F1 (Help): TIME TIME returns the current time value from values for hours, minutes and seconds. This function can be used to convert a time based on these three elements to a decimal time value. Syntax TIME(Hour; Minute; Second) Use an integer to set the Hour. Use an integer to set the Minute. Use an integer to set the Second. Examples =TIME(0;0;0) returns 00:00:00 =TIME(4;20;4) returns 04:20:04 Note the semicolons in the function argument. TIMEVALUE TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format. The internal number indicated as a decimal is the result of the date system used under OpenOffice.org to calculate date entries. Syntax TIMEVALUE(Text) Text is a valid time expression and must be entered in quotation marks. Examples =TIMEVALUE(4PM) returns 0.67. When formatting in time format HH:MM:SS, you then get 16:00:00. =TIMEVALUE(24:00) returns 1. If you use the HH:MM:SS time format, the value is 00:00:00. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org I'm sorry for my ignorance,but I don't understand what's means your comment about my mail. I talk about in version 2 OOcalc the formula = (1600:00:00 - A1) (A1 is other cell with value 160:00:00) works and I can see a result and in version 3 OOcalc the same formula has result Err:502... Regards Chema It means that that OOo2 Calc had bugs and OOo3 corrects them. The Err:502 is telling you that you entered the formula/format incorrectly. Please read the F1/Help section on times, formats: Time Formats To display hours, minutes and seconds use the following number format [snipped] To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter hh:mm:ss.00 to display the time as 01:02:03.45. If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS So change your formula to =1650:0:0 - C1 and it will work. Or as Brian suggested, =TIME(1650;0;0) - C1 In OOo3 if I have A1= 1650:00:00 A2= 1650:00:00 C1= =SUM(A1:A5) the result in C1 is: 12:00:00 Now in C4 I put: =1650:0:0 - C1 the result in C4 is 06:00:00 However, in the above you still get inaccurate results as the format is [HH]:MM:SS. So 1650 get rounded to 18:00:00, etc. Change to: A1= 16:50:00 A2= 16:50:00 C1= =SUM(A1:A5) the result in C1 is: 09:40:00 Now in C4 I put: =16:50:00 - C1 the result in C4 is 07:10:00 The results will be exactly the same in both OOo2 and OOo3 if you follow the format. Put the above in OOo2 and you will see. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] problem database
How do I clear the numerator automatic (id) of a data base? thanks
RE: [users] font size
Sarah, Hilite all the script/whole document then go to format/paragraph/indents spacing/line spacing drop-down and select single. Witstert -Original Message- From: Shawn Taylor [mailto:shawn.tay...@gpi.com] Sent: 12 January 2009 15:55 To: users@openoffice.org Subject: RE: [users] font size Sarah, Google 'OoO Line spacing' Shawn Sarah Wrote: Now.I have another frustrating problem which I'm sure someone can help me to solve. There again, in working on a document I have inadvertantly done something that caused the line spacing to jump from single to 1 1/2 spacing. I haven't found out how to change it back. Can you give me a solution? Thanks again. Sarah - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
RE: [users] [moderated]
Marsha, OpenOffice is FREE software. You may have purchased Open Office 2009, which may be a con. Witstert -Original Message- From: Marsha Springs [mailto:mspri...@mindspring.com] Sent: 11 January 2009 22:04 To: users@openoffice.org Subject: [users] [moderated] I purchased Open Office online, but when I attempted to download, I received the message that it was an Illegal Operation, and the download did not occur. Please advise. Marsha Springs mspri...@mindspring.com EarthLink Revolves Around You. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Formatting a poem
OOo Writer: How is best to handle the format of a poem? At the end of each line one has to press Enter to change line. But then between stanzas one wants to leave a space like between paragraphs. One could use Default style for all the lines and add an empty line between stanzas. Or else, one could use the Default style for other lines and Text body style (that inserts a space after the paragraph) for the last line of a stanza, thus controlling the space between the stanzas. It works but it doesn't seem right. After all, all the lines of the stanza constitute one paragraph... Is there a better way? Eustace -- It ain't THAT, babe! - A radical reinterpretation http://www.geocities.com/itaintme_babe/itaintme.html - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] font size
Witstert wrote: Sarah, Hilite all the script/whole document then go to format/paragraph/indents spacing/line spacing drop-down and select single. Witstert Thanks for the suggestion. However, I had tried that and it didn't work for me. In my message on the 13th, however, I told how I had finally solved the problem by going to Edit and choosing Repeat Apply Styles Default. This changed all of the line spacing to single again. I don't understand why it worked, but since it did I am satisfied. My thanks to all of you who tried to help. Sarah Sarah Wrote: There again, in working on a document I have inadvertantly done something that caused the line spacing to jump from single to 1 1/2 spacing. I haven't found out how to change it back. Can you give me a solution? Thanks again. Sarah - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Formatting a poem
emf wrote: OOo Writer: How is best to handle the format of a poem? At the end of each line one has to press Enter to change line. But then between stanzas one wants to leave a space like between paragraphs. One could use Default style for all the lines and add an empty line between stanzas. Or else, one could use the Default style for other lines and Text body style (that inserts a space after the paragraph) for the last line of a stanza, thus controlling the space between the stanzas. It works but it doesn't seem right. After all, all the lines of the stanza constitute one paragraph... Is there a better way? Eustace Use the keyboard combination Shift + Enter. That will insert a line break w/o inserting a paragraph break. Then at the end of the stanza, press Enter to create a paragraph break. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Formatting a poem
On Jan 14, 2009, at 8:52 PM, emf wrote: OOo Writer: How is best to handle the format of a poem? At the end of each line one has to press Enter to change line. No, Enter creates a paragraph break. It's Shift-Enter that creates a line break. And there you are, out of your difficulty at once. -- John W Kennedy ...if you had to fall in love with someone who was evil, I can see why it was her. -- Alias - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Blank dialog boxes when rt click in Calc
The problem was caused by the program FileBox eXtender. A very good prog, it worked well with 2.4, but not 3.0. Loren wrote in message news:gjong0$cb...@ger.gmane.org... After upg to 3.0. Right click selections (paste special, insert, delete, etc) display an empty dialog box. If edit/paste special (and others) are selected in the edit menu, all is ok. I still have 2.4 installed, and all works ok when using it. Thanks for any help. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Formatting a poem
On 01/14/2009 05:52 PM, emf wrote: OOo Writer: How is best to handle the format of a poem? At the end of each line one has to press Enter to change line. But then between stanzas one wants to leave a space like between paragraphs. One could use Default style for all the lines and add an empty line between stanzas. Or else, one could use the Default style for other lines and Text body style (that inserts a space after the paragraph) for the last line of a stanza, thus controlling the space between the stanzas. It works but it doesn't seem right. After all, all the lines of the stanza constitute one paragraph... Is there a better way? Eustace In addition to Richard John's good advise, you sometimes can find MS Word templates that will work with some modification: http://www.google.com/search?q=ms+word+%2B%22poetry+template%22complete=0hl=enfilter=0 For example, in this doc, the poem styles are defined and added to the style list: http://www.csufresno.edu/gradstudies/thesis/templates.shtml [MFA poetry template: Instruction file | Times New Roman template] http://www.csufresno.edu/gradstudies/thesis/template/pTimes_New_Roman.doc When you open the doc in OOo and go to the poem sections, you'll notice that there are indeed actual poetry styles in the doc that you can copy/use/modify. POEM TITLL (CAPS) Poem title (Multiple line etc. All of which you can create on your own of course, but handy to see how the style is set up for a Cal State Master's thesis for a Master of Fine Arts in Creative Writing. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Formatting a poem
On 01/14/2009 07:10 PM, NoOp wrote: On 01/14/2009 05:52 PM, emf wrote: OOo Writer: How is best to handle the format of a poem? At the end of each line one has to press Enter to change line. But then between stanzas one wants to leave a space like between paragraphs. One could use Default style for all the lines and add an empty line between stanzas. Or else, one could use the Default style for other lines and Text body style (that inserts a space after the paragraph) for the last line of a stanza, thus controlling the space between the stanzas. It works but it doesn't seem right. After all, all the lines of the stanza constitute one paragraph... Is there a better way? Eustace In addition to Richard John's good advise, you sometimes can find MS Word templates that will work with some modification: http://www.google.com/search?q=ms+word+%2B%22poetry+template%22complete=0hl=enfilter=0 For example, in this doc, the poem styles are defined and added to the style list: http://www.csufresno.edu/gradstudies/thesis/templates.shtml [MFA poetry template: Instruction file | Times New Roman template] http://www.csufresno.edu/gradstudies/thesis/template/pTimes_New_Roman.doc When you open the doc in OOo and go to the poem sections, you'll notice that there are indeed actual poetry styles in the doc that you can copy/use/modify. POEM TITLL (CAPS) Poem title (Multiple line etc. All of which you can create on your own of course, but handy to see how the style is set up for a Cal State Master's thesis for a Master of Fine Arts in Creative Writing. Apologies; I should have read: quote Any use beyond the intended is prohibited, without permission of the Division of Graduate Studies. /quote In any event it will give you an idea of how you can create your own poetry styles for your documents. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to use VLOOKUP function
ithelpdesk@shreyas.co.in wrote: Dear ALL, When we are using a vlookup fuction in dowloaded file that gives up error 508. for this we can me can use past special for both data but output not come. We know the command = VLOOKUP (SearchCriterion; Array; Index; SortOrder) But still the command works only on the first cell and the rest of the cell it throws an error 508. Any solution for the same. Regards, Ithelpdesk. Use VLOOKUP to search the first column (columns are vertical) of a block of data and return the value from a column in the same row. For example, search the first column for the name “Fred” and then return value in the cell two columns to the right. VLOOKUP supports two forms: with and without sort order. The first argument, search_value, identifies the value to find. The search value can be text, a number, or a regular expression. For example, “Fred” searches for the text Fred, 4 searches for the number 4, and “F.*” is the regular expression for find something that starts with the letter F. The second argument, search_range, identifies the cells to search; only the first column is searched. For example, B3:G10 searches the same sheet containing the VLOOKUP formula and Sheet2.B3:G10 searches the range B3:G10 on the sheet named Sheet2. The return_column_index identifies the column to return; a value of 1 returns the first column in the range. The statement =VLOOKUP(Bob; A1:G9; 1) finds the first row in A1:G9 containing the text “Bob”, and returns the value in the first column. The first column is the searched column, so the text Bob is returned. If the column index is 2, then the value in the cell to the right of Bob is returned; column B. The final column, sort_order, is optional. The default value for sort_order is 1, which specifies that the first column is sorted in ascending order; a value of 0 specifies that the data is not sorted. A non-sorted list is searched by sequentially checking every cell in the first column for an exact match. If an exact match is not found, the text “#N/A” is returned. A more efficient search routine is used if the data is sorted in ascending order. If one exact match exists, the returned value is the same as for a non-sorted list; but it is faster. If a match does not exist, the largest value in the column that is less than or equal to the search value is returned. For example, Searching for 7 in (3, 5, 10) returns 5 because 7 is between 5 and 10. Searching for 27 returns 10, and searching for 2 returns “#N/A” because there is no match and no value less than 2. Use VLOOKUP when: * The Data is arranged in rows and you want to return data from the same row. For example, student names with test and quiz scores to the right of the student's name. * Searching the first column of a range of data. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Converting MS Access database to OO.o Base
How does one go about converting a Microsoft Access database to OO.o Base? The document converter does not include Access. I have a rather large database, more than 38,000 records, that I wish to convert. Thanks in advance. Bill - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] CALC Question
I have Open Office and I enjoy using Calc. How do I turn off always asking me what kind of data I want to clear out of a cell when I clear out a cell? Thanks Steve
Re: [users] CALC Question
At 22:36 14/01/2009 -0600, Cardnut Sports Memorabilia wrote: I have Open Office and I enjoy using Calc. How do I turn off always asking me what kind of data I want to clear out of a cell when I clear out a cell? Once you have selected the material you want to delete, just press Backspace instead of Delete. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org