Re: [libreoffice-users] New to Libre Office

At 18:55 28/01/2015 +0000, Mary Sandlin wrote:
> Just got LibreOffice and have a problem. Have been using excel for 
> many years and now using calc. My problem is keeping the formula 
> from printing a zero in my spreadsheet. I use this for my invoices 
> and when a line with a formula is not used (no entry) the result 
> prints as a zero. How can I keep the zeros from printing?

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


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted