Ask Your Question

LibreOffice Calc - zero values [closed]

asked 2013-12-06 09:40:57 +0200

Moringer gravatar image

updated 2017-01-11 13:17:41 +0200

cloph gravatar image

I need to print/export to pdf with visible zero values in cells. I couldn't find the solution.

I'm using LibreOffice Calc version under Ubuntu (linux).

I have configured my spreadsheet to always show zeros as blanks. However, in a small number of selected cells, I want zeros to be explicitly shown.

Is there a way to format individual cells to override the default "hide if zero" behavior? I can't find any way to do this.

Thank you very much.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 00:06:51.520373

1 Answer

Sort by » oldest newest most voted

answered 2014-08-14 10:08:55 +0200

Moringer gravatar image

updated 2014-08-14 10:10:29 +0200

Original answer has been deleted -

Format - Page - Sheet -Zero values

image description

edit flag offensive delete link more

Question Tools



Asked: 2013-12-06 09:40:57 +0200

Seen: 3,600 times

Last updated: Jan 11 '17