<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING: Insert checkbox easily as in Google Sheets"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133417">133417</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING: Insert checkbox easily as in Google Sheets
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>omvsj@yahoo.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>