![]() ![]() It is a conceptional solution, "inherited" from the Excel. I did briefly try this.in Zizi's example, this meant changing A4 in the condition formula to B4.but this does not work.the linked cell is required That way, the ugliness of the appearance of the linked cell (plus the resulting issue of trying to protect the linked cell) could be avoided. It just seems a shame that the designers of LO didn't arrange that for the cell designation of the chkbox itself to be used, instead of the linked cell, in the formula. I right-clicked the check box and the dialog (see my graphic) appeared titled "Properties", and below is the check box, and underneath that are some cells (c103, c104, c105, c106 and c107) which I would like to unprotect if the checkbox is checked, otherwise they should be disabled from data entry. Please find attached a small screenshot of my progress, so that I can ask a question. So I have now placed check box on my sheet. Switch off the edit mode, ant the check box will work. Now you can adjust the properties of the checkbox include the control properties, like the assigned cell. ![]() Put a checkbux on th sheet, resize it, and the right click on it. Switch it to Edit mode by clicking on the second icon of the toolbar. Switch on the toolbar: View - Toolbars - Form Controls. Does LibreOffice 4.2.6.2 calc, support a feature where a cell can effectively change it's internal state based on whether the user clicks it with a mouse (this being the most orthodox mechanism to toggle a check box)?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |