Bug 111665 - "Data" -> "Validity": represent boolean values with a checkbox
Summary: "Data" -> "Validity": represent boolean values with a checkbox
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
 
Reported: 2017-08-10 20:09 UTC by c.buhtz
Modified: 2018-03-19 15:41 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot (43.06 KB, image/jpeg)
2017-08-15 21:09 UTC, c.buhtz
Details
screenshot (27.43 KB, image/jpeg)
2017-08-15 21:12 UTC, c.buhtz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description c.buhtz 2017-08-10 20:09:02 UTC
When you use the menu "Data" -> "Validity" and give a "list" or some cell's content then the cell has dropdown menu. Nice.

It would make sense having a checkbox for bool values there.

I know you can use the "Checkbox" button from the "Form Controls" toolbar. But such a control doesn't appear as the content of a cell. I would like to have checkboxes for each cell in on column.
Comment 1 Timur 2017-08-15 16:20:35 UTC
Thank you for making LO better. But please have in mind that those who read this bug may not use or know exactly what you meant. So, please give exact steps and reproduced/expected result. And explain this with dropdown menu.
Comment 2 c.buhtz 2017-08-15 21:09:21 UTC
Created attachment 135565 [details]
screenshot

This is how "Data -> Validity" works with a "cell range". It creates a dropdown menu for each cell.
Comment 3 c.buhtz 2017-08-15 21:12:35 UTC
Created attachment 135566 [details]
screenshot

In that list should be a new feature for boolean values. And in the cell this should represented as a checkbox.
Comment 4 Timur 2017-08-22 09:28:19 UTC
Data-Validity-Criteria-Allow now also has "Cell range" with "Show selection list". 
If you write "true" and "false" or "0" and "1" you may apply that cell range and get dropdown menu with those 2 values. 
If this satisfies your need, than this is "NotABug". If not, please explain why, with exact scenario that shows a need for additional "Boolean" option.
Comment 5 QA Administrators 2018-03-02 10:01:33 UTC Comment hidden (obsolete)
Comment 6 c.buhtz 2018-03-02 17:52:14 UTC
Your provided workaround doesn't fit my needs. My request was for a real checkbox to represent boolean values in a cell.
Comment 7 Xisco Faulí 2018-03-05 16:02:58 UTC
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Comment 8 Timur 2018-03-05 16:26:35 UTC
Question from Comment 4 is still not answered.
Comment 9 c.buhtz 2018-03-05 20:09:10 UTC
it is answered in comment #6
Comment 10 Buovjaga 2018-03-10 17:56:48 UTC
(In reply to c.buhtz from comment #9)
> it is answered in comment #6

Answer this: please explain why, with exact scenario that shows a need for additional "Boolean" option.

The scenario / use case is important to know.
Comment 11 c.buhtz 2018-03-11 13:08:09 UTC
You offered a drop down menu. This makes to much clicks. And a drop down is not suited to display dichotome values.

A checkbox would easy this and would be more "natural".
Comment 12 m.a.riosv 2018-03-11 23:29:17 UTC
(In reply to c.buhtz from comment #0)
> .....
> I know you can use the "Checkbox" button from the "Form Controls" toolbar.
> But such a control doesn't appear as the content of a cell. I would like to
> have checkboxes for each cell in on column.

Form checkbox can be linked to a cell. So it should be a solution for your request.
Comment 13 Heiko Tietze 2018-03-19 15:41:32 UTC
It's true that a checkbox has less clicks than a dropdown. But for what reason should Calc accept only a very restricted set? Bool is defined as 0/1 or 0/-1 or 0/!0 depending on the language. We would have to take one option. And in the end it's not clear why this option is needed beyond completeness in relation to variables.