supress printing zeros

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.

Formatâ–¸Page

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

1 Like