In Google Sheets there's an option in the menu: Insert -> Checkbox. Checkbox is inserted in current cell, is clickable and may be evaluated by cell reference as TRUE (activated) or FALSE (deactivated).
In LibO it's necessary to go to menu View -> Toolbars -> Form Design -> Design Mode -> Insert Checkbox -> Drag with mouse -> Right click in Checkbox -> Anchor to cell -> Right click in Checkbox -> Properties -> Linked cell -> Manually link cell -> Hide cell content (to no overlap checkbox) -> Design Mode -> View -> Toolbars > Form Design
Steps to Reproduce:
4.Activate Design Mode
6.Drag with mouse within correct cell
7.Right click in Checkbox
8.Anchor to cell
9.Right click in Checkbox
12.Manually link cell
13.Hide cell content (to not overlap checkbox)
14.Deactivate Design Mode
17.Hide Form Design
To create a checkbox in every cell it has to be done manually, one by one, reproducing the steps from 5 to 13. If copied and pasted needs to be edited to change its name.
Checkbox is inserted, linked to a cell, clickable.
Checkbox can't be resized only text.
In Google Sheets is so easy to do, only two steps!:
Checkbox is inserted in current cell, is clickable and may be evaluated by cell reference as TRUE (activated) or FALSE (deactivated).
To create a checkbox in every cell it may be copied and pasted to a group of cells, to all cells in a row or all cells in a column.
Checkbox may be resized adjusting font size.
It could be a property or content of a cell, this way it's not necessary to go through Form Controls.
User Profile Reset: No
Id. de compilación: 1:6.4.4~rc2-0ubuntu0.18.04.1
Subprocs. CPU: 4; SO: Linux 5.3; Repres. IU: predet.; VCL: gtk3;
Configuración regional: es-MX (es_MX.UTF-8); Idioma de IU: es-ES
Tools - Customize - Toolbar - search for "Check"
and insert CheckBox icon.
For future use just one click.
Please tell me if this helps you.
Insert > Form Control > Checkbox; but this is a floating form control for more complex interactions. I don't see the checkbox being a source of processing in GDoc.
The GDoc checkbox is rather a symbol like Format > Conditional Formatting (Icon Set). You can get the same result with a formula =IF(B2>1;"⊠";"□") (whether the character is available depends on the chosen font).
Does it work for you?
(In reply to BogdanB from comment #2)
> Please tell me if this helps you.
Hi. This way I can reduce steps but LibO Checkbox is a "floating checkbox" that still needs to be dragged and configured to be linked to a cell which means 9 steps and can't be easily copy/pasted to a bunch of cells.
(In reply to Heiko Tietze from comment #3)
> Insert > Form Control > Checkbox; but this is a floating form control for
> more complex interactions. I don't see the checkbox being a source of
> processing in GDoc.
> The GDoc checkbox is rather a symbol like Format > Conditional Formatting
> (Icon Set). You can get the same result with a formula =IF(B2>1;"⊠";"□")
> (whether the character is available depends on the chosen font).
> Does it work for you?
In GDocs, you may press spacebar or tick the checkbox and it changes its state (TRUE or FALSE) and changes the icon automatically according to its state.
Conditional Formatting may be applied with less steps to a bunch of cells but:
1) cells will not change its state with a single click or spacebar
2) with this option you need 2 cells: one for input anything and one for displaying an icon. The icon is only cosmetic and has no other function. It doesn't work as a clickable checkbox.
The GDocs checkbox is supereasy as the cell IS a clickable checkbox that doesn't need any formula to work. Is like formatting a cell as Bold or Italic: just one click to configure it as a clickable checkbox and you may tick it or press spacebar to change its state and shape.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to omvsj from comment #5)
> The GDocs checkbox is supereasy as the cell IS a clickable checkbox that
> doesn't need any formula to work. Is like formatting a cell as Bold...
It would be if the checkbox state is taken somewhere. But actually I see no point in this clickable checkbox and would rather recommend to realize this per extension. Keep in mind that more features require maintenance, documentation, localization and clutter the UI. Adding more and more has negative bearing on usability.
What do you think, Eike?
We discussed the topic in the design meeting and the simple interaction was appreciated and would be welcome.
Cell content could be still boolean with an additional formatting flag (show as checkbox) and the interaction (toggle on click). It's a question how this would be stored and realized cross-platform/-application (the loss of special formatting and interaction might be acceptable).
GSheet saves the checkbox in odt as 0/1
<table:table-cell table:style-name="ce1" table:formula="of:=FALSE()" office:value-type="float" office:value="0" calcext:value-type="float"><text:p>0</text:p></table:table-cell>
Excel shows FALSE for the checkbox when exported as xlsx.
References (nothing on proper export)
(In reply to Heiko Tietze from comment #8)
> We discussed the topic in the design meeting and the simple interaction was
> appreciated and would be welcome.
I really appreciate that you discussed it in a meeting.