Insert a checkbox in a Calc document

Discuss the spreadsheet application
Post Reply
recarnevale
Posts: 3
Joined: Tue Apr 29, 2008 3:03 pm

Insert a checkbox in a Calc document

Post by recarnevale »

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 ^_^
User avatar
squenson
Volunteer
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Insert a checkbox in a Calc document

Post by squenson »

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...
LibreOffice 4.2.3.3. on Ubuntu 14.04
Post Reply