Bug 147829 - visualise and toggle false() and true() functions with a checkbox on canvas
Summary: visualise and toggle false() and true() functions with a checkbox on canvas
Status: RESOLVED DUPLICATE of bug 133417
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks:
 
Reported: 2022-03-07 17:39 UTC by Steven Friedrich
Modified: 2023-12-01 15:31 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
printscreen Google sheet and export (64.49 KB, image/png)
2023-09-26 21:51 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Steven Friedrich 2022-03-07 17:39:15 UTC
Description:
Google Sheets has an ultra-cool feature in Sheets; checkbox
I create a LOT of spreadsheets using checkboxes.  Very useful feature.

Steps to Reproduce:
1.Open LibreOffice Calc
2.Open Insert menu.
3.Note, there is no checkbox like Google Sheets.

Actual Results:
Calc has no checkbox to insert like Google Sheets

Expected Results:
Please adopt this feature from Google Sheets


Reproducible: Always


User Profile Reset: No



Additional Info:
No other info.
Comment 1 m_a_riosv 2022-03-07 17:56:04 UTC
Menu/View/Toolbars/Form Control, with Check-box button, you can do it, right-click on it to select their control options, and link the value to a cell.

https://help.libreoffice.org/latest/en-US/text/shared/02/01170000.html?DbPAR=SHARED#bm_id3154142
Comment 2 Steven Friedrich 2022-03-08 01:41:30 UTC
The Google Sheets checkbox feature works much better.  The checkbox is like a character, you can copy it to other cells and it doesn't remain tied to a particular cell.  You can also resize the column to fit the checkbox.
AFAIK LibreOffice Form Controls don't exist within a cell, they float on the sheet.
They are tied to a cell, so when you copy it, they remain tied to say, A1.
Comment 3 QA Administrators 2022-03-08 03:45:58 UTC Comment hidden (obsolete)
Comment 4 raal 2023-09-26 21:51:41 UTC
Created attachment 189837 [details]
printscreen Google sheet and export

It looks like it's only visual presentation of functions =TRUE() and =FALSE()?
Comment 5 Heiko Tietze 2023-12-01 15:31:36 UTC

*** This bug has been marked as a duplicate of bug 133417 ***