View original (French)

Hide cells

Solved
ant.r72 Posted messages 1807 Registration date   Status Contributor Last intervention   -  
ant.r72 Posted messages 1807 Registration date   Status Contributor Last intervention   -
Bonjour,

I am using LibreOffice Calc to create an account sheet.
However, I have a small problem. How can I hide cells until others are filled in? Let me explain. In the "Total" column, there are a lot of 0.00 € displayed:
I would like to hide them until the first cell in a row is filled in. But I don't know how to do it. Do I need to create a macro?

Thank you in advance for your responses!

3 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello, 

    =if(A2="";"";E2+F2)

    A2: the cell to check is empty
    E2+F2: the formula you want.

    Eric

    --
    By continually trying, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to the thank you (yes, it can be done!!!), remember to mark it as resolved. Thanks
    1
  2. yclik Posted messages 3874 Registration date   Status Member Last intervention   1 609
     
    Hello
    two solutions
    Tools > Options > +OpenOfficeCalc>Display > uncheck "zero value"


    or with formula
    =IF(E2+F2=0;"";E2+F2)
    also look into conditional formatting by creating a style with the font color the same as the background color
    1
  3. ant.r72 Posted messages 1807 Registration date   Status Contributor Last intervention   539
     
    Thank you both very much, it works!
    0