Re: PLEASE Help. I cannot open an Open Office file saved to my desktop.
My apologies if I am stating the obvious, but maybe it can be opened by another application. If you are using a Macintosh, right-click on the OO document and select "Open With” and try one of the non-default apps in the list. I have found that you can usually get usable text if you open an inaccessible document with TextEdit, though you may have to strip out a lot of formatting characters to make it easily readable, then copy it to and reformat it in a new WP document. If you are using Windows I assume it must have some equivalent of the Mac’s “Open With”. PCS > On 25 Apr 2022, at 3:11 pm, george bornyek wrote: > > > Hello, > > Since having computers Open Office is all that I use. This malfunction has > never happened before. What went wrong? > > I crafted a very special letter to Elon Musk on Open Office, saved it and > there is nothing that I can do to open it. > > I create my email and other memos etc on Open Office then copy-paste it to > where I will use it. > > Please help me. > > 6192237737 born...@att.net > > George Bornyek > > > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org
Re: PLEASE Help. I cannot open an Open Office file saved to my desktop.
On Mon, 25 Apr 2022 05:11:15 + (UTC) george bornyek wrote: > > Hello, > Since having computers Open Office is all that I use. This malfunction has > never happened before. What went wrong? > I crafted a very special letter to Elon Musk on Open Office, saved it and > there is nothing that I can do to open it. > I create my email and other memos etc on Open Office then copy-paste it to > where I will use it. > Please help me. > 6192237737 born...@att.net > George Bornyek > > We need to know more about what happens when you attempt to open it. What error message do you get? -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help- file lost
I have also had this problem, this year was the first time ever in 29 years w/ computers. Was working w/ someone else in a rush working from home w/ out her office equipment. You are not alone! Can you look through all the other places where you might have saved an earlier version? I now save documents and other important files in a variety of places going along. Documents folder, desktop, specifically named folder for that type of file, project folder etc. Messy but necessary for the way I work. You can also set up a backup to an external hard drive/ rocket stick or dongle etc so as to save elsewhere than your computer incase of hard drive problems. Every time I save a document it gets a slightly different name. As an example... name, date, v 1,2 etc. V being version for that date. Messy but reliable. You may have a slightly earlier version somewhere which would avoid you having to redo everything. Can you do a general search w/ slightly different names? You can also email versions to yourself. You will then have the file in your email as sent & received mail boxes. Do this at the end of the day. Good luck! We have all been there & it is a hard learned lesson. Everyone has this story too so don’t feel to bad just deal with it for the future. Lucetta > On Dec 7, 2020, at 1:20 PM, Hagar Delest wrote: > > Hi, > > See: https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=84056 > > Very few chances to recover anything. This is a longstanding issue in AOO. > > Bware, you're not subscribed to the list, you may miss other replies. > > Hagar > >> Le 07/12/2020 à 18:59, Jessica moloney a écrit : >> Hello, >> >> I am praying you can help me. My computer shut down on its own last night >> and when I reopened open office, the auto recovery was unable to recover a >> very important document that I was working on and despite me saving it >> numerous times throughout my working on it, the entire thing is now gone. >> Please, I am so desperate to recover this, if someone can please help me, I >> would greatly appreciate it. >> >> Thank you, >> Jessica >> 631-220-2620 >> >> Sent from my iPhone >> - >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help- file lost
Hi, See: https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=84056 Very few chances to recover anything. This is a longstanding issue in AOO. Bware, you're not subscribed to the list, you may miss other replies. Hagar Le 07/12/2020 à 18:59, Jessica moloney a écrit : Hello, I am praying you can help me. My computer shut down on its own last night and when I reopened open office, the auto recovery was unable to recover a very important document that I was working on and despite me saving it numerous times throughout my working on it, the entire thing is now gone. Please, I am so desperate to recover this, if someone can please help me, I would greatly appreciate it. Thank you, Jessica 631-220-2620 Sent from my iPhone - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help
On 15/10/2020 20:55, Edward Miller wrote: I created a document in Open Office. Then I cut and pasted a Zoom website (info for a meeting) into the document and saved it. However, I cannot get to the website from the document. Why not? Because, you haven't set the *AutoCorrect* option to "*URL Recognition*" or used the *Insert Link* option. Both should work. By the way you can't *Cut and Paste* a website only *Copy and Paste* works.
Re: please help
Maybe you saved the file as jpg or other image image On Thu, 15 Oct 2020, at 22:15, Peter Kovacs wrote: > > Am 15.10.20 um 20:55 schrieb Edward Miller: > > I created a document in Open Office. Then I cut and pasted a Zoom website > > (info for a meeting) into the document and saved it. However, I cannot get > > to the website from the document. Why not? > > Maybe this helps: > > The standard (default) behavior for activating hyperlinks within OOo is > to use Ctrl+click. This behavior can be changed in *Tools > Options > > OpenOffice.org > Security > Options*, by deselecting the option > *Ctrl-click* required to follow hyperlinks. If clicking in your links > activates them, check that page to see if the option has been deselected. > > From: > > https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Hyperlinks > > -- Best Regards Robin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help
Am 15.10.20 um 20:55 schrieb Edward Miller: I created a document in Open Office. Then I cut and pasted a Zoom website (info for a meeting) into the document and saved it. However, I cannot get to the website from the document. Why not? Maybe this helps: The standard (default) behavior for activating hyperlinks within OOo is to use Ctrl+click. This behavior can be changed in *Tools > Options > OpenOffice.org > Security > Options*, by deselecting the option *Ctrl-click* required to follow hyperlinks. If clicking in your links activates them, check that page to see if the option has been deselected. From: https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Hyperlinks
Re: Please help!
On Wed, 24 Jun 2020 07:02:54 +0200 Piet Fox wrote: > Every time I cut and paste or download and open a word document in > OpenOffice Writer there are shadowed bars at the end of some of the > sentences. I am able to delete it manually, but it is very time consuming > with a whole document. What can I do to prevent it? See example: > Use /Edit Paste Special, and choose "Unformatted text" from the popup. These are characters with bit 7 of a byte set. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
RE: please help, my whole chapter is unreadable after update
Is it possible you have a black highlight or background? Is it worth setting the text colour to white or yellow? With kind regards, Geoffrey Hartwell Eur Ing Professor Geoffrey M. Beresford Hartwell CEng FIMechE FIET SenMIEEE(USA) FCIArb(retired) FICArb(India) hartw...@blueyonder.co.uk http://www.arbitrator-engineer-gbh.co.uk/ Consulting Engineer and FIDIC Accredited Adjudicator -Original Message- From: Andrew Pitonyak [mailto:and...@pitonyak.org] Sent: 12 June 2020 12:30 To: users@openoffice.apache.org Subject: Re: please help, my whole chapter is unreadable after update If you want me to test load your document, send a copy to my home email address (assuming there is nothing sensitive) and I can take a peek in case it is just something with your configuration that went bad. I have never seen this so The fact that the doc loads is a good sign. A quick test (of interest), is to copy some of those black lines where you expect words to be and paste them into a regular text editor (on windows, notepad is a common choice). This should tell you if it is just a font problem (or similar). Best of luck. Andrew On Friday, June 12, 2020 06:54 EDT, Anne Scherliess wrote: Dear open office team, my openoffice just updated itself to 4.1.6 and after this i wanted to continue writing my book and the entire chapter just shows black lines and no words whatsoever. I am devastated about this, what can I do to resurrect my work? Please please help me, thankyou, Anne Scherliess http://www.theaterathome.de https://www.schauspielervideos.de/fullprofile/schauspielerin-anne-scherliess.html https://www.schauspielervideos.de/fullprofile/schauspielerin-anne-scherliess.html https://www.castforward.de/members/profile/anne-scherliess http://www.filmmakers.de/anne-scherliess http://https//www.filmmakers.de/anne-scherliess https://www.spotlight.com/8016-8979-3087 http://www.spotlight.com/8016-8979-3087 http://www.anne-scherliess.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help, my whole chapter is unreadable after update
If you want me to test load your document, send a copy to my home email address (assuming there is nothing sensitive) and I can take a peek in case it is just something with your configuration that went bad. I have never seen this so The fact that the doc loads is a good sign. A quick test (of interest), is to copy some of those black lines where you expect words to be and paste them into a regular text editor (on windows, notepad is a common choice). This should tell you if it is just a font problem (or similar). Best of luck. Andrew On Friday, June 12, 2020 06:54 EDT, Anne Scherliess wrote: Dear open office team, my openoffice just updated itself to 4.1.6 and after this i wanted to continue writing my book and the entire chapter just shows black lines and no words whatsoever. I am devastated about this, what can I do to resurrect my work? Please please help me, thankyou, Anne Scherliess http://www.theaterathome.de https://www.schauspielervideos.de/fullprofile/schauspielerin-anne-scherliess.html https://www.schauspielervideos.de/fullprofile/schauspielerin-anne-scherliess.html https://www.castforward.de/members/profile/anne-scherliess http://www.filmmakers.de/anne-scherliess http://https//www.filmmakers.de/anne-scherliess https://www.spotlight.com/8016-8979-3087 http://www.spotlight.com/8016-8979-3087 http://www.anne-scherliess.com
Re: Please help
At 14:13 05/04/2020 -0400, Robert Funnell wrote: On Sun, 5 Apr 2020, Brian Barker wrote: At 13:38 05/04/2020 -0400, Robert Funnell wrote: On Sun, 5 Apr 2020, Brian Barker wrote: > o Complete suggestions are not provided: merely partial ones as far as > they are common. I don't understand what you mean by this. Complete words are offered, even rare ones if they've been harvested from the user's documents. If the questioner's "60minutePKG" and "60minutemassage" had both been harvested (I've excised the spaces to allow the effect to show), typing "60m" would show what is common between the possibilities, so just "60minute", not either of the complete texts. S/he said that individual suggestions appeared, which is indeed what happens in a spreadsheet. Display of what's in common has never been my experience. For example, I have 'accelerating' and 'acceleration' in my list, and as soon as I type 'acc' it offers 'accelerating', not just 'accelerati'. I've often wished it would display just what's in common. (I'm actually using LO at the moment but my recollection is that it's the same in AOO.) Interesting: that's the case for me, too. Don't understand why these cases work differently ... Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help
On Sun, 5 Apr 2020, Brian Barker wrote: At 13:38 05/04/2020 -0400, Robert Funnell wrote: On Sun, 5 Apr 2020, Brian Barker wrote: > o Complete suggestions are not provided: merely partial ones as far as > they are common. I don't understand what you mean by this. Complete words are offered, even rare ones if they've been harvested from the user's documents. If the questioner's "60minutePKG" and "60minutemassage" had both been harvested (I've excised the spaces to allow the effect to show), typing "60m" would show what is common between the possibilities, so just "60minute", not either of the complete texts. S/he said that individual suggestions appeared, which is indeed what happens in a spreadsheet. Display of what's in common has never been my experience. For example, I have 'accelerating' and 'acceleration' in my list, and as soon as I type 'acc' it offers 'accelerating', not just 'accelerati'. I've often wished it would display just what's in common. (I'm actually using LO at the moment but my recollection is that it's the same in AOO.) - Robert - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help
At 13:38 05/04/2020 -0400, Robert Funnell wrote: On Sun, 5 Apr 2020, Brian Barker wrote: o Complete suggestions are not provided: merely partial ones as far as they are common. I don't understand what you mean by this. Complete words are offered, even rare ones if they've been harvested from the user's documents. If the questioner's "60minutePKG" and "60minutemassage" had both been harvested (I've excised the spaces to allow the effect to show), typing "60m" would show what is common between the possibilities, so just "60minute", not either of the complete texts. S/he said that individual suggestions appeared, which is indeed what happens in a spreadsheet. o The user would not be able to tab through suggestions, as s/he describes. I assumed she (they) meant control-tabbing. Ah: there is a simple reason I didn't think of that: I didn't know that worked! Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help
On Sun, 5 Apr 2020, Brian Barker wrote: At 12:58 05/04/2020 -0400, Robert Funnell wrote: On Sun, 5 Apr 2020, Brian Barker wrote: > At 11:03 05/04/2020 -0400, Kellie English wrote: > > I cannot for the life of me figure out how to delete unwanted auto fill > > suggestions. If I want to type '60 minute massage', it comes up even > > after I type "60", which is great, but now i have all of these other > > tabbed > > suggestions that I have to tab through before I can get to "60 minute > > massage" based on other entries I have to make for other 60 minute > > services. Is there any way I can sort through or even rearrange the > > order > > of such automated fill ins? Right now, when I type "60" here is the > > order of auto fill suggestions: > > 60 HS > > 60/EVT > > 60 minute PKG > > 60min/AO > > (I now have to tab through all of these to finally get to ;) > > 60 minute massage > > Which is the main default of what I usually need. Please help! I would > > like to rearrange the 60 minute massage to pop up first every time, or > > to just delete ALL auto fills and then start fresh? > > I'm having to guess that you are talking about entering data into a > spreadsheet document, not a word processor one. Is that so? I assumed that the message was about a word-processing document. If so, if you go to Tools > AutoCorrect > AutoCorrect Options there's a 'Word Completion' tab that seems to give control over what word completion is done. I had wondered that but ruled it out, for various reasons: o The default minimum word length is 10, so it is unlikely that entries as short as some of the questioner's examples would be harvested. My minimum word length is 8, I don't remember setting it to that. Maybe hers was somehow set to a small value? Maybe unlikely. o Only single word entries are harvested. Good point. o Complete suggestions are not provided: merely partial ones as far as they are common. I don't understand what you mean by this. Complete words are offered, even rare ones if they've been harvested from the user's documents. o The user would not be able to tab through suggestions, as s/he describes. I assumed she (they) meant control-tabbing. - Robert - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help
At 12:58 05/04/2020 -0400, Robert Funnell wrote: On Sun, 5 Apr 2020, Brian Barker wrote: At 11:03 05/04/2020 -0400, Kellie English wrote: I cannot for the life of me figure out how to delete unwanted auto fill suggestions. If I want to type '60 minute massage', it comes up even after I type "60", which is great, but now i have all of these other tabbed suggestions that I have to tab through before I can get to "60 minute massage" based on other entries I have to make for other 60 minute services. Is there any way I can sort through or even rearrange the order of such automated fill ins? Right now, when I type "60" here is the order of auto fill suggestions: 60 HS 60/EVT 60 minute PKG 60min/AO (I now have to tab through all of these to finally get to ;) 60 minute massage Which is the main default of what I usually need. Please help! I would like to rearrange the 60 minute massage to pop up first every time, or to just delete ALL auto fills and then start fresh? I'm having to guess that you are talking about entering data into a spreadsheet document, not a word processor one. Is that so? I assumed that the message was about a word-processing document. If so, if you go to Tools > AutoCorrect > AutoCorrect Options there's a 'Word Completion' tab that seems to give control over what word completion is done. I had wondered that but ruled it out, for various reasons: o The default minimum word length is 10, so it is unlikely that entries as short as some of the questioner's examples would be harvested. o Only single word entries are harvested. o Complete suggestions are not provided: merely partial ones as far as they are common. o The user would not be able to tab through suggestions, as s/he describes. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help
On Sun, 5 Apr 2020, Brian Barker wrote: At 11:03 05/04/2020 -0400, Kellie English wrote: I cannot for the life of me figure out how to delete unwanted auto fill suggestions. If I want to type '60 minute massage', it comes up even after I type "60", which is great, but now i have all of these other tabbed suggestions that I have to tab through before I can get to "60 minute massage" based on other entries I have to make for other 60 minute services. Is there any way I can sort through or even rearrange the order of such automated fill ins? Right now, when I type "60" here is the order of auto fill suggestions: 60 HS 60/EVT 60 minute PKG 60min/AO (I now have to tab through all of these to finally get to ;) 60 minute massage Which is the main default of what I usually need. Please help! I would like to rearrange the 60 minute massage to pop up first every time, or to just delete ALL auto fills and then start fresh? I'm having to guess that you are talking about entering data into a spreadsheet document, not a word processor one. Is that so? I assumed that the message was about a word-processing document. If so, if you go to Tools > AutoCorrect > AutoCorrect Options there's a 'Word Completion' tab that seems to give control over what word completion is done. Also, if you type 1 or 2 more characters after '60', the suggestions offered will be refined. - Robert - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help
At 11:03 05/04/2020 -0400, Kellie English wrote: I cannot for the life of me figure out how to delete unwanted auto fill suggestions. If I want to type '60 minute massage', it comes up even after I type "60", which is great, but now i have all of these other tabbed suggestions that I have to tab through before I can get to "60 minute massage" based on other entries I have to make for other 60 minute services. Is there any way I can sort through or even rearrange the order of such automated fill ins? Right now, when I type "60" here is the order of auto fill suggestions: 60 HS 60/EVT 60 minute PKG 60min/AO (I now have to tab through all of these to finally get to ;) 60 minute massage Which is the main default of what I usually need. Please help! I would like to rearrange the 60 minute massage to pop up first every time, or to just delete ALL auto fills and then start fresh? I'm having to guess that you are talking about entering data into a spreadsheet document, not a word processor one. Is that so? This facility offers possible entries as you type, taken from existing entries in other rows in the same column. No, I don't see any way to adjust the order of the suggestions. But yes, there is certainly a way to suppress this facility: just go to Tools | Cell Content > | AutoInput and toggle it off there. If you find yourself - as it seems - often entering similar entries in a spreadsheet column, you may wish to consider using Data Validity. o Select a cell range - perhaps all or most of a column - and go to Data | Validity... . o On the Criteria tab, for Allow, select List. o Enter your repertoire of allowable values in the Entries box. o Select other options as desired. Now when you move to a cell in the range to enter a value, you will see a down-arrow to its right. Click that with the mouse and select the particular entry you need. Note that this technique can avoid entering slight misspellings or variations that may create errors in your spreadsheet but can be quite difficult to spot. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help
Yeah, probably unnecessary, but also good on you for follow-up ‘mea culpa’. Still, very entertaining, nevertheless... I smiled a lot, and I’m sure many others, did too..! Illegitimi non carborundum.. Best Regards, Steve > On 11 Oct 2019, at 11:33, Johnny Rosenberg wrote: > > Just want to apologise for not being able to resist making fun of some > parts of the OP's post. I'm sorry, it was very unnecessary. > > > Kind regards > > Johnny Rosenberg > > > Den tors 10 okt. 2019 kl 19:10 skrev Johnny Rosenberg < > gurus.knu...@gmail.com>: > >> Den tors 10 okt. 2019 kl 14:47 skrev Dave Bito'o'wu Pratt < >> nostradumbas...@gmail.com>: >> >>> This will be the fourth try at attempting to contact you. You don't make >>> it >>> easy. The following is my original message. >>> >> >> What was the other three attempts? Writing to this list or what? >> And who are you referring to when you say ”you”? There is no Apache >> OpenOffice support. This list is just users helping other users. I'm one of >> those users (I'm actually an ex user, but that's hopefully not very >> important) and some times I ask questions and some times I answer >> questions, just like most people on the list. >> >> >>> I used to use Word up until about 10 years ago when somebody suggested >>> Open >>> Office to me. I much prefer this to Word. >> >> >> I prefer a hex editor over Word… >> >> >>> I do have one issue though. I >>> used Excel a lot. They had a function where I could add certain lines to a >>> total. On your .ods file, I can find that function. >> >> >> You can? That's great. Doesn't the mean that the problem is solved? I just >> wonder how you could find it in the ods file. Shouldn't you rather look in >> the Apache OpenOffice Calc application? >> >> >>> I don't have Word or >>> Excel on my PC now. >> >> >> Lucky guy. I have both on my job computer and I hate both. >> >> I miss that function. >> >> >> You said you could find it (in your ods file), or did you mean something >> else? Like what? >> >> >>> I have Open Office version 4.1.6. >>> Does that have the function I want? I've checked all the options at the >>> top >>> and can't find that function. Am I just missing seeing it? Please help >>> because I miss that function. Thank you. >>> >> >> Okay, jokes aside, can you please better describe what that ”function” >> actually did? I don't really understand what ”add certain lines to a total” >> means. Certain lines? To a total? How? Can you give a simple example? What >> is the function called in Excel? >> >> I'm sure that if the function doesn't exist in Calc, it's possible to make >> one with a macro, but I can't tell how complicated that would be unless I >> have more information. >> >> >> Kind regards >> >> Johnny Rosenberg >> - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help
Just want to apologise for not being able to resist making fun of some parts of the OP's post. I'm sorry, it was very unnecessary. Kind regards Johnny Rosenberg Den tors 10 okt. 2019 kl 19:10 skrev Johnny Rosenberg < gurus.knu...@gmail.com>: > Den tors 10 okt. 2019 kl 14:47 skrev Dave Bito'o'wu Pratt < > nostradumbas...@gmail.com>: > >> This will be the fourth try at attempting to contact you. You don't make >> it >> easy. The following is my original message. >> > > What was the other three attempts? Writing to this list or what? > And who are you referring to when you say ”you”? There is no Apache > OpenOffice support. This list is just users helping other users. I'm one of > those users (I'm actually an ex user, but that's hopefully not very > important) and some times I ask questions and some times I answer > questions, just like most people on the list. > > >> I used to use Word up until about 10 years ago when somebody suggested >> Open >> Office to me. I much prefer this to Word. > > > I prefer a hex editor over Word… > > >> I do have one issue though. I >> used Excel a lot. They had a function where I could add certain lines to a >> total. On your .ods file, I can find that function. > > > You can? That's great. Doesn't the mean that the problem is solved? I just > wonder how you could find it in the ods file. Shouldn't you rather look in > the Apache OpenOffice Calc application? > > >> I don't have Word or >> Excel on my PC now. > > > Lucky guy. I have both on my job computer and I hate both. > > I miss that function. > > > You said you could find it (in your ods file), or did you mean something > else? Like what? > > >> I have Open Office version 4.1.6. >> Does that have the function I want? I've checked all the options at the >> top >> and can't find that function. Am I just missing seeing it? Please help >> because I miss that function. Thank you. >> > > Okay, jokes aside, can you please better describe what that ”function” > actually did? I don't really understand what ”add certain lines to a total” > means. Certain lines? To a total? How? Can you give a simple example? What > is the function called in Excel? > > I'm sure that if the function doesn't exist in Calc, it's possible to make > one with a macro, but I can't tell how complicated that would be unless I > have more information. > > > Kind regards > > Johnny Rosenberg >
Re: please help
Den tors 10 okt. 2019 kl 14:47 skrev Dave Bito'o'wu Pratt < nostradumbas...@gmail.com>: > This will be the fourth try at attempting to contact you. You don't make it > easy. The following is my original message. > What was the other three attempts? Writing to this list or what? And who are you referring to when you say ”you”? There is no Apache OpenOffice support. This list is just users helping other users. I'm one of those users (I'm actually an ex user, but that's hopefully not very important) and some times I ask questions and some times I answer questions, just like most people on the list. > I used to use Word up until about 10 years ago when somebody suggested Open > Office to me. I much prefer this to Word. I prefer a hex editor over Word… > I do have one issue though. I > used Excel a lot. They had a function where I could add certain lines to a > total. On your .ods file, I can find that function. You can? That's great. Doesn't the mean that the problem is solved? I just wonder how you could find it in the ods file. Shouldn't you rather look in the Apache OpenOffice Calc application? > I don't have Word or > Excel on my PC now. Lucky guy. I have both on my job computer and I hate both. I miss that function. You said you could find it (in your ods file), or did you mean something else? Like what? > I have Open Office version 4.1.6. > Does that have the function I want? I've checked all the options at the top > and can't find that function. Am I just missing seeing it? Please help > because I miss that function. Thank you. > Okay, jokes aside, can you please better describe what that ”function” actually did? I don't really understand what ”add certain lines to a total” means. Certain lines? To a total? How? Can you give a simple example? What is the function called in Excel? I'm sure that if the function doesn't exist in Calc, it's possible to make one with a macro, but I can't tell how complicated that would be unless I have more information. Kind regards Johnny Rosenberg
Re: please help
My responses are given in-line with your original message. Original Message From: Dave Bito'o'wu Pratt [mailto:nostradumbas...@gmail.com] Sent: Thursday, October 10, 2019, 12:19 UTC To: users@openoffice.apache.org Subject: please help > This will be the fourth try at attempting to contact you. You don't make it > easy. Not sure how much easier it could be made. Go to the home page of the website; http://www.openoffice.org/ and right there in the middle of the page there is a link that reads: "I need help with my OpenOffice. Help is at hand whenever you need it." > The following is my original message. > I used to use Word up until about 10 years ago when somebody suggested Open > Office to me. I much prefer this to Word. I do have one issue though. I > used Excel a lot. They had a function where I could add certain lines to a > total. On your .ods file, I can find that function. I don't have Word or > Excel on my PC now. I miss that function. I have Open Office version 4.1.6. > Does that have the function I want? I've checked all the options at the top > and can't find that function. Am I just missing seeing it? Please help > because I miss that function. Thank you. You say "I can find that function.", but it sounds like you mean that you cannot find the equivalent function in Calc. Can you recall what the function might be called in Excel? A function to "add certain lines to a total" doesn't give us much to go on, so can you provide a more detailed description of how the function worked, or outline the steps you took when using that function? Please address any reply to the users@openoffice.apache.org mailing list only. Any messages sent to this noreply@ address are automatically deleted from the server and will never be read. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help me
At 16:34 05/12/2017 -0800, Howard Blum wrote: I must confess, I am spoiled as a very long term Apple Mac user ... I sympathise ... ... and if I cannot figure out how to use an application without looking for a user's guide or manual I tend to walk away from the application and try another. I agree. I thought of buying a car, but discovered that one has to take driving lessons and pass a test and learn all about licences and insurance, so I gave up. And I was tempted to invest in a piano, but again it seems I would have to take lessons in order to be able to play it ... Having said that, I love this application suite ... Good: we agree on that. But I espouse learning. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help me
I must confess, I am spoiled as a very long term Apple Mac user and if I cannot figure out how to use an application without looking for a user's guide or manual I tend to walk away from the application and try another. Having said that, I love this application suite much better than MS Office. Okay, so it does not have some items we have become used to in their suite of apps, but no biggie as far as I can tell. Thanks again for such a great apps. On Tue, Dec 5, 2017 at 4:28 PM, Martin Groenescheij wrote: > > > On 06/12/17 6:07 AM, Ella Oblas wrote: > >> I just learned by trial and error that what I have saved is considered a >> "picture" and not a document. >> > > OK, the good news is that you learn from your mistakes, now you have to > learn that hijacking someone else message is a bad habit. > If you want help start a new email which makes it easier to archive by > subject and by the way" please help me" is not a descriptive subject. > > Could you be searching for a document that the computer deemed a "picture"? >> > > For a computer a document can be anything e.g. a Word document, a Drawing, > a Spreadsheet or a Photo. > The computer rely on the users to define the type of document e.g. .doc, > .odt, .pdf or .jpg > Most applications saves with the correct file type, but allow to change it > by the user. > > >> >> Ella >> >> >> >> From: Diane >> Sent: Tuesday, December 5, 2017 12:01 PM >> To: users@openoffice.apache.org >> Subject: please help me >> >> Hello, >> I use Apache Open Office and would like to insert the file/path into the >> document so I know where it is next time. I’ve tried going to insert, >> fields, other, file name (type), path/file name (format) and insert. When I >> do this I don’t get the path and file name – all I get is “path/file name” >> added but that’s not what I need. How do I add the proper file name of my >> document that I just typed? >> >> Thanks so much. >> >> Diane >> dixiedi...@gforcecable.com >> >> >> > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > -- Howard Blum Pro Mobile Notary PO Box 834 Novato, CA 94948 415-898-4130 http://pro-mobile-notary.com
Re: please help me
On 06/12/17 6:07 AM, Ella Oblas wrote: I just learned by trial and error that what I have saved is considered a "picture" and not a document. OK, the good news is that you learn from your mistakes, now you have to learn that hijacking someone else message is a bad habit. If you want help start a new email which makes it easier to archive by subject and by the way" please help me" is not a descriptive subject. Could you be searching for a document that the computer deemed a "picture"? For a computer a document can be anything e.g. a Word document, a Drawing, a Spreadsheet or a Photo. The computer rely on the users to define the type of document e.g. .doc, .odt, .pdf or .jpg Most applications saves with the correct file type, but allow to change it by the user. Ella From: Diane Sent: Tuesday, December 5, 2017 12:01 PM To: users@openoffice.apache.org Subject: please help me Hello, I use Apache Open Office and would like to insert the file/path into the document so I know where it is next time. I’ve tried going to insert, fields, other, file name (type), path/file name (format) and insert. When I do this I don’t get the path and file name – all I get is “path/file name” added but that’s not what I need. How do I add the proper file name of my document that I just typed? Thanks so much. Diane dixiedi...@gforcecable.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help me
I just learned by trial and error that what I have saved is considered a "picture" and not a document. Could you be searching for a document that the computer deemed a "picture"? Ella From: Diane Sent: Tuesday, December 5, 2017 12:01 PM To: users@openoffice.apache.org Subject: please help me Hello, I use Apache Open Office and would like to insert the file/path into the document so I know where it is next time. I’ve tried going to insert, fields, other, file name (type), path/file name (format) and insert. When I do this I don’t get the path and file name – all I get is “path/file name” added but that’s not what I need. How do I add the proper file name of my document that I just typed? Thanks so much. Diane dixiedi...@gforcecable.com
Re: please help me
On Tue, 5 Dec 2017 12:01:00 -0500 "Diane" wrote: > Hello, > I use Apache Open Office and would like to insert the file/path into the > document so I know where it is next time. I’ve tried going to insert, fields, > other, file name (type), path/file name (format) and insert. When I do this I > don’t get the path and file name – all I get is “path/file name” added but > that’s not what I need. How do I add the proper file name of my document that > I just typed? > > Thanks so much. > > Diane > dixiedi...@gforcecable.com > Toggle /View /Field names. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
On 19.09.2017 12:26, N Ladhu wrote: > Dear Support Team, > > I have used open office for a number of years and now predominantly use it > for work documents. > > I use OpenOffice on my MacBook Pro 13” running on Mac OS Sierra Version > 10.12.6. > > Open Office sadly crashed and I now cannot edit or save changes or convert > any documents and even have to open them in an odd way. > > This is due to any actions being blocked by a pop up message that will not go > away. > > The message is as follows: > > "The last time you opened OpenOffice, it unexpectedly quit while reopening > windows. > Do you want to try to reopen its windows again?” > > "If you choose not to reopen windows, you may have to open and position the > windows yourself." > > Regardless of whether I select Open or Don’t Reopen the message does not > respond and stays on the screen. > > I Googled the error and found many other users have had the same issue but > their suggestions to fix it aren’t applicable. > > I would really appreciate if you could kindly advise ASAP. > > Many thanks. > > Kind regards, > > Narikai You need to delete the folder "org.openoffice.script.savedState". It is in the "Saved Application State" folder in your User/Library. See this post on the user forum for detailed instructions: https://forum.openoffice.org/en/forum/viewtopic.php?f=17&t=55755#p244931 -- Please address any reply to the mailing list only. Any messages sent to this noreply@ address are automatically deleted from the server and will never be read. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
hello did you have backup of your file? or saved informations before crashing? see openoffice tools, options, load-save, general save auto recovery information every and also always create backup copy. windows has the option for recovery of file and restore to the previous state, i believe that mac also should has such option or at least free external application for recovery lost data! hope that help, God bless you and his infinite mercy be for you. On 9/19/17, N Ladhu wrote: > Dear Support Team, > > I have used open office for a number of years and now predominantly use it > for work documents. > > I use OpenOffice on my MacBook Pro 13” running on Mac OS Sierra Version > 10.12.6. > > Open Office sadly crashed and I now cannot edit or save changes or convert > any documents and even have to open them in an odd way. > > This is due to any actions being blocked by a pop up message that will not > go away. > > The message is as follows: > > "The last time you opened OpenOffice, it unexpectedly quit while reopening > windows. > Do you want to try to reopen its windows again?” > > "If you choose not to reopen windows, you may have to open and position the > windows yourself." > > Regardless of whether I select Open or Don’t Reopen the message does not > respond and stays on the screen. > > I Googled the error and found many other users have had the same issue but > their suggestions to fix it aren’t applicable. > > I would really appreciate if you could kindly advise ASAP. > > Many thanks. > > Kind regards, > > Narikai -- we have not sent you but as a mercy to the entire creation. holy quran, chapter 21, verse 107. in the very authentic narration from prophet Mohammad is: indeed, imam husayn is the beacon of guidance and the ark of salvation. best website for studying islamic book in different languages www.al-islam.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help me :-)
> On Apr 8, 2017, at 12:34, cres...@aol.com wrote: > > I need your help. You see I am a disable person and unable open .pptx files > for my wife in her email attachments. I am an openoffice user for many years > and basically use the word processor and spreadsheet app. Do you have any > suggestions on what I should download or add to my openoffice…. You don't tell us what operating system you are using, but in general this should work: Right click on the .pptx file and select Open With - OpenOffice [select 'always use for this file type if offered]. Julian Thomas - http://jt-mj.net “Power concedes nothing without a demand. It never did and it never will.” ― Frederick Douglass - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: PLEASE HELP WITH THIS-ODT FILE WAS ALTERED AND IS NOW CORRRUPTED
On 10/03/17 1:10 AM, Ash Ash wrote: If you remember nothing else from this guide, please make sure you remember this. Whenever you ask for technical support, make absolutely sure you state the following: 1) Which version of OpenOffice.org you are running. Open office 4.1.2 2) What your operating system is (for example, Windows XP). Windows XP 3) If there is an error, state clearly what it is and how we can reproduce it. When the documed was opened a message from ASCII filter popped up. After that the file was not readable. 4) Do not attach files to mail messages. We absolutely need you to include this information before we can help you From: Ash Ash Sent: 09 March 2017 13:55:59 To: users@openoffice.apache.org Subject: PLEASE HELP WITH THIS-ODT FILE WAS ALTERED AND IS NOW CORRRUPTED Hi, This morning when I opened my odt file there was a message from ASCII Filter and I mistakenly clicked yes. It appears this had modified the actual text content or just changed the text style from english to some other style format. The file is now opens in square symbols and it is unintelligable to read. There is nothing in english. The whole file has been altered. This file is for work so it is very important the work is not list. The ASCII Filter can't interpret the character set used in the document, this is because your file is corrupt. Most likely this happens when your system is shut down before OpenOffice was able to write everything to disk. Keep in mind that OpenOffice compresses all files which takes some processing time. Am not sure if the contents have disappeared or just the english has changed to some other style format and so the work is retrievable. I need the restored version from yesterday 8/3/2017 around 5:09 pm which is the version it was before I opened the file this morning. Under Tools -> Options -> Load/Save -> General there is an option to create backup's Backups are stored in the directory set under Tools -> Options -> OpenOffice -> Paths Please can you have a look at the file and if you are able to restore please do so. The file is attached to this email. I very much appreciate your help in this matter. I have very little to no understanding of this type of stuff so have no idea what must be done. Thank you Naj - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: PLEASE HELP WITH THIS-ODT FILE WAS ALTERED AND IS NOW CORRRUPTED
If you remember nothing else from this guide, please make sure you remember this. Whenever you ask for technical support, make absolutely sure you state the following: 1) Which version of OpenOffice.org you are running. Open office 4.1.2 2) What your operating system is (for example, Windows XP). Windows XP 3) If there is an error, state clearly what it is and how we can reproduce it. When the documed was opened a message from ASCII filter popped up. After that the file was not readable. 4) Do not attach files to mail messages. We absolutely need you to include this information before we can help you From: Ash Ash Sent: 09 March 2017 13:55:59 To: users@openoffice.apache.org Subject: PLEASE HELP WITH THIS-ODT FILE WAS ALTERED AND IS NOW CORRRUPTED Hi, This morning when I opened my odt file there was a message from ASCII Filter and I mistakenly clicked yes. It appears this had modified the actual text content or just changed the text style from english to some other style format. The file is now opens in square symbols and it is unintelligable to read. There is nothing in english. The whole file has been altered. This file is for work so it is very important the work is not list. Am not sure if the contents have disappeared or just the english has changed to some other style format and so the work is retrievable. I need the restored version from yesterday 8/3/2017 around 5:09 pm which is the version it was before I opened the file this morning. Please can you have a look at the file and if you are able to restore please do so. The file is attached to this email. I very much appreciate your help in this matter. I have very little to no understanding of this type of stuff so have no idea what must be done. Thank you Naj
Re: Please help. Having problems with Calc
Hi Scott, Scott Bennett schrieb: My wife has used Calc for years to keep track of highly detailed tax data for our business. This week she was entering info on a certain sheet (she has multiple sheets) and it was entering that same info on sheet number one. When she deleted a row from sheet number 3, it deleted it from sheet number 1. We lost a bunch of data this way...actually all of the sheets are behaving as one sheet. Please let me know how we resolve this. This is a fresh install of OO on a Windows 10 laptop. Perhaps you had accidentally selected all sheets? You should try work-flow again with a test document. Kind regards Regina - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help. Having problems with Calc
hello. i encourage you to make backup from your essential documents. did you try undo for your unwanted changes to return to its previous normal states? thanks so much for your asking. hope that helps and god bless you. On 4/8/16, Dan Lewis wrote: > On 04/07/2016 05:48 PM, Scott Bennett wrote: >> My wife has used Calc for years to keep track of highly detailed tax data >> for our business. This week she was entering info on a certain sheet (she >> has multiple sheets) and it was entering that same info on sheet number >> one. When she deleted a row from sheet number 3, it deleted it from sheet >> number 1. We lost a bunch of data this way...actually all of the sheets >> are >> behaving as one sheet. Please let me know how we resolve this. This is a >> fresh install of OO on a Windows 10 laptop. >> >> Thanks >> Scot >> > This is one reason why you should have used a database for your record. > > Dan > -- Those who follow the Messenger-Prophet, the Ummi, whom they find written down with them in the Taurat and the Injeel [who] enjoins them good and forbids them evil, and makes lawful to them the good things and makes unlawful to them impure things, and removes from them their burden and the shackles which were upon them; so [as for] those who believe in him and honor him and help him, and follow the light which has been sent down with him, these it is that are the successful. holy quran, chapter 7, verse 157. best website for studying islamic book in different languages al-islam.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help. Having problems with Calc
On 04/07/2016 05:48 PM, Scott Bennett wrote: My wife has used Calc for years to keep track of highly detailed tax data for our business. This week she was entering info on a certain sheet (she has multiple sheets) and it was entering that same info on sheet number one. When she deleted a row from sheet number 3, it deleted it from sheet number 1. We lost a bunch of data this way...actually all of the sheets are behaving as one sheet. Please let me know how we resolve this. This is a fresh install of OO on a Windows 10 laptop. Thanks Scot This is one reason why you should have used a database for your record. Dan
Re: Please help. Having problems with Calc
If you have selected multiple sheets either by purpose or accidentally data entries or changes are done on all selected sheets. This can be handy if you like to enter formulas on multiple sheets, but as you experienced it can be a disaster when you're not aware of it. Sent from my mobile device. > On 8 Apr 2016, at 7:48 AM, Scott Bennett wrote: > > My wife has used Calc for years to keep track of highly detailed tax data > for our business. This week she was entering info on a certain sheet (she > has multiple sheets) and it was entering that same info on sheet number > one. When she deleted a row from sheet number 3, it deleted it from sheet > number 1. We lost a bunch of data this way...actually all of the sheets are > behaving as one sheet. Please let me know how we resolve this. This is a > fresh install of OO on a Windows 10 laptop. > > Thanks > Scot > > -- > Fresh Day Music > Scott Michael Bennett > Heather Louise Bennett---much-loved wife & concert manager > P.O. Box 397 > Stevensville, MI 49127 > 269.588.1107 > www.scottmichaelbennett.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
> On Jan 11, 2016, at 23:04, Dale Erwin wrote: > > I submit that no set of computer-generated numbers is truly random. > Pseudo-random is the best you can hope for. True if it's strictly an algorithmic process. Not necessarily true if you introduce variability from external sources [ping or response time on the network, or stock market fluctuations for example]. Pseudo random implies repeatability. In a prior life I came up with a scheme for a pseudorandom generator that used computer hardware measured values determined at power on to generate a non-repeatable seed. I think we are converging on violent agreement! — jt - j...@jt-mj.net If it screams, it's not food... Yet. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
On 1/11/2016 7:50 PM, John Hart wrote: On 1/11/2016 2:59 PM, Julian Thomas wrote: On Jan 11, 2016, at 16:13, Peter Koch wrote: I am trying to generate random numbers without duplicate numbers being generated. Mathematicians will tell you that a set of numbers isn't truly random if duplicates are disallowed. You seem to want a random ordering of the integers in the range. Power Ball tickets don't have space for duplicate numbers Mathematicians, Shmathematicians, I submit that no set of computer-generated numbers is truly random. Pseudo-random is the best you can hope for. Dale Erwin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/01/2016 21:13, Peter Koch wrote: > I am trying to generate random numbers without duplicate numbers being generated. Grab the spreadsheet Inglenook.OTS, that should be linked to this email, and downloadable from Box.com. An older, but working version can be found at https://groups.io/g/ODF_Templates/files/Model%20Railroading I think that https://www.dropbox.com/s/n2k6zd4wxjigu8w/inglenook.ods?dl=0 contains a working version. On the page "IQ" is one solution to generating a sequence of random numbers, without duplicating any numbers. For your specific use-case, change the random number multiplier to 69, from whatever the formula uses. Then, if there are less than 69 numbers in the initial column, increase the number to 69, and create additional rows, and columns, as needed. In essence, you need to add one column, for every row that is added. It might take as much as an hour or so playing with the spreadsheet, and studying the formulas, to understand what it is doing. jonathon -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (GNU/Linux) iQIcBAEBAgAGBQJWlHnbAAoJEKG7hs8nSMR7ECMQAIAKs1Rjvza05lr0z1nERQfa +dLdKqh/QVoTdX+y237zuuy2GZSU+cybC68lWzkmilDmj3LOxLXUi+baaHArH4Ds kNsA4mNCF0YuUixB5QG/4MuXd0JORLKwBZMDH5pZ1i8qcv1U349Zknsy/WmX5m3g ASoRKvkhbLWdb7Kqr5NLaZI2vBlOA2vJJCLCQ9CAc0+FvnxJeupuNVsjacmW091e PFnfpvEIrSNl1U+bkHTSHD1kuLSZifYYST4N99tEX34xylwj6Fs6S6BOc2IMQqph tzkjlAEbbWSRINRsnbQehQQw3JD9mVpCfUgZYSfEzKy7Fx5zxCLmKJhGJahs2oFE 8W0wdq0ZwzC2ep/ubE7ORi/IK6U3IUaiU8NzZ35/aA/FNqaoeQfHigylFO0it5aX +b/wCCozjKftnAD3JHWP1pyM4x9kL7yEVWGuU93rC5ezLQoA6iz/alCJF781tT3H pORs2fJOhUe2LaeJYTa6Tlk1bvizIA2nbI+1moMGdmuxju/6iekG01c4QwRVCmBQ FLDf7UPFumZEWPRbWVXfE4b2/IAqIS32MMumD054Fv6Z+H71o0PPTgog6Qz9LJL4 8UxhXA1OS26bHeBkDSmVLHyAQmnMEyEm9TDifc5O2ppdkwUS1F3GuhteRLI4XCDB A5XPcgknfE1q1nEglOU8 =Zzrz -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
On 1/11/2016 2:59 PM, Julian Thomas wrote: On Jan 11, 2016, at 16:13, Peter Koch wrote: I am trying to generate random numbers without duplicate numbers being generated. Mathematicians will tell you that a set of numbers isn't truly random if duplicates are disallowed. You seem to want a random ordering of the integers in the range. Power Ball tickets don't have space for duplicate numbers - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
> On Jan 11, 2016, at 16:13, Peter Koch wrote: > > I am trying to generate random numbers without duplicate numbers being > generated. Mathematicians will tell you that a set of numbers isn't truly random if duplicates are disallowed. You seem to want a random ordering of the integers in the range. — jt - j...@jt-mj.net Switching is a science, Radio is an art. Grounding is Black Magic. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please Help
At 21:13 11/01/2016 +, Peter Koch wrote: I am trying to generate random numbers without duplicate numbers being generated. Can you help me with a formula. I am using the numbers 1 through 69. This is the same idea as dealing cards from a shuffled pack. So all you need to do is take the set of numbers, shuffle them, and use as many as you require from the start of the shuffled list. o Enter 1 into a spreadsheet cell. o Fill down the column to 69. o In a parallel column, enter =RAND() and fill that down too. o Select both columns of cells. o Go to Data | Sort... and sort on the column of random numbers. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help
Couldn't we, as I and others have suggested, write a routine (maybe call it Reset Profile) that resets a user's profile? This problems has taken up more space & energy than any other, and seems so simply (on the surface, anyway) to solve once and for all. Maurice On Sun, Jun 28, 2015 at 12:16 AM, Rory O'Farrell wrote: > On Sat, 27 Jun 2015 16:19:46 -0600 > "Norma Tech" wrote: > > > I don’t know what I have done, but spellcheck is not working in my Open > Office program. Can you help me? > > > > Norma Tech > > nht_t...@yahoo.com > > > > > You should start by deleting or renaming your OpenOffice user profile. As > you are using Windows do this by: > Close OpenOffice and the Quickstarter. Open File Explorer. Copy and paste > %appdata%\OpenOffice\4 in the File Explorer Address Bar and press Enter. > Rename the "user" folder. Start OpenOffice. > -- > Rory O'Farrell > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
Re: Please help
On Sat, 27 Jun 2015 16:19:46 -0600 "Norma Tech" wrote: > I don’t know what I have done, but spellcheck is not working in my Open > Office program. Can you help me? > > Norma Tech > nht_t...@yahoo.com > > You should start by deleting or renaming your OpenOffice user profile. As you are using Windows do this by: Close OpenOffice and the Quickstarter. Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer Address Bar and press Enter. Rename the "user" folder. Start OpenOffice. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please, help me!
On Thu, 16 Oct 2014 17:43:21 +0200 Britt Jonsson wrote: > I,m happily working with OpenOffice 4.1.1. Thank you. Now, I, howerver, have > a problem: > > Suddenly, all my 200 pages are underlined with the red sicksack line that > appears when words are wrongly spelt! What happened? And please, let me know > how to solve this problem. I know how to take it away under single worls - > by using the ignore-buttom - but not from a all my document. > > Sorry for my English, I however hope you will understand my problem. > > With kind regards, > Britt Jonsson > Patentgatan 9 > 11267 Stockholm > Swedenbrittejons...@hotmail.com > Start by deleting or renaming (best course) your OpenOffice User profile. Details are given in these postings https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426 -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Fwd: Re: please help me. I am trying to get a Microsoft wps email open in open office in English instead of the gibbage it is in now. am not computer smart and need all thehelp I can get.thanks marcy
Forwarded to poster as he isn't subscribed Original Message Subject: Re: please help me. I am trying to get a Microsoft wps email open in open office in English instead of the gibbage it is in now. am not computer smart and need all thehelp I can get.thanks marcy Date: Wed, 03 Sep 2014 01:11:00 -0500 From: Dale Erwin Reply-To: users@openoffice.apache.org To: users@openoffice.apache.org On 9/3/2014 12:51 AM, marcu...@yahoo.com.INVALID wrote: Microsoft Works is not the same as Microsoft Office. In fact it has been discontinued. However, there is a file converter which might be able to convert your file to a Microsoft Office file and then you can open it. If you want to try that, I saw it here: http://www.microsoft.com/en-us/download/details.aspx?id=12 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: please help me. I am trying to get a Microsoft wps email open in open office in English instead of the gibbage it is in now. am not computer smart and need all thehelp I can get.thanks marcy
On 9/3/2014 12:51 AM, marcu...@yahoo.com.INVALID wrote: Microsoft Works is not the same as Microsoft Office. In fact it has been discontinued. However, there is a file converter which might be able to convert your file to a Microsoft Office file and then you can open it. If you want to try that, I saw it here: http://www.microsoft.com/en-us/download/details.aspx?id=12 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help me resolve this problem
On Sun, 17 Aug 2014 11:46:50 -0600 jd1008 wrote: > > On 08/17/2014 05:59 AM, Kathryn Silverton wrote: > > Greetings, > > > > How do I correct the following: > > > > There is a red underscore under every word, even when it is spelled > > correctly. The only way I have found to get rid of it is to go to > > Tools > > Language > > For all text > > None > > > > This disables spell check completely. > > > > Seeing the red underscore under every word is annoying and not helpful. > > > > Thank you most kindly. Other than this issue, I very much enjoy using > > Open Office. > > > > Sincerely, > > > > kathryn > Katheryn, > The list members would be able to be of better help if you > included in your question the application that is red-underlining > the words that you type. I'm informed by private email that the problem was solved by deleting or renaming the OpenOffice User Profile. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help me resolve this problem
On 08/17/2014 05:59 AM, Kathryn Silverton wrote: Greetings, How do I correct the following: There is a red underscore under every word, even when it is spelled correctly. The only way I have found to get rid of it is to go to Tools Language For all text None This disables spell check completely. Seeing the red underscore under every word is annoying and not helpful. Thank you most kindly. Other than this issue, I very much enjoy using Open Office. Sincerely, kathryn Katheryn, The list members would be able to be of better help if you included in your question the application that is red-underlining the words that you type. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please help me resolve this problem
On Sun, 17 Aug 2014 07:59:19 -0400 Kathryn Silverton wrote: > Greetings, > > How do I correct the following: > > There is a red underscore under every word, even when it is spelled > correctly. The only way I have found to get rid of it is to go to > Tools > Language > For all text > None > > This disables spell check completely. > > Seeing the red underscore under every word is annoying and not helpful. > > Thank you most kindly. Other than this issue, I very much enjoy using > Open Office. > > Sincerely, > > kathryn A very large proportion of spellcheck problems in OpenOffice are cured by deleting or renaming the OpenOffice User Profile Details about the User Profile are given in https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426 If this does not work, please bring your problem to the OpenOffice Forum at https://forum.openoffice.org/en/forum/ -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Please HELP........GRAPHICS OFF
On Tue, 27 May 2014 16:54:13 -0500 Sapper wrote: > I tried OO and no graphics appear. > I cannot find a graphics icon to turn it on > > What do I do. > Cannot copy anything to Oo??? > > Please help > > Thank you, > Ron If using Writer /Tools /Options/ OpenOffice Writer : Display : View - Graphics and objects to be checked (/Options is under Preferences on a Mac) -- Rory O'Farrell --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: PLEASE help with templates!
Neil and Ann Robertson wrote: I want to use standard Avery Inkjet labels 21 to a page 63.5 mm x 38.1 mm code 905068 I have been unable to find a template for this in open Office ... I am sure Open Office must have these Sure it does. Start OpenOffice, then File - New - Labels, set the correct brand and type and then "New Document". If you need a screenshot, here you go: http://imagebin.org/239579 (set "Continuous" instead of "Sheet" if you have a single label) Regards, Andrea. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org