Insert a checkbox in a Calc document
-
- Posts: 3
- Joined: Tue Apr 29, 2008 3:03 pm
Insert a checkbox in a Calc document
Hi, I'm creating a spreadsheet with OpenOffice.org Calc, I've a column which contains only the values "Yes" or "No", and I'd like to replace this values with a checkbox. Is it possible??? If yes, how can I do it?? Thanks ^_^
Re: Insert a checkbox in a Calc document
Calc is a spreadsheet and is using cells. You can create check boxes with the design toolbar, but they are not directly linked to cells and do not extend automatically when you use more rows, etc. So I suggest that you use a separate column to display a pseudo check box with the Winding font. In cell C1, use the formula
=IF(B1="Yes";"";"")
Use the menu Insert > Special Characters to insert a symbol for "selected check box" at the place of the first question mark, and a symbol for "un-selected check box" at the place of the second question mark. Format the column using Winding font.
Of course, this solution does not allow simple click to select/un-select in case you want to change the Yes/No value in that column, for this I have no answer...
=IF(B1="Yes";"";"")
Use the menu Insert > Special Characters to insert a symbol for "selected check box" at the place of the first question mark, and a symbol for "un-selected check box" at the place of the second question mark. Format the column using Winding font.
Of course, this solution does not allow simple click to select/un-select in case you want to change the Yes/No value in that column, for this I have no answer...
LibreOffice 4.2.3.3. on Ubuntu 14.04