Re: I need help!

[Brian Barker]

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!

[Kristi Nelson]

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!

[Brian Barker]

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!

[JD]

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!

[JACKSON]

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!

[Kristi Nelson]

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.

[Joost Andrae]

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.

[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

I need help

[suzannareiff]

I really like Open Office but I have a problem. I have Lotus Approach files 
 that I must maintain and I am looking for a way to convert them to another 
 product so that I can get rid of Windows XP and get a new machine.
 
Please help me.
 
Suzanna Reiff
6394 Scorpio Ave
North Port, FL 34287
_suzannareiff@aol.com_ (mailto:suzannare...@aol.com) 
941-391-2394 - cell
941-429-1020 - house  leave message

Re: I need help please

[Dave Barton]

Glad to hear you found some of the links useful.

To resolve your forum login issue contact the forum administrators.
Their email address is under "Nothing worked" in the link:
https://forum.openoffice.org/en/forum/viewtopic.php?f=50&t=527

Regards
Dave

 Original Message  
From: Wayne Cameron 
To: users@openoffice.apache.org
Date: Sun, 8 Mar 2015 19:16:37 -0400

> 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  wrote:
> 
>>  Original Message  
>> From: Wayne Cameron 
>> 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=50&t=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 please

[Wayne Cameron]

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  wrote:

>  Original Message  
> From: Wayne Cameron 
> 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=50&t=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

[Dave Barton]

 Original Message  
From: Wayne Cameron 
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=50&t=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 please

[Vince B.]

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  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

I need help please

[Wayne Cameron]

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

[Brian Barker]

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

[jonathon]

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

[Dale Erwin]

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

Re: I Need Help

[NoOp]

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:



Sample "duplicate":




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: I Need Help

[Brian Barker]

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

[Brian Barker]

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

[jonathon]

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

[Doug]

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

Re: I Need Help

[Martin Groenescheij]

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

I Need Help

[smithphill...@sky.com]

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