View original (French)

Remove leading zeros in printouts

Solved
Aygues31 -  

Hello,

I am using LibreOffice Calc.

My document is clean without zeros in the blank cells …

… but all these "0" appear in the blank cells when printing! How can I stop seeing them when printing?

And !!! in the menu, if I go to Tools / Options / LibreOffice Calc / View: the zeros are disabled!!! (little box unchecked.) … I don’t understand.

Thank you

4 answers

  1.  trotte-menu

    Hello,

    In response to this message by baladur13

    The solution provided concerns Apache OpenOffice.

    For LibreOffice it’s:
    Menu Format > Page Style > Page > Print > Uncheck Zero values.

    Regards

    MBA M4 + macOS Tahoe
    OpenOffice, LibreOffice

    1
    1. baladur13 Moderator

      Hello,

      See under Format - Page - Workbook

      and in the middle of the page in the Print section, uncheck the zero values box

      Very difficult to catch a black cat in a dark room.
      Especially when it isn’t there...

      0
      1. Aygues31 Author

        Hello everyone,

        Finally, someone who knows!!!!!!!!!!!!

        Thanks, that's it ... brilliant because I asked the question several times in different places on the LibreOffice site and I was given nonsense...

        Moreover, no information found on the LibreOffice "site"

        What I don't understand is why this appearance of the "0"s happened all by itself!!! Before that, the prints were without displaying zeros.

        The spontaneous generation.

        Best regards

        0
        1. baladur13 Moderator

          Perfect

          Thanks for the feedback.

          0
      2. baladur13 Moderator

        Attempt to respond to see if the vanished messages (2 and 3) would come back...

        Edit: well no, missed...

        Very difficult to catch a black cat in a dark room.
        Especially when it is not there...

        0