Re: [users] Calc AVERAGE function faulty

2009-01-14 Thread Brian Barker
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

[users] problems with time operations on OOcalc 3

2009-01-14 Thread Chema
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

[users] File type window does not show on installation of OO3

2009-01-14 Thread Rick Sue Johnson
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

[users] Registration

2009-01-14 Thread Jack Kepple
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

[users] Open Office - download failure

2009-01-14 Thread Sheila De Ciantis
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

2009-01-14 Thread gamini karunasena
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.

[users] spellchecking

2009-01-14 Thread andrea ruming
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]

2009-01-14 Thread Marsha Springs
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

2009-01-14 Thread Shawn Taylor
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

[users] From Julien Machot - Merge

2009-01-14 Thread frankf...@mba-center.net
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

[users] [moderated]

2009-01-14 Thread STUART MACKENZIE
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

2009-01-14 Thread Larry Cicchinelli
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

[users] OOo2 OOo3 preferences error?

2009-01-14 Thread Morgan Read
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

[users] OOo2 OOo3 user preferences error?

2009-01-14 Thread Morgan Read
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

Re: [users] Suppressing zeros in cells containing a formula

2009-01-14 Thread Stan Labinsky Jr.
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

Re: [users] [moderated]

2009-01-14 Thread Harold Fuchs
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

Re: [users] Open Office - download failure

2009-01-14 Thread James Knott
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

Re: [users] [moderated]

2009-01-14 Thread James Knott
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

Re: [users] [moderated]

2009-01-14 Thread James Knott
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

Re: [users] problems with time operations on OOcalc 3

2009-01-14 Thread Brian Barker
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

Re: [users] font size

2009-01-14 Thread James Knott
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

[users] English Interface

2009-01-14 Thread George Awad
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

Re: [users] spellchecking

2009-01-14 Thread Guy Voets
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..

[users] Re: English Interface

2009-01-14 Thread Jim Allan
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

Re: [users] problems with time operations on OOcalc 3

2009-01-14 Thread Chema
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

Re: [users] problems with time operations on OOcalc 3

2009-01-14 Thread Chema
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

Re: [users] English Interface

2009-01-14 Thread Olaf Felka
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

Re: [users] Re: English Interface

2009-01-14 Thread Harold Fuchs
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

Re: [users] Accountant Payable and Receivable

2009-01-14 Thread JOE Conner
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

[users] Re: Accountant Payable and Receivable

2009-01-14 Thread NoOp
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

[users] Re: OOo2 OOo3 preferences error?

2009-01-14 Thread NoOp
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

[users] Re: problems with time operations on OOcalc 3

2009-01-14 Thread NoOp
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

[users] Mass Printing

2009-01-14 Thread JOE Conner
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?

[users] Re: The open clipart library.

2009-01-14 Thread NoOp
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

[users] Re: The open clipart library.

2009-01-14 Thread NoOp
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

Re: [users] Mass Printing

2009-01-14 Thread James Knott
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

Re: [users] spellchecking

2009-01-14 Thread Hagar de l'Est
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

Re: [users] Re: problems with time operations on OOcalc 3

2009-01-14 Thread Chema
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

Re: [users] Re: The open clipart library.

2009-01-14 Thread John Boyle
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):

Re: [users] problems with time operations on OOcalc 3

2009-01-14 Thread Brian Barker
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

Re: [users] Mass Printing

2009-01-14 Thread JOE Conner
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

[users] Re: problems with time operations on OOcalc 3

2009-01-14 Thread NoOp
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

[users] problem database

2009-01-14 Thread Simone Paoletti
How do I clear the numerator automatic (id) of a data base? thanks

RE: [users] font size

2009-01-14 Thread Witstert
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

RE: [users] [moderated]

2009-01-14 Thread Witstert
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

[users] Formatting a poem

2009-01-14 Thread emf
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

Re: [users] font size

2009-01-14 Thread Sarah Della Corte
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

Re: [users] Formatting a poem

2009-01-14 Thread Richard Detwiler
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.

Re: [users] Formatting a poem

2009-01-14 Thread John W Kennedy
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.

[users] Re: Blank dialog boxes when rt click in Calc

2009-01-14 Thread Loren
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

[users] Re: Formatting a poem

2009-01-14 Thread NoOp
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

[users] Re: Formatting a poem

2009-01-14 Thread NoOp
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

Re: [users] How to use VLOOKUP function

2009-01-14 Thread Andrew Douglas Pitonyak
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

[users] Converting MS Access database to OO.o Base

2009-01-14 Thread Bill Bailey
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

[users] CALC Question

2009-01-14 Thread Cardnut Sports Memorabilia
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

2009-01-14 Thread Brian Barker
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