Re: [users] Need help with formula syntax

2009-03-09 Thread Thomas Lange - Sun Germany - ham02 - Hamburg
John Jason Jordan wrote: I have a formula in Writer 3.01 (Ubuntu Intrepid) which almost works. The code is: left lbrace alignl stack {left [ +liquid right ]~___~]rsub word # left [ +nasal right ]~___~]rsub ~___~]rsub word # left [ stack {+syllabic} # {+front} right ]~___~]rsub word # ___

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

2009-03-09 Thread Kevin Wilson
Hello, Thanks! Edit-Copy and Edit-Paste works ! Sorry, but I don't understand what you mean when talking about : ... Group them into one object (this allows scaling of your imported object to work better). ... I clicked the right mouse but I don't see what you mean by group; and in fact I do

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

2009-03-09 Thread Harold Fuchs
2009/3/9 Kevin Wilson wkev...@gmail.com Hello, Thanks! Edit-Copy and Edit-Paste works ! Sorry, but I don't understand what you mean when talking about : ... Group them into one object (this allows scaling of your imported object to work better). ... If the image is made up of several

Re: [users] Bug?

2009-03-09 Thread TomW
JOE Conner wrote: 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

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

2009-03-09 Thread bill
JOE Conner wrote: James Elliott - WA Rural Computers wrote: The Updater says that there is a new classical French dictionary extension to download ... it says the same thing every day! My questions was, how do I tell the Updater that I don't want a French dictionary and need not be

[users] Luhn Algorithm function in Calc?

2009-03-09 Thread Karl Lausten
I need to calculate the check digit using the Luhn Algorithm (AKA Luhn 10 or Modulus 10) for a given number to oblige to format of the OCR line on the payment slip of Danish FI-kort. This would allow creation of invoices with a valid payment slip identifying the debtor and payment purpose via a

Re: [users] Luhn Algorithm function in Calc?

2009-03-09 Thread Harold Fuchs
2009/3/9 Karl Lausten klaus...@aars.dk I need to calculate the check digit using the Luhn Algorithm (AKA Luhn 10 or Modulus 10) for a given number to oblige to format of the OCR line on the payment slip of Danish FI-kort. This would allow creation of invoices with a valid payment slip

[users] [Calc] Need a regex to find cells that NOT correspond to an email address.

2009-03-09 Thread Chris Bia
Hello, I need a regex to find cells that NOT correspond to an email address. I've read a lot of regular expressions, but in calc i can't do this !! Very very thanks a lot !

Re: [users] [Calc] Need a regex to find cells that NOT correspond to an email address.

2009-03-09 Thread Chris Bia
Hello Brian ! Mmm, i need something of very very very simple because i've a lot of cells of this: ma...@hotmail.it (correct) hotmail (not correct, so i must eliminate) ma...@hotmail (not correct, so i must eliminate) So, i'm triyng to find the cells that not contain a dot or a @ For example a

[users] Outlines

2009-03-09 Thread Joseph
I've looked all through this program, OO v3.0.1, and can't find out how to completely turn off the outlines and/or to change the outline to what I want it to be. I've clicked in turn off numbering, turn off outlines, and gone into format and outlines/numbering and set everything to none;

Re: [users] Bug?

2009-03-09 Thread John Boyle
JOE Conner wrote: 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.

Re: [users] Outlines

2009-03-09 Thread johndt3
Hello Joseph, maybe it's not your outline,-but your numbering feature. Look on your tools menu at the top next to the bullets and see if the numbering feature is clicked on... if you can't see the numbers next to the bullets, there should be a down arrow next to it, click on it locate your

[users] Aligning text box to the right

2009-03-09 Thread Dotan Cohen
I have an English language left-aligned document. In this document, there exists two lines of text (four words each) that need to be right aligned as whole, but share a common left alignment. That is, the longer of the two will be right aligned, and the shorter of the two will be left aligned with

Re: [users] Outlines

2009-03-09 Thread Carlos Martinez
Hi Joseph, If you like you can download the complete guide for Writer (ver, 3 ) at http://documentation.openoffice.org/manuals/userguide3/index.html at the same address you can fine the Guide of Writer at the right column (as well for the First edition of the complete guide) and look for

Re: [users] Bug?

2009-03-09 Thread JOE Conner
TomW wrote: JOE Conner wrote: 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

Re: [users] Bug?

2009-03-09 Thread Franz Wein
Hi JOE I had the same problem, 2 weeks ago. The odc-Format is changed between 3.0x and 2.xxx I know only one work around, save your calc-file as OO1-calc file - then you could work with your formulas in the older OO-CALC-Versions without any problem.. sincerley Franz JOE Conner schrieb:

[users] calc chart

2009-03-09 Thread Wayne
Hi, i have oo 3.01 installed on ubuntu release 8.0 on linux. i'm trying too create a chart where i select the data points to use. for example i would like to select the point B4, B9, and B34. How should I enter these point in the data range field. I did something like this, but did not work -

Re: [users] [Calc] Need a regex to find cells that NOT correspond to an email address.

2009-03-09 Thread Franz Wein
HI search for @ and on the left part of the string from @ search for . wenn the result is ok - so you will have a correct address sincerely Franz Chris Bia schrieb: Hello Brian ! Mmm, i need something of very very very simple because i've a lot of cells of this: ma...@hotmail.it (correct)

Re: [users] calc chart

2009-03-09 Thread JOE Conner
Wayne wrote: Hi, i have oo 3.01 installed on ubuntu release 8.0 on linux. i'm trying too create a chart where i select the data points to use. for example i would like to select the point B4, B9, and B34. How should I enter these point in the data range field. I did something like this, but did

Re: [users] Need help with formula syntax

2009-03-09 Thread John Jason Jordan
On Mon, 09 Mar 2009 09:52:38 +0100 Thomas Lange - Sun Germany - ham02 - Hamburg thomas.la...@sun.com dijo: John Jason Jordan wrote: I have a formula in Writer 3.01 (Ubuntu Intrepid) which almost works. The code is: left lbrace alignl stack {left [ +liquid right ]~___~]rsub word #

Re: [users] Bug?

2009-03-09 Thread JOE Conner
Franz Wein wrote: Hi JOE I had the same problem, 2 weeks ago. The odc-Format is changed between 3.0x and 2.xxx I know only one work around, save your calc-file as OO1-calc file - then you could work with your formulas in the older OO-CALC-Versions without any problem.. sincerley Franz

[users] Re: ver 3 is rubbish.

2009-03-09 Thread Gordon
David B Teague wrote: I tried the memory settings mentioned in the link. These settings are consonant with settings mentioned in other posts. After a reboot, or after not having OO.o loaded for a while (not measured, but longer than a half hour), the OO.o start time for a 50K odt file is 17

[users] Re: ver 3 is rubbish.

2009-03-09 Thread Gordon
Ugly Me wrote: - Original Message - From: Gregory L. Forster gforst.1...@sbcglobal.net To: users@openoffice.org Sent: Saturday, March 07, 2009 5:19 PM Subject: Re: [users] Re: ver 3 is rubbish. WOW! I tweaked up the memory as suggested: Use for OpenOffice.org - 256mb Memory per

Re: [users] calc chart

2009-03-09 Thread Wayne
On Mon, 2009-03-09 at 10:10 -0700, JOE Conner wrote: Wayne wrote: Hi, i have oo 3.01 installed on ubuntu release 8.0 on linux. i'm trying too create a chart where i select the data points to use. for example i would like to select the point B4, B9, and B34. How should I enter these

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

2009-03-09 Thread NoOp
On 03/09/2009 03:47 AM, bill wrote: JOE Conner wrote: James Elliott - WA Rural Computers wrote: The Updater says that there is a new classical French dictionary extension to download ... it says the same thing every day! My questions was, how do I tell the Updater that I don't want a

Re: [users] calc chart

2009-03-09 Thread Wayne
Hi, i have oo 3.01 installed on ubuntu release 8.0 on linux. i'm trying too create a chart where i select the data points to use. for example i would like to select the point B4, B9, and B34. How should I enter these point in the data range field. I did something like this, but

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread Barbara Duprey
Gordon wrote: Ugly Me wrote: - Original Message - From: Gregory L. Forster gforst.1...@sbcglobal.net To: users@openoffice.org Sent: Saturday, March 07, 2009 5:19 PM Subject: Re: [users] Re: ver 3 is rubbish. WOW! I tweaked up the memory as suggested: Use for OpenOffice.org - 256mb

Re: [users] calc chart

2009-03-09 Thread Wayne
On Mon, 2009-03-09 at 14:11 -0400, Wayne wrote: Hi, i have oo 3.01 installed on ubuntu release 8.0 on linux. i'm trying too create a chart where i select the data points to use. for example i would like to select the point B4, B9, and B34. How should I enter these point in the

Re: [users] calc chart

2009-03-09 Thread JOE Conner
Wayne wrote: Hi, i have oo 3.01 installed on ubuntu release 8.0 on linux. i'm trying too create a chart where i select the data points to use. for example i would like to select the point B4, B9, and B34. How should I enter these point in the data range field. I did something like this, but did

[users] Re: ver 3 is rubbish.

2009-03-09 Thread Gordon
Barbara Duprey wrote: Gordon wrote: Ugly Me wrote: - Original Message - From: Gregory L. Forster gforst.1...@sbcglobal.net To: users@openoffice.org Sent: Saturday, March 07, 2009 5:19 PM Subject: Re: [users] Re: ver 3 is rubbish. WOW! I tweaked up the memory as suggested: Use for

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread Robert Hodgins
Hmmm. My Commodore 64 had a tape recorder My Timex Sinclair saved to a tape recorder. Never could get the thing to load a program, though. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional

Re: [users] Outlines

2009-03-09 Thread Joseph
I reckon I should get out my Greek translator. I'm not sure where you're talking about. You said, Look on your tools menu at the top next to the bullets... but at the top of what? I can't find anything quite like you're describing. johndt3 wrote: Hello Joseph, maybe it's not your

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread Dave Post
Ok, I'll play. How about a DEC PDP-8 with 4K (12-bit) memory locations and a teletype for reading/writing programs on paper tape? Or a Wang programmable desktop calculator with Nixie-tube display and the ability to read up to 2 (Yes! 2! We were agog.) cards on which you'd record programs

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread JOE Conner
Dave Post wrote: Ok, I'll play. How about a DEC PDP-8 with 4K (12-bit) memory locations and a teletype for reading/writing programs on paper tape? Or a Wang programmable desktop calculator with Nixie-tube display and the ability to read up to 2 (Yes! 2! We were agog.) cards on which you'd

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread Robert Hodgins
On Mon, 2009-03-09 at 14:51 -0400, Dave Post wrote: Ok, I'll play. How about a DEC PDP-8 with 4K (12-bit) memory locations and a teletype for reading/writing programs on paper tape? Or a Wang programmable desktop calculator with Nixie-tube display and the ability to read up to 2 (Yes! 2!

Re: [users] calc chart

2009-03-09 Thread Wayne
On Mon, 2009-03-09 at 11:24 -0700, JOE Conner wrote: Wayne wrote: Hi, i have oo 3.01 installed on ubuntu release 8.0 on linux. i'm trying too create a chart where i select the data points to use. for example i would like to select the point B4, B9, and B34. How should I enter these

Re: [users] [Calc] Need a regex to find cells that NOT correspond to an email address.

2009-03-09 Thread Harold Fuchs
On 09/03/2009 14:12, Chris Bia wrote: Hello Brian ! Mmm, i need something of very very very simple because i've a lot of cells of this: ma...@hotmail.it (correct) hotmail (not correct, so i must eliminate) ma...@hotmail (not correct, so i must eliminate) So, i'm triyng to find the cells that

[users] Adding pages problem

2009-03-09 Thread John Jason Jordan
I need to add a page using Ctrl-Enter after page 5 and before page 6 in a document. Pages 6, 7 and 8 have threaded frames on them. If I position the cursor at the end of page 5 or at the beginning of page 6 before the first frame the Ctrl-Enter command adds a page at the end of the document, not

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread James Knott
Barbara Duprey wrote: Gordon wrote: Ugly Me wrote: - Original Message - From: Gregory L. Forster gforst.1...@sbcglobal.net To: users@openoffice.org Sent: Saturday, March 07, 2009 5:19 PM Subject: Re: [users] Re: ver 3 is rubbish. WOW! I tweaked up the memory as suggested: Use

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread James Knott
Gordon wrote: Hmmm. My Commodore 64 had a tape recorder Better known as a Commie 64. ;-) -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread James Knott
Robert Hodgins wrote: Hmmm. My Commodore 64 had a tape recorder My Timex Sinclair saved to a tape recorder. Never could get the thing to load a program, though. Write only storage? ;-) -- Use OpenOffice.org http://www.openoffice.org

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread James Knott
Dave Post wrote: Ok, I'll play. How about a DEC PDP-8 with 4K (12-bit) memory locations and a teletype for reading/writing programs on paper tape? Or a Wang programmable desktop calculator with Nixie-tube display and the ability to read up to 2 (Yes! 2! We were agog.) cards on which you'd

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread James Knott
Robert Hodgins wrote: On Mon, 2009-03-09 at 14:51 -0400, Dave Post wrote: Ok, I'll play. How about a DEC PDP-8 with 4K (12-bit) memory locations and a teletype for reading/writing programs on paper tape? Or a Wang programmable desktop calculator with Nixie-tube display and the

Re: [users] an empty cell in Calc

2009-03-09 Thread Walter Hildebrandt
Great, the =IF(ISNUMBER(A1);A1-3;) The following is a summary of what worked; number one =IF(A1=0;””;A1) if A1 is empty get empty. If A1 has a 0 get an empty cell. If there is a number that is not 0 get that number. Number two =IF(ISBLANK(A1);””;A1) and =IF(ISNUMBER(A1);A1;””) produce the same

[users] Re: Need help with formula syntax

2009-03-09 Thread NoOp
On 03/09/2009 10:20 AM, John Jason Jordan wrote: I wish I could find a complete reference to the formula commands with examples. The Help is only a couple of pages. I found a PDF online that was six pages, but it was written in 2005 and half the features were not displayed with examples.

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread Robert Hodgins
On Mon, 2009-03-09 at 16:18 -0400, James Knott wrote: Robert Hodgins wrote: On Mon, 2009-03-09 at 14:51 -0400, Dave Post wrote: Ok, I'll play. How about a DEC PDP-8 with 4K (12-bit) memory locations and a teletype for reading/writing programs on paper tape? Or a Wang programmable

Re: [users] Re: Need help with formula syntax

2009-03-09 Thread Michele Zarri
2009/3/9 NoOp gl...@sbcglobal.net On 03/09/2009 10:20 AM, John Jason Jordan wrote: I wish I could find a complete reference to the formula commands with examples. The Help is only a couple of pages. I found a PDF online that was six pages, but it was written in 2005 and half the features

Re: [users] Adding pages problem

2009-03-09 Thread JOE Conner
John Jason Jordan wrote: I need to add a page using Ctrl-Enter after page 5 and before page 6 in a document. Pages 6, 7 and 8 have threaded frames on them. If I position the cursor at the end of page 5 or at the beginning of page 6 before the first frame the Ctrl-Enter command adds a page at the

Re: [users] an empty cell in Calc

2009-03-09 Thread JOE Conner
Walter Hildebrandt wrote: Great, the =IF(ISNUMBER(A1);A1-3;) The following is a summary of what worked; number one =IF(A1=0;��;A1) if A1 is empty get empty. If A1 has a 0 get an empty cell. If there is a number that is not 0 get that number. Number two =IF(ISBLANK(A1);��;A1) and

Re: [users] Adding pages problem

2009-03-09 Thread John Jason Jordan
On Mon, 09 Mar 2009 14:31:46 -0700 JOE Conner joeconner2...@gmail.com dijo: John Jason Jordan wrote: I need to add a page using Ctrl-Enter after page 5 and before page 6 in a document. Pages 6, 7 and 8 have threaded frames on them. If I position the cursor at the end of page 5 or at the

Re: [users] Adding pages problem

2009-03-09 Thread Michele Zarri
2009/3/9 John Jason Jordan johnjas...@gmail.com I need to add a page using Ctrl-Enter after page 5 and before page 6 in a document. Pages 6, 7 and 8 have threaded frames on them. If I position the cursor at the end of page 5 or at the beginning of page 6 before the first frame the Ctrl-Enter

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread David B Teague
Gordon wrote: David B Teague wrote: I tried the memory settings mentioned in the link. These settings are consonant with settings mentioned in other posts. After a reboot, or after not having OO.o loaded for a while (not measured, but longer than a half hour), the OO.o start time for a 50K

Re: [users] Adding pages problem

2009-03-09 Thread John Jason Jordan
On Mon, 9 Mar 2009 22:55:19 +0100 Michele Zarri m.za...@gmail.com dijo: 2009/3/9 John Jason Jordan johnjas...@gmail.com I need to add a page using Ctrl-Enter after page 5 and before page 6 in a document. Pages 6, 7 and 8 have threaded frames on them. If I position the cursor at the end

Re: [users] Re: ver 3 is rubbish.

2009-03-09 Thread David B Teague
Barbara Duprey wrote: Gordon wrote: Ugly Me wrote: - Original Message - From: Gregory L. Forster gforst.1...@sbcglobal.net To: users@openoffice.org Sent: Saturday, March 07, 2009 5:19 PM Subject: Re: [users] Re: ver 3 is rubbish. WOW! I tweaked up the memory as suggested: Use for

Re: [users] an empty cell in Calc

2009-03-09 Thread Walter Hildebrandt
The =ABS(B1) + ABS(C1) has to work in all of the four conditions. it only worked when B1 was 10% and C1 was -10%. D1 had 20% (a positive number) regardless of whether there was positive or negative numbers in B1 and C1. On Mon, Mar 9, 2009 at 3:40 PM, JOE Conner joeconner2...@gmail.com

Re: [users] Adding pages problem

2009-03-09 Thread Michele Zarri
I guess where I went wrong was assuming that anchoring something to Page actually anchored it to the page. :) -- :) I am also a bit puzzled by this behaviour, but I guess this is the way it has to be since when you anchor something to the page you detach it from the text flow. A similar issue

Re: [users] an empty cell in Calc

2009-03-09 Thread JOE Conner
Walter Hildebrandt wrote: The =ABS(B1) + ABS(C1) has to work in all of the four conditions. it only worked when B1 was 10% and C1 was -10%. D1 had 20% (a positive number) regardless of whether there was positive or negative numbers in B1 and C1. On Mon, Mar 9, 2009 at 3:40 PM, JOE Conner

Re: [users] an empty cell in Calc

2009-03-09 Thread Graham Bowden
How about this, I am not absolutely sure I understand what you need to do, but here goes: =ABS(A1-B1)/ABS(A1) If A1=0 there will of course be an error - so you might want to decide what needs to happen in this instance: e.g. =ABS(A1-B1)/IF(A1=0;1;ABS(A1)) Hope this helps G -

Re: [users] Outlines

2009-03-09 Thread Joseph
When I follow the directions which says, Choose *Format - Bullets and Numbering - Outline* tab Open *Styles and Formatting* - Numbering Styles - context menu of an entry - choose *New/Modify* I get to the Outline Tab and it works but then I can't find any styles and formatting, or

Re: [users] an empty cell in Calc

2009-03-09 Thread Walter Hildebrandt
When 10 is in both A1 and B1 the ABS answer in C1 is 20 When -10 is in both A1 and B1 the ABS answer in C1 is 20 When -10 is in both A1 and B1 the ABA answer in C1 is 20 When when 10 is in A1 and -10 is in B1 the ABS answer is 20 The ABS gives the same answer (a positive 20) in all of the above

Re: [users] an empty cell in Calc

2009-03-09 Thread Walter Hildebrandt
I just send an Email stating what is required. In the case of using a misture of 10 and -10 the answers should be either 0 +20 in -20. Neither of the =ABS(A1-B1)/ABS(A1) or the =ABS(A1-B1)/IF(A1=0;1;ABS(A1)) On Mon, Mar 9, 2009 at 4:55 PM, Graham Bowden grahambow...@ntlworld.comwrote: How

Re: [users] an empty cell in Calc

2009-03-09 Thread JOE Conner
Walter Hildebrandt wrote: When 10 is in both A1 and B1 the ABS answer in C1 is 20 When -10 is in both A1 and B1 the ABS answer in C1 is 20 When -10 is in both A1 and B1 the ABA answer in C1 is 20 When when 10 is in A1 and -10 is in B1 the ABS answer is 20 The ABS gives the same answer (a

Re: [users] an empty cell in Calc

2009-03-09 Thread Walter Hildebrandt
I am surprised how simple it is Thank you. On Mon, Mar 9, 2009 at 6:45 PM, JOE Conner joeconner2...@gmail.com wrote: Walter Hildebrandt wrote: When 10 is in both A1 and B1 the ABS answer in C1 is 20 When -10 is in both A1 and B1 the ABS answer in C1 is 20 When -10 is in both A1 and B1 the

[users] Re: Bug?

2009-03-09 Thread Joe Smith
JOE Conner wrote: ... It seems to me that the Open Document format specifications should have nailed the format down precisely. Otherwise, the document can not fully portable. The ODF Formula specification specifies the semicolon as the function argument separator. However, the syntax

Re: [users] Re: Bug?

2009-03-09 Thread JOE Conner
Joe Smith wrote: JOE Conner wrote: ... It seems to me that the Open Document format specifications should have nailed the format down precisely. Otherwise, the document can not fully portable. The ODF Formula specification specifies the semicolon as the function argument separator.

Re: [users] an empty cell in Calc

2009-03-09 Thread Michael Adams
On Mon, 09 Mar 2009 18:37:39 -0600 Came this utterance formulated by Walter Hildebrandt to my mailbox: I just send an Email stating what is required. In the case of using a misture of 10 and -10 the answers should be either 0 +20 in -20. Neither of the =ABS(A1-B1)/ABS(A1) or the