Re: trouble with login - email address Re: spellcheck - continuously causing problems
Log in using the username associated with that address; go to User Control Panel via link at top left of page; select Profile tab; select Edit Account Settings; enter new email details. Note - please only ask user related questions on the user list; don't send multiple emails to unrelated mail addresses. On 13/4/21 3:36 pm, Chris Addington wrote: hi i am registered with oo forum under cd...@eircom.net which is an old address no longer operational, - how do i sort this out? regardschris Chris Addington Pr.Eng. Cheers -- David Robley "I brush my teeth ten times a day," said Tom implacably. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
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: Can AOO open MS ACCESS files?
At 11:44 12/04/2021 -0400, Vince Bonly wrote: I've got several files that have either ".LDB" or ".MDB" file extension names. I believe these files were generated with MS ACCESS vers 1.0. The .mdb files will indeed be Microsoft database files. The .ldb files are lock files used by Microsoft Access, so you can ignore those. Can they be opened/used by AOO? I think not. But what you can do is to connect to the .mdb file, so as to have access to its data: o In Step 1 of the Database Wizard, select "Connect to an existing database". o From the drop-down menu, select Microsoft Access. o Next >>. o In Step 2, browse to and open the connection. o Save your *new* database. o See the original tables now accessible in your new database. 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!
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 >
Re: I need help!
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
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
Can AOO open MS ACCESS files?
Hello: I've got several files that have either ".LDB" or ".MDB" file extension names. I believe these files were generated with MS ACCESS vers 1.0. Can they be opened/used by AOO? Regards, VinceB.
Re: spellcheck - continuously causing problems
See if Troubleshooting Spell check in OpenOffice -> https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=16512 helps. Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go to http://openoffice.apache.org/mailing-lists.html As a courtesy I have forwarded a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at - replies to my personal email address will be ignored. On 12/4/21 7:12 pm, Chris Addington wrote: hi openoffice spellcheck spellcheck constantly causes problems - in standard new text document (selecting top lhs symbol) it doesn't work have setup a template new text document in which spellcheck works from time2time -> openoffice is unreliable regardschris Cheers -- David Robley I get mail I exist. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: spellcheck - continuously causing problems
Hello Chris, please check the setting for the default document language in menu item /tools/options/language settings/languages Kind regards, Joost Am 12.04.2021 um 11:42 schrieb Chris Addington: hi openoffice spellcheck spellcheck constantly causes problems - in standard new text document (selecting top lhs symbol) it doesn't work have setup a template new text document in which spellcheck works from time2time -> openoffice is unreliable regardschris - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
spellcheck - continuously causing problems
hi openoffice spellcheck spellcheck constantly causes problems - in standard new text document (selecting top lhs symbol) it doesn't work have setup a template new text document in which spellcheck works from time2time -> openoffice is unreliable regardschris -- Chris Addington Pr.Eng. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
