Re: I need help!
At 13:37 12/04/2021 -0500, Kristi Nelson wrote: Where can I find this? "When saving, in the Export Text File dialogue, ensure "Quote all text cells" is ticked." I don't see that when I "save as"... If you have an existing .csv file, OpenOffice assumes you want the same settings, so doesn't ask. When you use File | Save As..., you need to tick "Edit filter settings" at the foot of the Save As dialogue to stimulate the dialogue you need. 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: I need help!
I did that and it worked, but when I save it as a csv again, it reverts back to keeping off the leading zeros. I need the file to be saved as a csv for the program we are using. How can I keep the formatting as text? On Mon, Apr 12, 2021 at 1:06 PM JACKSON wrote: > Try formatting the cells containing zip codes as text. > > > On Apr 12, 2021, at 1:13 PM, Kristi Nelson > wrote: > > > > Hello. I have a csv file that I am trying to edit in openoffice so the > > leading zeros (for zipcodes) in the file appear. I am able to get that > > accomplished in open office, but once I save as a csv file again, it > > reverts back to the original file where they are hidden. Can someone > please > > help me with this? > > > > Thank you! > > Kristi N. > > kristinelso...@gmail.com > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > >
Re: I need help!
At 12:13 12/04/2021 -0500, Kristi Nelson wrote: I have a csv file that I am trying to edit in openoffice so the leading zeros (for zipcodes) in the file appear. The first question you need to answer is why you need to keep the data in .csv format. If you save your document as a spreadsheet, your problem will disappear. I am able to get that accomplished in open office, but once I save as a csv file again, it reverts back to the original file where they are hidden. Can someone please help me with this? If you have to use .csv format (and I'm yet to be convinced that you do), the solution is simple: o Ensure the cells containing your codes are formatted as Text. o When saving, in the Export Text File dialogue, ensure "Quote all text cells" is ticked. o When reopening, in the Text Import dialogue, under "Other options", ensure "Quoted field as text" is ticked. 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: I need help!
One solution is to changes the leading zeros to upper case letter O. Not an ideal solution, but the problem is with the CSV formatter, which treats zip codes as an arithmetic number, where leading zeros have no arithmetic value, so they are omitted. On Mon, Apr 12, 2021 at 11:47 AM Kristi Nelson wrote: > Hello. I have a csv file that I am trying to edit in openoffice so the > leading zeros (for zipcodes) in the file appear. I am able to get that > accomplished in open office, but once I save as a csv file again, it > reverts back to the original file where they are hidden. Can someone please > help me with this? > > Thank you! > Kristi N. > kristinelso...@gmail.com >
I need help!
Hello. I have a csv file that I am trying to edit in openoffice so the leading zeros (for zipcodes) in the file appear. I am able to get that accomplished in open office, but once I save as a csv file again, it reverts back to the original file where they are hidden. Can someone please help me with this? Thank you! Kristi N. kristinelso...@gmail.com
Re: I need help with an Open Office Writer task.
Hi Linda, maybe changing the "After" default in menu item Format->Numbering on the tabpage Options might do what you want. Kind regards, Joost Am 05.12.2020 um 19:27 schrieb Linda Hull: I have Open Office 4.1.6 on Windows 10. I opened an archive with 7Zip, and in it, I have several files. Each file is a book of an Aramaic translation to English, of the Bible, having several chapters. Each chapter has verses numbered 1. 2. 3. etc. In order to use the files in an IRC Eggdrop bot, we need them to be 1:1. 1:2. 1:3. and so on, for each chapter, so 12:1. 12:2. 12:3. etc etc. There are twenty-seven books in the New Testament of a standard Christian King James Bible, and that is 260 chapters, about 7,958 verses (varies by translation). This is a formidable task. Is there a way to use OpenOffice to automatically insert the correct Chapter numberings? An example, showing a Chapter break: 28. Him whom we preach; and we teach and we educate every person in all wisdom, to confirm every person as perfected in Yeshua The Messiah; 29. For in this I also labor and fight with the help of the power that is given to me. Colossians Chapter 2 1. But I want you to know what struggles I have for you and for those in Laidiqia and for those others who have not seen my face in the flesh, * The material is not really .txt it is a series of Word documents. I hope you can help? Thanks a lot! Linda - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
I need help with an Open Office Writer task.
I have Open Office 4.1.6 on Windows 10. I opened an archive with 7Zip, and in it, I have several files. Each file is a book of an Aramaic translation to English, of the Bible, having several chapters. Each chapter has verses numbered 1. 2. 3. etc. In order to use the files in an IRC Eggdrop bot, we need them to be 1:1. 1:2. 1:3. and so on, for each chapter, so 12:1. 12:2. 12:3. etc etc. There are twenty-seven books in the New Testament of a standard Christian King James Bible, and that is 260 chapters, about 7,958 verses (varies by translation). This is a formidable task. Is there a way to use OpenOffice to automatically insert the correct Chapter numberings? An example, showing a Chapter break: 28. Him whom we preach; and we teach and we educate every person in all wisdom, to confirm every person as perfected in Yeshua The Messiah; 29. For in this I also labor and fight with the help of the power that is given to me. Colossians Chapter 2 1. But I want you to know what struggles I have for you and for those in Laidiqia and for those others who have not seen my face in the flesh, * The material is not really .txt it is a series of Word documents. I hope you can help? Thanks a lot! Linda
Re: I need help please
Dave, Thank you for your prompt and helpful reply. For you information I was still unable, even after following your instruction, to register or log on to the user community forum. I have been successful in following your link to the spoken tutorials which I am finding quite helpful. Thanks again for your help. Wayne Cameron On Sun, Mar 8, 2015 at 1:14 PM, Dave Barton d...@tasit.net wrote: Original Message From: Wayne Cameron dunro...@gmail.com To: users@openoffice.apache.org Date: Sun, 8 Mar 2015 12:17:54 -0400 I'm new to data base and am struggling to teach myself how to use it. I would like to participate in a community forum, so I could ask a question to help me over humps. How can I do this please? I may have registered, long ago, I don't remember. Unfortunately I am now unable to either register or log in, so I really need help please. Wayne Cameron Hi Wayne, You are welcome to ask questions here on this list. To do that it would be best if you subscribed to the list: https://openoffice.apache.org/mailing-lists.html#users-mailing-list-public otherwise you may miss replies from other subscribers. You can also access the list through other services, for example: nabble http://openoffice.2283327.n4.nabble.com/Users-f2814619.html gmane http://dir.gmane.org/index.php?prefix=gmane.comp.openoffice To use the forum you can register, or possibly recover your original registration: https://forum.openoffice.org/en/forum/ The Registration link is towards the top right hand corner of that page. If you are having difficulty see this page: https://forum.openoffice.org/en/forum/viewtopic.php?f=50t=527 Some additional links to useful Base information can be found here: http://www.tutorialsforopenoffice.org/category_index/base.html Hope this helps. Dave
Re: I need help please
I am also interested in possibly using Forum. Am using a Win 8.x machine. Mailing List replies have been very helpful to me, but I believe that Forum may have additional value, such as screenshot uploads, etc. Regards, Vince_B. Sent from my iPad On Mar 8, 2015, at 12:17, Wayne Cameron dunro...@gmail.com wrote: I'm new to data base and am struggling to teach myself how to use it. I would like to participate in a community forum, so I could ask a question to help me over humps. How can I do this please? I may have registered, long ago, I don't remember. Unfortunately I am now unable to either register or log in, so I really need help please. Wayne Cameron
Re: I need help please
Original Message From: Wayne Cameron dunro...@gmail.com To: users@openoffice.apache.org Date: Sun, 8 Mar 2015 12:17:54 -0400 I'm new to data base and am struggling to teach myself how to use it. I would like to participate in a community forum, so I could ask a question to help me over humps. How can I do this please? I may have registered, long ago, I don't remember. Unfortunately I am now unable to either register or log in, so I really need help please. Wayne Cameron Hi Wayne, You are welcome to ask questions here on this list. To do that it would be best if you subscribed to the list: https://openoffice.apache.org/mailing-lists.html#users-mailing-list-public otherwise you may miss replies from other subscribers. You can also access the list through other services, for example: nabble http://openoffice.2283327.n4.nabble.com/Users-f2814619.html gmane http://dir.gmane.org/index.php?prefix=gmane.comp.openoffice To use the forum you can register, or possibly recover your original registration: https://forum.openoffice.org/en/forum/ The Registration link is towards the top right hand corner of that page. If you are having difficulty see this page: https://forum.openoffice.org/en/forum/viewtopic.php?f=50t=527 Some additional links to useful Base information can be found here: http://www.tutorialsforopenoffice.org/category_index/base.html Hope this helps. Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I Need Help
On 08/12/14 05:11, Brian Barker wrote: Odds are, it is a language dictionary mismatch. What dictionaries are installed? What language does Apache OpenOffice think that the document is written in? For what it's worth, this is surely not true? When the language detection routine misfires, everything is flagged as a spelling error. jonathon - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I Need Help
At 19:58 11/12/2014 +, Toki Jonathon Kantoor wrote: On 08/12/14 05:11, Brian Barker wrote: [Toki Jonathon Kantoor wrote:] Odds are, it is a language dictionary mismatch. What dictionaries are installed? What language does Apache OpenOffice think that the document is written in? For what it's worth, this is surely not true? When the language detection routine misfires, everything is flagged as a spelling error. I'm not at all sure what you are suggesting here. OpenOffice is neither a gun nor an engine, so it won't commonly misfire. And if software does go wrong, you can hardly predict what it will do. We all know that if OpenOffice thinks it has the appropriate dictionary installed, a corrupted user profile can prevent it operating correctly and make it flag all words as misspelled. (And the original questioner confirmed that this was his problem and solution, in fact.) But that's a language *match*, not a mismatch. In the case of a mismatch - surely where there is no dictionary to match the declared language? - nothing is flagged. Even though one could expect it to, simply not having the correct dictionary installed does not create this error. Unless you've seen reports of behaviour the rest of us haven't, that is ... You talk about a language detection routine as if this sets the language for text, but surely it limits itself to the languages it offers in the Status Bar and the menus? Since it doesn't itself set the language, it cannot affect any flagging of supposedly misspelled words. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I Need Help
On 06/12/14 20:20, smithphillip wrote: I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. Odds are, it is a language dictionary mismatch. What dictionaries are installed? What language does Apache OpenOffice think that the document is written in? jonathon signature.asc Description: OpenPGP digital signature
Re: I Need Help
At 22:56 06/12/2014 -0500, Doug McGarrett wrote: On 12/06/2014 03:20 PM, Phillip Smith wrote: I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. What is wrong. What's wrong apparently is that there must be bug in the software. This complaint seems to surface about once a week or so. Why don't you file a bug report with OpenOffice. Then send another one to LibreOffice. LO must have copied it when they forked. We can do better than just say just there must be a bug. Clearly something has gone wrong and it may be considered a bug in the application that this happens. But it is well understood that this situation occurs when the OpenOffice user profile becomes corrupt - for whatever reason - and there are simple ways to correct the problem. By all means submit bug reports, but in order to be of any help you would probably need to determine what documents or what specific actions in OpenOffice were likely to cause profile corruption. When you do so, and can explain this in your bug reports, I'm sure many people will be delighted. Good luck! Oh - unless you are planning to write just It doesn't work. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I Need Help
At 17:50 07/12/2014 +, Toki Jonathon Kantoor wrote: On 06/12/14 20:20, Phillip Smith wrote: I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. Odds are, it is a language dictionary mismatch. What dictionaries are installed? What language does Apache OpenOffice think that the document is written in? For what it's worth, this is surely not true? If OpenOffice correctly determines that no spelling dictionary is installed for the marked language of any text, then it will not be able to check the text and should (and generally will) fail to mark anything as misspelled. (You can confirm this very easily by the simple test of marking some text - anything will do - as being in a language for which you do not have a spelling dictionary installed.) That's a different problem from the one described here (where everything, not nothing, is marked as wrong) - which is likely to be caused by corruption of the user profile. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I Need Help
On 12/06/2014 07:56 PM, Doug wrote: On 12/06/2014 03:20 PM, smithphill...@sky.com wrote: I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. What is wrong. Help Help HelpPhil What's wrong apparently is that there must be bug in the software. This complaint seems to surface about once a week or so. Why don't you file a bug report with OpenOffice. Then send another one to LibreOffice. LO must have copied it when they forked. It and many, many duplicates have already been filed: https://issues.apache.org/ooo/show_bug.cgi?id=121930 Sample duplicate: https://issues.apache.org/ooo/show_bug.cgi?id=124752 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I Need Help
On 12/8/2014 12:07 AM, Brian Barker wrote: At 22:56 06/12/2014 -0500, Doug McGarrett wrote: On 12/06/2014 03:20 PM, Phillip Smith wrote: I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. What is wrong. What's wrong apparently is that there must be bug in the software. This complaint seems to surface about once a week or so. Why don't you file a bug report with OpenOffice. Then send another one to LibreOffice. LO must have copied it when they forked. We can do better than just say just there must be a bug. Clearly something has gone wrong and it may be considered a bug in the application that this happens. But it is well understood that this situation occurs when the OpenOffice user profile becomes corrupt - for whatever reason - and there are simple ways to correct the problem. By all means submit bug reports, but in order to be of any help you would probably need to determine what documents or what specific actions in OpenOffice were likely to cause profile corruption. When you do so, and can explain this in your bug reports, I'm sure many people will be delighted. Good luck! Oh - unless you are planning to write just It doesn't work. Brian Barker It seems to me that this seems to only happen when someone upgrades to a new version. At least that's the only cases I've seen reported and it has never happened to me personally. Dale Erwin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
I Need Help
I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. What is wrong. Help Help HelpPhil
Re: I Need Help
On 7-12-2014 7:20, smithphill...@sky.com wrote: I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. What is wrong. Help Help HelpPhil As an initial troubleshooting step, reset your OpenOffice user profile see: http://forum.openoffice.org/en/forum/viewtopic.php?p=58403 This will reset all your preferences to default (rename or copy the current profile before it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I Need Help
On 12/06/2014 03:20 PM, smithphill...@sky.com wrote: I have updated open Office to the current 4.1 version and now all words in a document are underlined as spelt wrong, alternatives are not offered. What is wrong. Help Help HelpPhil What's wrong apparently is that there must be bug in the software. This complaint seems to surface about once a week or so. Why don't you file a bug report with OpenOffice. Then send another one to LibreOffice. LO must have copied it when they forked. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org