[libreoffice-website] New to Libre Office

users
#1

Dear Mary Sandlin,
I'm forwarding your mail to users@global.libreoffice.org
The list website@global.libreoffice.org is for the libreoffice website maintenance only, not for user support.
Refer to this page for more:

http://www.libreoffice.org/get-help/mailing-lists/

Please be aware that if you're not subscribed to the
users@global.libreoffice.org mailing list, you will not receive replies (unless replies are sent directly to your mail address of course).
Namastè cico :slight_smile:

----- Messaggio originale -----

#2

You can suppress the *display* of zeroes by unticking Tools | Options... | LibreOffice Calc | View | Display | Zero values, but this change does not seem to carry over into the printed result, so won't help you. One way I can see is the obvious one: to construct your formulae appropriately.

If there is no entry, say, in A6 and you want a related formula not to show zero, you need to change
=expression
to something like
=IF(expression<>0;expression;"")
or
=IF(A6<>0;expression;"")
or
=IF(A6<>"";expression;"")
as appropriate.

But here's another idea. You can create formats that handle different ranges of values differently. To get the idea, go to Format | Cells... | Numbers | Currency and look at the formats as expressed in the "Format code" box. (You may well be using currency formats for invoices anyway.) You should find that at least some of the formats have different expressions for positive and negative values, separated by a semicolon. If you add another semicolon at the end, you can also set a format for zero values, and if you use # or "" for this extra format, zero values will display as nothing. Such changes will carry across into the printed output, of course.

I trust this helps.

Brian Barker

#3

Hi Tim :slight_smile:
Well, mostly Tim.

I really liked that your answer, as the "first responder", included
Cico so that he/she could see the problem had been picked up by the
mailing list and not just vanished into some void.

Also i very much liked the last paragraph reinforcing what Cico had
said and confirming the correct address.

Threads often vanish off-list and go to just 1 or 2 individuals so
it's often unclear whether a problem has been solved or what advice
has been given and whether it's maybe bad advice or wrong (i doubt it
from you folks tbh but it's theoretically possible and there is always
at least 1 person on every list i am on who might send people
off-track).

So i think it is better when messages do come through the list and i
think your last paragraph is probably something that would be good to
have as an occasional routine reminder even when it's not so relevant.

I feel i learn a LOT from this mailing list. There are a LOT of
really good people here. Thanks all! :slight_smile:
Regards from
Tom :slight_smile: