[Libreoffice-bugs] [Bug 133417] EDITING: Insert checkbox easily as in Google Sheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133417

--- Comment #5 from omvsj <omvsj at yahoo.com> ---
(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?

Not exactly.
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200918/ea983c1f/attachment-0001.htm>