<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - EDITING: Insert checkbox easily as in Google Sheets" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133417#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - EDITING: Insert checkbox easily as in Google Sheets" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133417">bug 133417</a> from <a class="email" href="mailto:omvsj@yahoo.com" title="omvsj <omvsj@yahoo.com>"> omvsj</a> <pre>(In reply to Heiko Tietze from <a href="show_bug.cgi?id=133417#c3">comment #3</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>