Bug 55848 - FormControls : Can't modify the size of a check box
Summary: FormControls : Can't modify the size of a check box
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Form-Controls DOCX-Content_Control
  Show dependency treegraph
Reported: 2012-10-10 18:44 UTC by Pierre C
Modified: 2024-01-05 15:25 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

example (51.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-10-10 18:44 UTC, Pierre C

Note You need to log in before you can comment on or make changes to this bug.
Description Pierre C 2012-10-10 18:44:03 UTC
Created attachment 68416 [details]

there is no way to change the size of the square of the check box

this is annoying if you want to use a UI with checkbox

the only workaround i see is to change the size of all the other elements in the sheet... 

on example, on sheet 'Drancy' i want check box on all lines (column D)
can you found the only one in the sheet ?

they are very small...

Same problem exists with radio button
Comment 1 Alex Thurgood 2013-05-03 14:45:24 UTC
Confirming - issue present in all versions of LO since beginning of the project.

This is inherited from OpenOffice.org, which has never had the possibility to resize checkboxes.

Note that I am referring here to the checkbox itself and not the bounding box that surrounds the label and checkbox, which is redimensionable.

See also :


Comment 2 Alex Thurgood 2013-05-03 14:46:57 UTC
So this is AWT toolkit or VCL stuff, not really sure which of the devs handles that kind of thing ?

Comment 3 Alex Thurgood 2013-05-03 14:51:24 UTC
Changing component to graphics stack, as it seems to be missing from the AWT.

Comment 4 QA Administrators 2015-03-04 02:20:41 UTC Comment hidden (obsolete)
Comment 5 Alex Thurgood 2015-03-04 10:11:55 UTC Comment hidden (obsolete)
Comment 6 Alex Thurgood 2015-03-04 10:19:48 UTC Comment hidden (obsolete)
Comment 7 Pierre C 2015-03-04 14:32:44 UTC Comment hidden (obsolete)
Comment 8 tommy27 2016-04-16 07:26:47 UTC Comment hidden (obsolete)
Comment 9 Pierre C 2016-05-07 21:00:39 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2017-05-22 13:39:41 UTC Comment hidden (obsolete, spam)
Comment 11 Justin L 2018-10-02 16:31:38 UTC
The ability to do this would be helpful for bug 99571 comment 12 also.
Comment 12 QA Administrators 2019-10-03 03:00:13 UTC Comment hidden (obsolete, spam)
Comment 13 Pierre C 2020-09-22 08:55:17 UTC
Still a bug with LO
Comment 14 QA Administrators 2023-09-16 03:21:58 UTC Comment hidden (obsolete, spam)
Comment 15 Alex Thurgood 2023-10-02 14:30:56 UTC
Bug still present with

Version: (AARCH64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 8; OS: Mac OS X 13.4; UI render: Skia/Raster; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Comment 16 Heiko Tietze 2023-10-04 11:44:29 UTC
Form controls are defined by the system and we cannot change the size (neither this attribute is available in ODF).

But Miklos implemented recently "content controls" [1], which effectively means a Unicode symbol where the checkbox size respects the font size. Unfortunately this feature is available in Writer only. Looks like MSO also has not implemented this in Excel, I find only ActiveX aka system-themed checkboxes.

Miklos, do you have more insights?

Anyway, you may show a checkbox character in a cell, add a click interaction, and toggle it respectively. 

[1] https://wiki.documentfoundation.org/Videos/ContentControls
Comment 17 Miklos Vajna 2023-10-04 11:56:14 UTC
Right, MSO content controls are specific to text documents, probably you can't look at them as an example to follow here.
Comment 18 Alex Thurgood 2023-10-04 14:32:43 UTC
(In reply to Heiko Tietze from comment #16)
> Form controls are defined by the system and we cannot change the size
> (neither this attribute is available in ODF).

Which is unfortunate because the macOS Cocoa API lets you define the size of a checkbox, e.g. :

NSRect frame;
frame.size.width = frame.size.height = 18;
NSButton *myCheckBox = [[NSButton alloc] initWithFrame:frame];
[myCheckBox setButtonType:NSSwitchButton];


I imagine that similar definitions would hopefully exist for other UI toolkits.

Unfortunately, neither XCheckbox.idl nor Checkbox.idl seem to include any interface definitions for setting the size of the checkbox control.
Comment 19 Andreo Patro 2024-01-05 15:25:10 UTC Comment hidden (spam)