Can't 'Check' Checkboxes in a Form?

Discuss the spreadsheet application

Can't 'Check' Checkboxes in a Form?

Postby mehni » Thu Nov 28, 2019 2:49 pm


Every time I try to click this check box, it just allows me to move it and other things I don't need to do.
I have tried turning Design Mode on and off and neither of them want to allow me to check the checkbox.
All I want to do is fill out the form but I can only edit it.

It is a .xlsm file in OO 4.1.7 on Windows 10.
Windows 10 Open Office 4.1.7
Posts: 1
Joined: Thu Nov 28, 2019 2:44 pm

Re: Can't 'Check' Checkboxes in a Form?

Postby Zizi64 » Thu Nov 28, 2019 7:46 pm

Just switch OFF the edit mode of the Form control elements.

It is a .xlsm file in OO 4.1.7 on Windows 10.

And always use the native, international standard ODF file types.
Last edited by Zizi64 on Fri Nov 29, 2019 7:42 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6, 6.4.7 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.1.1;AOO4.1.9
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Posts: 9811
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Can't 'Check' Checkboxes in a Form?

Postby UnklDonald418 » Thu Nov 28, 2019 9:50 pm

You might have better success if you work with a native file (.ods) rather than a .xlsm file although in my tests it worked either way.
When you select the checkbox control, if you see the green handles surrounding it, as in your screen shot, then you are in the Design Mode.
On a spreadsheet you will need to use the Form Design toolbar which is not normally visible on spreadsheets, so you may need to add it by selecting View>Toolbars>Form Design. Near the left of the toolbar is the Design Mode On/Off button.
The checkbox should work with the Design Mode off.
New Calc users should also read this [Tutorial] Ten concepts that every Calc user should know
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.8 & LibreOffice - Windows 10 Professional
Posts: 1391
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Return to Calc

Who is online

Users browsing this forum: Zizi64 and 18 guests