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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue May 26 17:01:14 UTC 2020


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

            Bug ID: 133417
           Summary: EDITING: Insert checkbox easily as in Google Sheets
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: omvsj at yahoo.com

Description:
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:
1.View
2.Toolbars
3.Form Design
4.Activate Design Mode
5.Click Checkbox
6.Drag with mouse within correct cell
7.Right click in Checkbox
8.Anchor to cell
9.Right click in Checkbox
10.Properties
11.Linked cell
12.Manually link cell
13.Hide cell content (to not overlap checkbox)
14.Deactivate Design Mode
15.View
16.Toolbars
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.

Actual Results:
Checkbox is inserted, linked to a cell, clickable.
Checkbox can't be resized only text.

Expected Results:
In Google Sheets is so easy to do, only two steps!:
1.Insert
2.Checkbox

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.


Reproducible: Always


User Profile Reset: No



Additional Info:
Versión: 6.4.4.2
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
Calc: threaded

-- 
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/20200526/5dc4c01b/attachment.htm>


More information about the Libreoffice-bugs mailing list