Ask Your Question
2

LibreOffice Calc - zero values [closed]

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

Moringer gravatar image

updated 2020-07-22 13:21:28 +0100

Alex Kemp 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 5.0.2.3 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
3

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

Moringer gravatar image

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

Original answer has been deleted -

Format - Page - Sheet -Zero values

image description

edit flag offensive delete link more

Comments

this answer solves to hide or not zero values in the outprint ... in the whole output! ... but the question was

'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.' that reads for me 'some but not all zero values should be printed.

thus besides being helpful the answer is not a solution to the OP's question.

reg.

b.

newbie-02 gravatar imagenewbie-02 ( 2019-09-17 20:41:02 +0100 )edit

Question Tools

2 followers

Stats

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

Seen: 4,882 times

Last updated: Jan 11 '17