Re: Spreadsheet Formula Hiding "0"

2020-06-03 Thread Martin Groenescheij
Replacing an Number Field with text as in your formula will have impact on calculations like COUNT() or AVERAGE() Also your formula doesn't take into account negative numbers Suppressing the display of zeros in your Options works on your Display, but it will not suppress your it when you print

PROBLEM

2020-06-03 Thread Jesse Ferguson
Hello! I've used your products for a long time and am a fan! However just yesterday I've hit a big problem. I restarted my computer and when I turned it back on, OpenOffice is giving me grief. I open the program and ALL the words (not just the mistakes) are underlined in red. See below (message

Re: PROBLEM

2020-06-03 Thread Steven Ahlers
This is most likely a problem with your User Profile. It is usually caused by a too hasty shutdown of your computer. See: https://forum.openoffice.org/en/forum/viewtopic.php?f=6&t=89050 for explanations on how to resolve this problem. Sent from my iPhone > On Jun 3, 2020, at 11:54 AM, Jesse F

Re: PROBLEM

2020-06-03 Thread Rory O'Farrell
On Wed, 3 Jun 2020 16:50:40 + Jesse Ferguson wrote: > Hello! > I've used your products for a long time and am a fan! However just yesterday > I've hit a big problem. I restarted my computer and when I turned it back on, > OpenOffice is giving me grief. I open the program and ALL the words (

Transfering custom syles from an old document

2020-06-03 Thread Keith N. McKenna
I have a document originally done on a system I no longer have access to which has custom styles I would like to use for a new project. Is there an easier way to to transfer them from that document to my present system than opening the old document and a new one and recreating then one by on in the

Re: Transfering custom syles from an old document

2020-06-03 Thread David Robley
You may find your solution in https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Copying_and_moving_styles On 4/6/20 10:45 am, Keith N. McKenna wrote: I have a document originally done on a system I no longer have access to which has custom styles I would like to

Re: Transfering custom syles from an old document

2020-06-03 Thread Dan Lewis
Yes, this can be done using the Styles and Formatting dialog. How to change styles in a document is described in the Writer Guide for AOO. You may need to do a search to download it. In addition, you should also use these custom styles to create a template for future use. That will give you acc