Re: [users] Re: [openoffice] [users] Photos in DataBase

2009-09-26 Thread jomali
On Fri, Sep 25, 2009 at 11:28 PM, John Kaufmann kaufm...@nb.net wrote: In a message dated 2009.09.06 19:54 -0500, Keith Bates wrote: On Sat, 2009-09-05 at 13:47 -0700, Susan Wallace-Masse wrote: ... I am transcribing a cemetery and I need to be able to attach one or more photos to each

Re: [users] Re: Paragraph with enclosed list

2009-09-26 Thread John Kaufmann
In a message dated 2009.09.26 00:07 -0500, Joe Smith wrote: - I can make the frame, and put the list in it; so far, so good. - I can anchor the frame to a character - but which character to make it stay where is belongs, ... The anchor is _as_ character, not _to_ character. An object

[users] Re: Mailing list

2009-09-26 Thread NoOp
On 09/25/2009 07:24 PM, Gene Young wrote: AG wrote: Wade Smart wrote: Victoria Ceolin wrote: Please remove me from the mailing list. Thanks lod...@sympatico.ca Bottom of the list | V - To unsubscribe,

Re: [users] number extraction for a formula

2009-09-26 Thread twoinfountain
PLEASE REMOVE ME FROM YOUR MAILING LIST THANK YOU - Original Message - From: Wade Smart w...@wadesmart.com To: users@openoffice.org Sent: Saturday, September 26, 2009 10:47 AM Subject: Re: [users] number extraction for a formula Wade Smart wrote: Harold Fuchs wrote:

Re: [users] Inability To Enter Formatting Code in Find Field

2009-09-26 Thread Harold Fuchs
2009/9/26 Harold Fuchs hwfa.openoff...@googlemail.com 2009/9/26 James R. Liebert jiml...@neo.rr.com See http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=22725 for identification of deficiency. I hope someone more clever will show me how to enter a non-breaking space in

Re: [users] Or statement in If/else

2009-09-26 Thread Franz Wein
Hi Wade use this =IF(OR (O3=80; O3 25);spring2010;fall2009) I am using the GermanOOO version there is ; (Semikolen) the marker between the positions best Regards Franz Wein Wade Smart schrieb: =IF(O3=80 or 25,spring2010,fall2009) I dont know if this is possible or not but, I would like

Re: [users] Re: Paragraph with enclosed list

2009-09-26 Thread twoinfountain
PLEASE REMOVE ME FROM YOUR MAIL LIST THANK YOU - Original Message - From: John Kaufmann kaufm...@nb.net To: users@openoffice.org Sent: Saturday, September 26, 2009 3:20 AM Subject: Re: [users] Re: Paragraph with enclosed list In a message dated 2009.09.26 00:07 -0500, Joe Smith

Re: [users] Unsubscribe [was Re: Paragraph with enclosed list]

2009-09-26 Thread Barbara Duprey
The users on this list have no authority to unsubscribe you, you'll need to do that yourself. Send a message from this account (twoinfount...@peoplepc.com) to users-unsubscr...@openoffice.org (the subject and content don't matter, just the address). That should soon result in your getting an

RE: [users] Mailing list

2009-09-26 Thread Timo Lynch
It may be about stupidity but whose. Before labeling those trying unsuccessfully as stupid, please consider that since it happens so many times there may be a problem. I have tried on numerous occasions to unsubscribe following the posted directions but without success. I have confirmed that the

Re: [users] Re: Paragraph with enclosed list

2009-09-26 Thread Brad Rogers
On Sat, 26 Sep 2009 08:24:37 -0400 twoinfount...@peoplepc.com wrote: Hello twoinfount...@peoplepc.com, PLEASE REMOVE ME FROM YOUR MAIL LIST THANK YOU We can't. Only you can do that. Follow the instructions at the foot of most messages to the list. -- Regards _ / ) The

Re: [users] Mailing list

2009-09-26 Thread Barbara Duprey
Timo, it sounds as if you're not getting the confirmation request, is that true? Nearly all of those to whom we give this advice then vanish, so it has apparently worked for them or they'd probably come back with questions. The exceptions I've seen have had to do with filters, or with an

Re: [users] Mailing list

2009-09-26 Thread Barbara Duprey
Please stop hijacking threads telling us to do something that we have no authority (or even means) to do. I responded to another such message from you with the action you need to take to unsubscribe. If you have not done that, please do it now. If you have, and it didn't work (you are still

Re: [users] Inability To Enter Formatting Code in Find Field

2009-09-26 Thread Harold Fuchs
2009/9/26 James R. Liebert jiml...@neo.rr.com See http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=22725 for identification of deficiency. I hope someone more clever will show me how to enter a non-breaking space in the Find or Replace fields in respect to Writer, so I may

[users] Re: Paragraph with enclosed list

2009-09-26 Thread Joe Smith
On 09/26/2009 03:20 AM, John Kaufmann wrote: Let me digress to ask what should be a basic question ... ... Is that the way it is supposed to be done? That looks about right. In this case, I think there's actually another step. When you Insert Frame, then apply a frame style that changes

[users] Re: Word spacing

2009-09-26 Thread Andy Lewis
John Kaufmann wrote: ;-) Setting aside the question of what that does to document size... Increases it by about 10% on the document I tried this with. What is the size of the /next/ space when the document is edited? Well I was envisaging this as something one might do just before

Re: [users] number extraction for a formula

2009-09-26 Thread Barbara Duprey
Gene Young wrote: twoinfount...@peoplepc.com wrote: PLEASE REMOVE ME FROM YOUR MAIL LIST THANKS You are not subscribed with the email address you used to post this message to this list. If you are still receiving messages from this list YOU need to figure out what YOU did to get these

Re: [users] number extraction for a formula

2009-09-26 Thread Wade Smart
Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same position - two characters long, starting at the 14th character - and assuming the strings are in column A and you want answers in column B, then enter into column B the formula

Re: [users] number extraction for a formula

2009-09-26 Thread Harold Fuchs
2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote: 2009/9/26 Wade Smart w...@wadesmart.com JOE Conner wrote: Wade Smart wrote: I have a group of numbers in a column 265879-09-24-71-918-333-0055 and I need to take the fourth set of numbers, in this case the 71, and subtract

[users] Re: Mailing list

2009-09-26 Thread Larry Gusaas
On 2009/09/26 9:45 AM NoOp wrote: Another issue is the OOo support page itself: http://support.openoffice.org/index.html quote Users Mail List (Subscribe / Archives) OpenOffice.org Project community support provided by a network of hundreds of experienced users. You must be subscribed to post

Re: [users] Mailing list

2009-09-26 Thread twoinfountain
PLEASE REMOVE ME FROM THIS/YOUR MAILING LIST THANK YOU - Original Message - From: Timo Lynch t...@tlync.com To: users@openoffice.org Sent: Saturday, September 26, 2009 8:46 AM Subject: RE: [users] Mailing list It may be about stupidity but whose. Before labeling those trying

Re: [users] number extraction for a formula

2009-09-26 Thread Harold Fuchs
2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same position - two characters long, starting at the 14th character - and assuming the strings are in column A and you want answers in column B,

Re: [users] number extraction for a formula

2009-09-26 Thread Wade Smart
Wade Smart wrote: Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same position - two characters long, starting at the 14th character - and assuming the strings are in column A and you want answers in column B, then enter into column B

Re: [users] number extraction for a formula

2009-09-26 Thread Wade Smart
Harold Fuchs wrote: 2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same position - two characters long, starting at the 14th character - and assuming the strings are in column A and you want

[users] Re: Mailing list

2009-09-26 Thread NoOp
On 09/26/2009 10:22 AM, Larry Gusaas wrote: On 2009/09/26 9:45 AM NoOp wrote: Another issue is the OOo support page itself: http://support.openoffice.org/index.html quote Users Mail List (Subscribe / Archives) OpenOffice.org Project community support provided by a network of hundreds of

Re: [users] number extraction for a formula

2009-09-26 Thread Gene Young
twoinfount...@peoplepc.com wrote: PLEASE REMOVE ME FROM YOUR MAIL LIST THANKS You are not subscribed with the email address you used to post this message to this list. If you are still receiving messages from this list YOU need to figure out what YOU did to get these emails. No one on

Re: [users] Mailing list

2009-09-26 Thread Gene Young
Timo Lynch wrote: It may be about stupidity but whose. Before labeling those trying unsuccessfully as stupid, please consider that since it happens so many times there may be a problem. I have tried on numerous occasions to unsubscribe following the posted directions but without success. I have

Re: [users] number extraction for a formula

2009-09-26 Thread twoinfountain
PLEASE REMOVE ME FROM YOUR MAIL LIST THANKS - Original Message - From: Harold Fuchs hwfa.openoff...@googlemail.com To: users@openoffice.org Sent: Saturday, September 26, 2009 6:10 AM Subject: Re: [users] number extraction for a formula 2009/9/26 Wade Smart w...@wadesmart.com Harold

[users] Re: Inability To Enter Formatting Code in Find Field

2009-09-26 Thread NoOp
On 09/26/2009 02:02 AM, Harold Fuchs wrote: 2009/9/26 James R. Liebert jiml...@neo.rr.com See http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=22725 for identification of deficiency. I hope someone more clever will show me how to enter a non-breaking space in the Find or

Re: [users] Mailing list

2009-09-26 Thread John Kaufmann
In a message dated 2009.09.26 08:46 -0500, Timo Lynch wrote: ... Before labeling those trying unsuccessfully as stupid, please consider that since it happens so many times there may be a problem. I have tried on numerous occasions to unsubscribe following the posted directions but without

Re: [users] Inability To Enter Formatting Code in Find Field

2009-09-26 Thread Johnny Rosenberg
2009/9/26 Harold Fuchs hwfa.openoff...@googlemail.com: Sorry to reply to my own post but ... If you are on a Windows system and you use the wonderful, free program AllChars (http://allchars.zwolnet.com/) for entering accented characters, ligatures etc. then you can enter a non-breaking space

Re: [users] Re: [openoffice] [users] Photos in DataBase

2009-09-26 Thread John Kaufmann
In a message dated 2009.09.26 12:31 -0500, jomali wrote: ... I am transcribing a cemetery and I need to be able to attach one or more photos to each entry I make. How do I do this? There is a tutorial on this at: http://sheepdogguides.com/fdb/fdb1imag.htm Keith, I'm not the OP, but I took

Re: [users] number extraction for a formula

2009-09-26 Thread Gene Young
Barbara Duprey wrote: Gene Young wrote: twoinfount...@peoplepc.com wrote: PLEASE REMOVE ME FROM YOUR MAIL LIST THANKS You are not subscribed with the email address you used to post this message to this list. If you are still receiving messages from this list YOU need to figure out what

Re: [users] number extraction for a formula

2009-09-26 Thread Harold Fuchs
Wade Smart wrote: Harold Fuchs wrote: 2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same position - two characters long, starting at the 14th character - and assuming the strings are in

[users] Adding values in columns as they become available

2009-09-26 Thread Wade Smart
Alright. Im really getting stuff done today learning to use more of these functions Based on the questions and answers from earlier and I moved on to tackle more difficult things. Right working now on team standings in different clubs in the league. I have six teams (A2 to A7), D2 hold the

Re: [users] number extraction for a formula

2009-09-26 Thread Wade Smart
Harold Fuchs wrote: Wade Smart wrote: Harold Fuchs wrote: 2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same position - two characters long, starting at the 14th character - and assuming the

Re: [users] Adding values in columns as they become available

2009-09-26 Thread Wade Smart
Wade Smart wrote: Alright. Im really getting stuff done today learning to use more of these functions Based on the questions and answers from earlier and I moved on to tackle more difficult things. Right working now on team standings in different clubs in the league. I have six teams (A2

[users] Automatic copying

2009-09-26 Thread Walter Hildebrandt
Is it possible to do the following? 1. Cells A1, A2, A3, A4, and A5 get numbers that are downloaded from a website. 2. The number in Cell A1 is automatically moved to (copied to) cell B5 3. The number in Cell A2 is automatically moved to (copied to) cell B4 4. The number in Cell A3

Re: [users] Automatic copying

2009-09-26 Thread Wade Smart
Walter Hildebrandt wrote: Is it possible to do the following? 1. Cells A1, A2, A3, A4, and A5 get numbers that are downloaded from a website. 2. The number in Cell A1 is automatically moved to (copied to) cell B5 3. The number in Cell A2 is automatically moved to (copied to) cell B4

Re: [users] Automatic copying

2009-09-26 Thread Walter Hildebrandt
I am using WindowsXP. Wade, I do not understand. What do you mean by Site 1, Site 2 etc Walter On Sat, Sep 26, 2009 at 2:37 PM, Wade Smart w...@wadesmart.com wrote: Walter Hildebrandt wrote: Is it possible to do the following? 1. Cells A1, A2, A3, A4, and A5 get numbers that are

Re: [users] Adding values in columns as they become available

2009-09-26 Thread Brian Barker
At 14:56 26/09/2009 -0500, Wade Smart wrote: Right working now on team standings in different clubs in the league. I have six teams (A2 to A7), D2 hold the points (3win, 1tie, 0loss). D2, h2, J2, K2, L2, N2, etc are date columns holding the points value. X2 to X7 is the Wins column, Y2 - 7 is

Re: [users] number extraction for a formula

2009-09-26 Thread Johnny Rosenberg
2009/9/26 Harold Fuchs hwfa.openoff...@googlemail.com: Wade Smart wrote: Harold Fuchs wrote: 2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote:  265879-09-24-71-918-333-0055  Assuming the 71 part of your string is always in the same position - two characters long, starting

Re: [users] Automatic copying

2009-09-26 Thread Johnny Rosenberg
2009/9/26 Walter Hildebrandt wh2...@gmail.com: Is it possible to do the following?   1. Cells A1, A2, A3, A4, and A5 get numbers that are downloaded from a   website.   2. The number in Cell A1 is automatically moved to (copied to) cell B5   3. The number in Cell A2 is automatically moved to

Re: [users] Automatic copying

2009-09-26 Thread Wade Smart
Walter Hildebrandt wrote: I am using WindowsXP. Wade, I do not understand. What do you mean by Site 1, Site 2 etc Walter On Sat, Sep 26, 2009 at 2:37 PM, Wade Smart w...@wadesmart.com wrote: Walter Hildebrandt wrote: Is it possible to do the following? 1. Cells A1, A2, A3, A4, and A5

Re: [users] number extraction for a formula

2009-09-26 Thread Wade Smart
Johnny Rosenberg wrote: 2009/9/26 Harold Fuchs hwfa.openoff...@googlemail.com: Wade Smart wrote: Harold Fuchs wrote: 2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same position - two

Re: [users] Automatic copying

2009-09-26 Thread Brian Barker
At 14:32 26/09/2009 -0600, Walter Hildebrandt wrote: Is it possible to do the following? 1. Cells A1, A2, A3, A4, and A5 get numbers that are downloaded from a website. 2. The number in Cell A1 is automatically moved to (copied to) cell B5 In B5, put =A1. 3. The number in Cell A2 is

[users] Formatting Codes in Find; Barbara

2009-09-26 Thread James R. Liebert
Someone more clever than I, Barbara, sent us an explanation of how to enter Codes in Linux, Ubuntu specifically. It began something like Ctrl-Sh-u, then the 3-digit number of the character. My computer hung while it was entertaining a command to mark the message and erase other messages. The

Re: [users] Adding values in columns as they become available

2009-09-26 Thread Wade Smart
Brian Barker wrote: At 14:56 26/09/2009 -0500, Wade Smart wrote: Right working now on team standings in different clubs in the league. I have six teams (A2 to A7), D2 hold the points (3win, 1tie, 0loss). D2, h2, J2, K2, L2, N2, etc are date columns holding the points value. X2 to X7 is the

Re: [users] Automatic copying

2009-09-26 Thread Walter Hildebrandt
Jonny, I have a very large speadsheet that is updated once a week by adding additional information from a website. In using the spreadsheet I found out that the more standardized the spreadsheet the easier it is to use. It is best if the numbers are in the same order at all different parts of

Re: [users] Automatic copying

2009-09-26 Thread Walter Hildebrandt
Brian, it works great. It is so obvious and I never though of doing it that way. I have been doing a lot of putting the equal sign (=) plus a cell into a cell. I have been using the dollar sign ($), or not having a $ in the cell address, so I am very experience with cell address. This may be

[users] Notes vs. Excel Comments

2009-09-26 Thread John Meyer
Is there a way to insert a note that has a picture, much as there is in Excel? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Automatic copying

2009-09-26 Thread Walter Hildebrandt
Wade, I get what you are saying. I will be download once every week into Cells A1 through A5 and reversing the order in B1 through B5. The first week the data will be in Cells B1 though B5. I will download new data the second week. That data will end up in Cells B1 through B5 AND the B1

[users] Conditional formatting

2009-09-26 Thread Wade Smart
OMG!!! hours and hours of work done in like an hour :D I have been cleaning up my sheets to make them easier to read now that these formulas from today are working. Last thing I want to do is format the background of the cell to one of two colors based on a series of numbers. I have that

Re: [users] Conditional formatting

2009-09-26 Thread Brian Barker
At 17:30 26/09/2009 -0500, Wade Smart wrote: My question is - I have 36 different cells to apply pretty much the same conditional formatting to. Is there a way to do this without doing it to each and every one? Yes: you need just to select all the cells at once before you apply the

Re: [users] number extraction for a formula

2009-09-26 Thread JOE Conner
Wade Smart wrote: Johnny Rosenberg wrote: 2009/9/26 Harold Fuchs hwfa.openoff...@googlemail.com: Wade Smart wrote: Harold Fuchs wrote: 2009/9/26 Wade Smart w...@wadesmart.com Harold Fuchs wrote: 265879-09-24-71-918-333-0055 Assuming the 71 part of your string is always in the same

[users] Re: Mailing list

2009-09-26 Thread Ian L. Target
AG wrote: Wade Smart wrote: Victoria Ceolin wrote: Please remove me from the mailing list. Thanks lod...@sympatico.ca Bottom of the list | V - To unsubscribe, e-mail: users-unsubscr...@openoffice.org

[users] Re: Mailing list

2009-09-26 Thread NoOp
On 09/26/2009 05:06 PM, Ian L. Target wrote: AG wrote: Wade Smart wrote: Victoria Ceolin wrote: Please remove me from the mailing list. Thanks lod...@sympatico.ca Bottom of the list | V - To

[users] Calc: Shifting of symbols

2009-09-26 Thread H.S.Rai
In OOcalc I wanted to use formula (symbols) and then some mathematical formula or its description in next cell. For sysmbol is used Anchored to Cell, for description, I used Vertical Alignment: Top. With this arrangement I was unable to get symbol and description in a line. On trying to change