Re: [users] Internet Explorer Open office

2009-03-08 Thread Carlos Martinez
Web Kracked skrev: Stephen Grant Brown wrote: Hi All, I have just upgraded Open Office from 2.4.2 to 3.0 on Microsoft Vista I am now unable to set the default program for html editing to Open office What have I done wrong? Yours Sincerely Stephen Grant Brown By your subject, I

[users] Inserting .odg file into a writer document (.odt)

2009-03-08 Thread Kevin Wilson
Hi, I had created an .odg file in OpenOffice Draw. I want to insert this file into an OpenOffice document (.odt). I tried to do this, in Wrtier, by insert-file and insert-picture-from file, but it did not work. How can it be done ? Regards, Kevin

Re: [users] Inserting .odg file into a writer document (.odt)

2009-03-08 Thread Clayton
Kevin Wilson wrote: Hi, I had created an .odg file in OpenOffice Draw. I want to insert this file into an OpenOffice document (.odt). I tried to do this, in Wrtier, by insert-file and insert-picture-from file, but it did not work. How can it be done ? Open the OpenOffice.org help

Re: [users] Inserting .odg file into a writer document (.odt)

2009-03-08 Thread Kevin Wilson
Hello, Thanks! I should have mentioned before - I tried it but it did not work for me. Rgs, Kevin On Sun, Mar 8, 2009 at 12:51 PM, Clayton ccorn...@openoffice.org wrote: Kevin Wilson wrote: Hi,   I had created an .odg file in OpenOffice Draw.   I want to insert this file into an OpenOffice

RE: [users] printing even pages

2009-03-08 Thread Joe Grech
Tks guys it worked. The trick I had to insert a BLANK page. Date: Sun, 8 Mar 2009 17:36:53 +1000 From: jeanwe...@gmail.com To: users@openoffice.org Subject: Re: [users] printing even pages Joe Grech wrote: Hi, using OOo v 3.0.1 I have a 100 page book to print. How can I print the

Re: [users] Inserting .odg file into a writer document (.odt)

2009-03-08 Thread Michael Adams
On Sun, 08 Mar 2009 13:27:40 +0200 Came this utterance formulated by Kevin Wilson to my mailbox: Hello, Thanks! I should have mentioned before - I tried it but it did not work for me. Rgs, Kevin On Sun, Mar 8, 2009 at 12:51 PM, Clayton ccorn...@openoffice.org wrote: Kevin Wilson

Re: [users] an empty cell in Calc

2009-03-08 Thread Walter Hildebrandt
Sorry for the confusion. i will try again. If A1 is empty or has an 0 in it, I want B1 to be empty. At the same time if A1 has any number in it, I want B1 to have that number in B1. . On Sun, Mar 8, 2009 at 12:44 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 19:31 07/03/2009 -0700,

Re: [users] an empty cell in Calc

2009-03-08 Thread Michael Adams
On Sun, 08 Mar 2009 09:51:22 -0600 Came this utterance formulated by Walter Hildebrandt to my mailbox: Sorry for the confusion. i will try again. If A1 is empty or has an 0 in it, I want B1 to be empty. At the same time if A1 has any number in it, I want B1 to have that number in B1. In B1

Re: [users] an empty cell in Calc

2009-03-08 Thread Walter Hildebrandt
=A1 does not work because B1 will not be empty when A1 has a 0 in it. On Sun, Mar 8, 2009 at 10:01 AM, Michael Adams mbad...@paradise.net.nzwrote: On Sun, 08 Mar 2009 09:51:22 -0600 Came this utterance formulated by Walter Hildebrandt to my mailbox: Sorry for the confusion. i will try

Re: [users] Internet Explorer Open office

2009-03-08 Thread Web Kracked
Carlos Martinez wrote: Web Kracked skrev: Stephen Grant Brown wrote: Hi All, I have just upgraded Open Office from 2.4.2 to 3.0 on Microsoft Vista I am now unable to set the default program for html editing to Open office What have I done wrong? Yours Sincerely Stephen Grant Brown

Re: [users] an empty cell in Calc

2009-03-08 Thread Brian Barker
At 09:51 08/03/2009 -0600, Walter Hildebrandt wrote: Sorry for the confusion. i will try again. If A1 is empty or has an 0 in it, I want B1 to be empty. At the same time if A1 has any number in it, I want B1 to have that number in B1. In that case, you use the first suggestion I made in my

Re: [users] printing even pages

2009-03-08 Thread Barbara Duprey
Jean Hollis Weber wrote: Jsnip OOo automatically forces odds and evens to right and left. No need for the user to do anything. Indeed, users cannot overcome this arrangement, This enforced right and left can cause problems in printing double-sided if there are any automatically inserted blank

Re: [users] an empty cell in Calc

2009-03-08 Thread Walter Hildebrandt
Wow it works. Thank you. On Sun, Mar 8, 2009 at 10:13 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 09:51 08/03/2009 -0600, Walter Hildebrandt wrote: Sorry for the confusion. i will try again. If A1 is empty or has an 0 in it, I want B1 to be empty. At the same time if A1 has any

Re: [users] printing even pages

2009-03-08 Thread Brian Barker
At 11:20 08/03/2009 -0500, Barbara Duprey wrote: Jean Hollis Weber wrote: snip OOo automatically forces odds and evens to right and left. No need for the user to do anything. Indeed, users cannot overcome this arrangement, This enforced right and left can cause problems in printing

Re: [users] Override default formatting for a single document

2009-03-08 Thread Franz Wein
Hi Cohen I see, you have more problems. But OO3.01 offered more options - use the menue Extras - options - language - tab linguistik there you could create your own dictionary sincerely Franz Dotan Cohen schrieb: yes it's possible. I'm use only the German-Language-Version from

Re: [users] an empty cell in Calc

2009-03-08 Thread Gene Young
Brian Barker wrote: At 19:31 07/03/2009 -0700, Walter Hildebrandt wrote: Using 3.1 with WindowsXP As I mentioned before, I can speak only for 3.0.1. (Do you know that 3.1 will be different?) If cell A1 is empty and =IF(A1;) is in B1, B1 will have the word FALSE. What can be entered in

[users] Re: Save as .doc (97/2000/XP) with OOO300m15

2009-03-08 Thread NoOp
On 03/06/2009 10:52 PM, Jean-Baptiste Faure wrote: Le 07.03.2009 01:51, NoOp a écrit : ... 98465 indicates that this is fixed. However, I tried the same in DEV300m41(9383) and the results were that DEV300m41 crashed outright (Sun crash report sent). You are probably right : cws hb19

[users] Re: Save as .doc (97/2000/XP) with OOO300m15

2009-03-08 Thread NoOp
On 03/07/2009 12:22 PM, Pedro Izecksohn wrote: Jean-Baptiste Faure jbf.fa...@... wrote: You are probably right : cws hb19 which contains the fix for #98465 is integrated in OOO310m4. Could some of you provide a link for an executable (.exe or .deb) newer version where this bug is fixed?

Re: [users] an empty cell in Calc

2009-03-08 Thread Franz Wein
Hi I use OO 3.01 build 9379 OOO300m15 If I have to analyze a cell I use this function (I have only the German-Language-Package installed) * at first I delete all blanks i * then I convert to character * at last I ask about the content. I believe this formulas are the same in

Re: [users] an empty cell in Calc

2009-03-08 Thread Harold Fuchs
On 08/03/2009 16:06, Walter Hildebrandt wrote: =A1 does not work because B1 will not be empty when A1 has a 0 in it. On Sun, Mar 8, 2009 at 10:01 AM, Michael Adams mbad...@paradise.net.nzwrote: On Sun, 08 Mar 2009 09:51:22 -0600 Came this utterance formulated by Walter Hildebrandt to my

Re: [users] Internet Explorer Open office

2009-03-08 Thread Harold Fuchs
On 08/03/2009 16:12, Web Kracked wrote: Carlos Martinez wrote: Web Kracked skrev: Stephen Grant Brown wrote: Hi All, I have just upgraded Open Office from 2.4.2 to 3.0 on Microsoft Vista I am now unable to set the default program for html editing to Open office What have I done wrong?

[users] Re: Page break: OO - MS DOC

2009-03-08 Thread Robert Peirce
In article 11738.4353107356$1236324...@news.gmane.org, Brian Barker b.m.bar...@btinternet.com wrote: At 11:56 05/03/2009 -0500, Robert Peirce wrote: If I put a page break in an OO document and save it as a DOC file, I can't seem to remove the page break from the DOC file. Is there a way

Re: [users] an empty cell in Calc

2009-03-08 Thread Franz Wein
Hi here an example to solve your probleme sincerely Franz Harold Fuchs schrieb: On 08/03/2009 16:06, Walter Hildebrandt wrote: =A1 does not work because B1 will not be empty when A1 has a 0 in it. On Sun, Mar 8, 2009 at 10:01 AM, Michael Adams mbad...@paradise.net.nzwrote: On Sun, 08

Re: [users] an empty cell in Calc

2009-03-08 Thread Brian Barker
At 18:41 08/03/2009 +, Harold Fuchs wrote: On Sun, 08 Mar 2009 09:51:22 -0600 Came this utterance formulated by Walter Hildebrandt to my mailbox: Sorry for the confusion. i will try again. If A1 is empty or has an 0 in it, I want B1 to be empty. At the same time if A1 has any number in

Re: [users] printing even pages

2009-03-08 Thread Barbara Duprey
Brian Barker wrote: At 11:20 08/03/2009 -0500, Barbara Duprey wrote: Jean Hollis Weber wrote: snip OOo automatically forces odds and evens to right and left. No need for the user to do anything. Indeed, users cannot overcome this arrangement, This enforced right and left can cause problems

Re: [users] Internet Explorer Open office

2009-03-08 Thread Stephen Grant Brown
Hi All, I do not want KompoZer, I do not want NoteTab. All I want to know is how to set Open Office 3.0.1 as the default editor for html in Microsoft Vista's Internet Explorer. It worked with the previous version of Open Office, how do I do it with Open Office 3.0.1? Yours Sincerely

Re: [users] Page break: OO - MS DOC

2009-03-08 Thread Brian Barker
At 15:02 08/03/2009 -0400, Robert Peirce wrote: I created a document in OO and also saved it as a DOC file to send to the office. When I tried to edit it in M$ Word at the office, I could not remove a page break. Delete doesn't do it. Is there a way to do this in M$ Word? This may depend

Re: [users] Problem With Creating Hyperlinks

2009-03-08 Thread Stephen Grant Brown
Hi Franz What is the answer to this issue? Do you mean that this has been acknowledged as an issue and needs to be fixed? Or do you mean that you now know how to jump to a named anchor/bookmark in a html file from another html file? Yours Sincerely Stephen Grant Brown - Original

[users] Re: Page break: OO - MS DOC

2009-03-08 Thread Robert Peirce
In article 48803.3532900319$1236542...@news.gmane.org, Brian Barker b.m.bar...@btinternet.com wrote: At 15:02 08/03/2009 -0400, Robert Peirce wrote: I created a document in OO and also saved it as a DOC file to send to the office. When I tried to edit it in M$ Word at the office, I could

Re: [users] an empty cell in Calc

2009-03-08 Thread Walter Hildebrandt
The spreadsheet is both large and complicated. I have a new questions If A1 is empty then B1 should be empty If A1 has a 0 then B1 should have 0 (a zero) If A1 has any number except 0, then that number should be in B1 On Sun, Mar 8, 2009 at 1:31 PM, Brian Barker b.m.bar...@btinternet.comwrote:

Re: [users] Page break: OO - MS DOC

2009-03-08 Thread Brian Barker
At 16:21 08/03/2009 -0400, Robert Peirce wrote: I had inserted a manual page break in OO. [In Word,] The page break is represented by a solid black square. Placing the cursor next to it and pressing the delete key only moves the cursor to the previous line. What happens if you *select* the

Re: [users] Internet Explorer Open office

2009-03-08 Thread Harold Fuchs
On 08/03/2009 19:59, Stephen Grant Brown wrote: Hi All, I do not want KompoZer, I do not want NoteTab. All I want to know is how to set Open Office 3.0.1 as the default editor for html in Microsoft Vista's Internet Explorer. It worked with the previous version of Open Office, how do I do it

Re: [users] an empty cell in Calc

2009-03-08 Thread Harold Fuchs
On 08/03/2009 20:24, Walter Hildebrandt wrote: The spreadsheet is both large and complicated. I have a new questions If A1 is empty then B1 should be empty If A1 has a 0 then B1 should have 0 (a zero) If A1 has any number except 0, then that number should be in B1 The formula =A1 will do

Re: [users] an empty cell in Calc

2009-03-08 Thread Harold Fuchs
On 08/03/2009 19:31, Brian Barker wrote: At 18:41 08/03/2009 +, Harold Fuchs wrote: On Sun, 08 Mar 2009 09:51:22 -0600 Came this utterance formulated by Walter Hildebrandt to my mailbox: Sorry for the confusion. i will try again. If A1 is empty or has an 0 in it, I want B1 to be empty.

Re: [users] an empty cell in Calc

2009-03-08 Thread Brian Barker
At 14:24 08/03/2009 -0600, Walter Hildebrandt wrote: The spreadsheet is both large and complicated. I don't think that's relevant! I have a new questions If A1 is empty then B1 should be empty If A1 has a 0 then B1 should have 0 (a zero) If A1 has any number except 0, then that number should

Re: [users] an empty cell in Calc

2009-03-08 Thread Walter Hildebrandt
Both of the suggestions works. Thank you. On Sun, Mar 8, 2009 at 2:37 PM, Brian Barker b.m.bar...@btinternet.comwrote: At 14:24 08/03/2009 -0600, Walter Hildebrandt wrote: The spreadsheet is both large and complicated. I don't think that's relevant! I have a new questions If A1 is

Re: [users] Problem With Creating Hyperlinks

2009-03-08 Thread Franz Wein
Hi Stephen yes I think so - actualy I got no answer to my letter. The way to insert bookmarks in a dokument/file or a homepage is known. And this is the only way to edit the html and get a correct page. sincerely Franz Wein Stephen Grant Brown schrieb: Hi Franz What is the answer to this

Re: [users] printing even pages

2009-03-08 Thread Jean Hollis Weber
Barbara Duprey wrote: Brian Barker wrote: At 11:20 08/03/2009 -0500, Barbara Duprey wrote: Jean Hollis Weber wrote: snip OOo automatically forces odds and evens to right and left. No need for the user to do anything. Indeed, users cannot overcome this arrangement, This enforced right and

Re: [users] Re: Save as .doc (97/2000/XP) with OOO300m15

2009-03-08 Thread Pedro Izecksohn
I'll try to isolate the bug before filing it. The document I showed is not a bug, it is a monster. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

Re: [users] an empty cell in Calc

2009-03-08 Thread Walter Hildebrandt
an additional IF is needed in the spreadsheet. (I think this will be the last IF needed request) If A1 is empty then B1 should be empty If A1 has any number in it, that number in A1 is reduced by 3. If there is 0 in A1 then B1 would be -3. If there is a 4 in A1 then B1 would be 1. If there

Re: [users] an empty cell in Calc

2009-03-08 Thread Franz Wein
Hi Walter have you any time used the function-buttom in calc. There you will find some solutions to your questions. Try to write your funktion like you formulate it in this dokument. write in B1: *= if(A1=;A1;A1-3)* sincerely Franz Walter Hildebrandt schrieb: an additional IF is needed in

Re: [users] an empty cell in Calc

2009-03-08 Thread Gene Young
Walter Hildebrandt wrote: an additional IF is needed in the spreadsheet. (I think this will be the last IF needed request) If A1 is empty then B1 should be empty If A1 has any number in it, that number in A1 is reduced by 3. If there is 0 in A1 then B1 would be -3. If there is a 4 in A1

Re: [users] printing even pages

2009-03-08 Thread Barbara Duprey
Jean Hollis Weber wrote: Barbara Duprey wrote: Brian Barker wrote: At 11:20 08/03/2009 -0500, Barbara Duprey wrote: Jean Hollis Weber wrote: snip OOo automatically forces odds and evens to right and left. No need for the user to do anything. Indeed, users cannot overcome this arrangement,

[users] Re: Save as .doc (97/2000/XP) with OOO300m15

2009-03-08 Thread NoOp
On 03/08/2009 02:27 PM, Pedro Izecksohn wrote: I'll try to isolate the bug before filing it. The document I showed is not a bug, it is a monster. You'll get no argument from me threre :-) - To unsubscribe, e-mail:

[users] Unexpected style formats.?

2009-03-08 Thread James Elliott - WA Rural Computers
Often when I am preparing a document the style for a particular heading changes from what it was in the beginning to what it becomes later in the document. For example, I often use the predefined Heading1 at the top of my document and then use Heading 5 for each of my sections, and Heading

Re: [users] an empty cell in Calc

2009-03-08 Thread Brian Barker
At 15:41 08/03/2009 -0600, Walter Hildebrandt wrote: an additional IF is needed in the spreadsheet. (I think this will be the last IF needed request) Phew! If A1 is empty then B1 should be empty If A1 has any number in it, that number in A1 is reduced by 3. If there is 0 in A1 then B1

Re: [users] Unexpected style formats.?

2009-03-08 Thread Jean Hollis Weber
James Elliott - WA Rural Computers wrote: Often when I am preparing a document the style for a particular heading changes from what it was in the beginning to what it becomes later in the document. For example, I often use the predefined Heading1 at the top of my document and then use

Re: [users] Save as .doc (97/2000/XP) with OOO300m15

2009-03-08 Thread Pedro Izecksohn
Mike Dawe wrote: Also one or some of the embedded .wmf graphics are damaged. See page 82, Scheme IX-1: Healthy eye without Migraines. In your (unmodified) file this graphic is not present. In the (Word 95) converted document, there is a place holder with dimensions of the missing graphic at

[users] Bug?

2009-03-08 Thread JOE Conner
Using OxygenOffice Professional 3.0.1 on a WinXP Pro machine I create a spreadsheet with a formula in cell B1 =IF( ISNUMBER(A1) , IF(A1=0 , , A1), )not including the leading and trailing quote marks. It generates Err 508 in the cells it occupies. When I opened the

Re: [users] Unwanted updates - what to do with them.?

2009-03-08 Thread James Elliott - WA Rural Computers
Tim L wrote: Well, it is all up to you, You can update your extensions or not. I update them whenever they come. I added the extensions to OOo, so I would want to keep them up to date I do want to update the extensions I use, but not to clutter my computer with foreign language dictionaries

Re: [users] Re: Unwanted updates - what to do with them.?

2009-03-08 Thread James Elliott - WA Rural Computers
Thanks Keith - your summary of my question was spot on! James - Original Message - From: Keith N. McKenna keith.mcke...@comcast.net To: users@openoffice.org Sent: Sunday, March 01, 2009 1:30 PM Subject: [users] Re: Unwanted updates - what to do with them.? Web Kracked wrote: James

Re: [users] Unwanted updates - what to do with them.?

2009-03-08 Thread JOE Conner
James Elliott - WA Rural Computers wrote: Tim L wrote: Well, it is all up to you, You can update your extensions or not. I update them whenever they come. I added the extensions to OOo, so I would want to keep them up to date I do want to update the extensions I use, but not to clutter my