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

2023-12-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

Heiko Tietze  changed:

   What|Removed |Added

 CC||stevenfriedr...@twc.com

--- Comment #10 from Heiko Tietze  ---
*** Bug 147829 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

2021-02-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

--- Comment #9 from omvsj  ---
(In reply to Heiko Tietze from comment #8)
> We discussed the topic in the design meeting and the simple interaction was
> appreciated and would be welcome.

I really appreciate that you discussed it in a meeting.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |needsDevEval
 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1
 CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda
   |.freedesktop.org|tion.org,
   ||rb.hensc...@t-online.de

--- Comment #8 from Heiko Tietze  ---
We discussed the topic in the design meeting and the simple interaction was
appreciated and would be welcome.

Cell content could be still boolean with an additional formatting flag (show as
checkbox) and the interaction (toggle on click). It's a question how this would
be stored and realized cross-platform/-application (the loss of special
formatting and interaction might be acceptable).

GSheet saves the checkbox in odt as 0/1

0

Excel shows FALSE for the checkbox when exported as xlsx.


References (nothing on proper export)
https://support.google.com/docs/answer/7684717?co=GENIE.Platform%3DDesktop&hl=en
https://www.benlcollins.com/spreadsheets/google-sheets-checkbox/

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

Heiko Tietze  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #7 from Heiko Tietze  ---
(In reply to omvsj from comment #5)
> 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...

It would be if the checkbox state is taken somewhere. But actually I see no
point in this clickable checkbox and would rather recommend to realize this per
extension. Keep in mind that more features require maintenance, documentation,
localization and clutter the UI. Adding more and more has negative bearing on
usability.

What do you think, Eike?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

--- Comment #6 from QA Administrators  ---
[Automated Action] NeedInfo-To-Unconfirmed

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

--- Comment #5 from omvsj  ---
(In reply to Heiko Tietze from comment #3)
> 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

--- Comment #4 from omvsj  ---
(In reply to BogdanB from comment #2)
> Please tell me if this helps you.

Hi. This way I can reduce steps but LibO Checkbox is a "floating checkbox" that
still needs to be dragged and configured to be linked to a cell which means 9
steps and can't be easily copy/pasted to a bunch of cells.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

--- Comment #3 from Heiko Tietze  ---
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?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

BogdanB  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #2 from BogdanB  ---
Please tell me if this helps you.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

BogdanB  changed:

   What|Removed |Added

 Whiteboard| QA:needsComment|
 CC||buzea.bog...@libreoffice.or
   ||g

--- Comment #1 from BogdanB  ---
Try this:
Tools - Customize - Toolbar - search for "Check"
and insert CheckBox icon.

For future use just one click.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

QA Administrators  changed:

   What|Removed |Added

 Whiteboard|| QA:needsComment

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-09-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

Buovjaga  changed:

   What|Removed |Added

 Whiteboard| QA:needsComment|
   Keywords||needsUXEval
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-06-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133417

QA Administrators  changed:

   What|Removed |Added

 Whiteboard|| QA:needsComment

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs