Ask Your Question

How to insert checkbox in cells? [closed]

asked 2017-11-26 09:03:12 +0100

SavedByGrace gravatar image

I am trying to insert clickable checkboxes in Calc cells but have not been able to figure out how to do it.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-08 01:23:09.189917


Is the question about how to insert form controls, or how to get the checkboxes to work? If the latter, then what do you want to happen when a checkbox is clicked?

Jim K gravatar imageJim K ( 2017-11-26 12:11:12 +0100 )edit

I am wanting to create a spreadsheet with checkboxes that can be checked to indicate the item(s) in that row have been completed. So I am looking for an interactive something that might be a bit more visually appealing than just creating a drop list of 'yes' and 'no' or something like that.

SavedByGrace gravatar imageSavedByGrace ( 2017-11-29 20:10:27 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-11-26 12:07:53 +0100

Jim K gravatar image

updated 2017-11-29 23:50:59 +0100

It is possible to insert hyperlinks in cells which can be formatted to look like buttons. This is done by =HYPERLINK()as in

However, this will not work for checkboxes. For that, enable the Form Controls toolbar by going to View -> Toolbars -> Form Controls.


If I understand correctly, your question is the same as

Here is an example: checkboxes.ods

checkboxes with linked cells

To check or uncheck the boxes, be sure that Edit -> Design Mode is turned off and click on a box.

In this example, I right-clicked on the checkboxes in Design Mode and selected Control. Under the Data tab, I assigned C2 to Linked Cell (and C3 and so on for the other checkboxes). However, the cell links did not save in LO, which may be a bug with this version, because it works in AOO 4.1.3.

edit flag offensive delete link more


Thank you for your response, it does not seem like this would be an interactive solution, so I am not sure that this is what I am looking for...but thank you nevertheless.

SavedByGrace gravatar imageSavedByGrace ( 2017-11-29 20:12:41 +0100 )edit

See updated answer in response to your comments.

Jim K gravatar imageJim K ( 2017-11-29 23:42:49 +0100 )edit

See also my comment concerning the bug tdf#113584 appended under my answer.

Lupp gravatar imageLupp ( 2017-11-30 00:13:31 +0100 )edit

answered 2017-11-26 11:24:12 +0100

Lupp gravatar image

updated 2017-11-30 00:33:34 +0100

You only can anchor a Form Control to a cell (like any shape). you cannot make it the content of the cell (or part of this content).
To change the anchor type use the context (rightclick) menu in design mode.

The type of anchoring is only of meaning concerning the behaviour of a control if columns/rows are inserted/deleted or changed in size. The control as an object always belongs to the DrawPage of the sheet. This does again not mean much. To get a functionallity a Checkbox in a spreadsheet is commonly used by assigning a 'Linked Cell' where a value will be generated depending on the state of the CheckBox. In addition you may also define a Sub to be called on different events. If there are more questions, please try to ask specifically.

When I wrote the above answer and amendment, I had not yet learned that there was a bug concerning the linked cells: tdf#113584. Due to this bug there may have occured misunderstandings. The example by @Jim K will do what was asked for if opened with a proper version.

What do you want the CheckBox to do for you?

edit flag offensive delete link more


Would changing the anchor type allow it to be an interactive type of anchor so that I could click to check it or uncheck it?

SavedByGrace gravatar imageSavedByGrace ( 2017-11-29 20:14:06 +0100 )edit

I do not understand what you expect of the anchor. The interaction with the program a user takes part in shall cause an action on the part of the program, I think. This way form controls (including check boxes) work, and this way can also work a hyperlinks present in cells either due to creation by the user who designed and filled the sheet or due to the result a call to HYPERLINK() returns.
The details can be very different, however.

Lupp gravatar imageLupp ( 2017-11-29 21:34:02 +0100 )edit

Perhaps I am not correctly identifying what it is that I would like... As the spreadsheet creator I would like to insert something into a cell that the user would then be able to interact with. For example, a star system if I am asking the use if they like or dislike something, they would have the ability to select one to say five stars based upon their preference, or say I am asking them if they have these items, and they could check the boxes in the columns that would indicate they have them.

SavedByGrace gravatar imageSavedByGrace ( 2017-11-29 23:35:49 +0100 )edit

I hope that better explains what it is that I am getting at. So far I have not found out how to insert anything like the above in the cells so that it looks a bit like that overpriced other program that M Soft sells, lol.

SavedByGrace gravatar imageSavedByGrace ( 2017-11-29 23:37:25 +0100 )edit

Yes. I think I understood your request in this sense, and I think @Jim K understood it in the same way.
The example he attached does, however, not work in some recent versions of LibO Calc due to the bug tdf#113584 . Use a version of the 5.3. series to see the example work.
In the V6.0.0 to come the bug seems to be absent as I just tested with the Dev Beta1.

Lupp gravatar imageLupp ( 2017-11-30 00:11:05 +0100 )edit

Thank you all very much for your input, I really appreciate your patience and the time you took to share this info with me.

SavedByGrace gravatar imageSavedByGrace ( 2017-11-30 01:07:30 +0100 )edit

Question Tools

1 follower


Asked: 2017-11-26 09:03:12 +0100

Seen: 17,794 times

Last updated: Nov 30 '17