Ask Your Question

supress printing zeros

asked 2019-11-23 20:38:22 +0100

Pete of Ebor gravatar image

Hi Is there any way to supress printing zero values. I have a multi sheet spreadsheet which I use for keeping a record of people who have paid for events, and how much they have paid. I use different colours for people who are going/not going/paid/unpaid or part paid. What I have tried to do is copy the data on this coloured sheet to a different sheet with no colours which I can easily print out and take with me. I want this sheet to supress all zero values. I already have ''zero values" under Tools > Options > LibreOffice calc > View > Zero values unticked. Oddly, on the screen, the sheet shows no zero values, but when I print it, it does.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-11-24 07:39:51 +0100

updated 2019-11-24 07:42:58 +0100


image description

Other ways are to use conditional formatting set to output nothing when value is zero; or using custom number format codes doing the same.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-23 20:38:22 +0100

Seen: 18 times

Last updated: Nov 24