I created a check box and linked the cell in same cell the checkbox was created. I need to format the linked cell to hide the value (true, false). I have try some example such as ;;;, it will clear the cell for that instance only, when I click on another cell and come back to the previously formatted cell its format fall back to boolean true, false.
Welcome!
There are several different ways to get around this problem. I suggest using this trick. The values TRUE and FALSE will be displayed in the linked cell if none of the “Reference values (ON/OFF )” are defined in the checkbox properties.
Just put a single space in the “Reference values (on)” field - this will be enough so that when the state of the checkbox changes, a space or an empty string appears in the associated cell. This way you will suppress the text output of TRUE and FALSE .
But you need to get a boolean value from this cell, right? Continuing the trick is the using the LEN() function applied to the contents of the associated cell =LEN(E1) - for a checked box you get 1 (which is TRUE), and for a unchecked one you get 0 (which Calc will regard as FALSE)
1 Like
Thank you very much, it worked, Im transitioning from ms excel to libreoffice. Once again Thanks