You cannot remove protection from a protected cell (neither directly nor by running a script) without removing protection from the sheet in advance. You can write your own macro functions for handle the Form control elements better.Īnd you can use the Named cells (Named ranges) function in your formulas: You can name the linked cell as "CheckBox1" for example,Īnd you can "hide" the linked cell: just put it into an another (helper) sheet, or format it as invisible, or put it into the cell containing the checkbox (put it "behind" the checkbox).Ĭonclusion: Study and use the EXISTING functions and features, or be a developer, and please develop new ones for us. 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. Public XCheckBox insertCheckBox (XItemListener _xItemListener, int _nPosX, int _nPosY, int _nWidth ) Ī checkbox may also display images similar to a button as described in Command Button.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 kommentar(er)
