https://bugs.freedesktop.org/show_bug.cgi?id=66472
Priority: medium
Bug ID: 66472
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Better ergonomics for column, row, and cell actions in
Calc
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: laurent.lyau...@gmail.com
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Hi,
The ergonomics of Calc could be made more efficient (need less click, movements
from the user to do the same action).
When you want to apply an action to all columns, all rows, or all cells, you
have to do the following :
click the X zone
X|B|C
-
1|
-
2|
then right click on columns headers for column actions,
right click on row "headers" for row actions,
right click on cells for cells actions.
Then you must add the number of clicks for each action.
I'll take an example :
Suppose you want to unhide all hidden columns and all hidden rows.
You have to click 5 times
- X zone
- right click column, click unhide
- right click row, click unhide
I propose the X zone to be replaced by the following visual element,
split the X zone in 3 parts like this
__
| /|
|/\|
and make all three zones clickable and right clickable:
- right part selects all columns and make it possible to apply actions (from
contextual menu or other actions) to all columns
- lower part selects all rows and make it possible to apply actions (from
contextual menu or other actions) to all rows
- upper left part selects all columns, rows, cell and make it possible to apply
actions (from contextual menu or other actions) to all columns and/or all rows
or all cells
I would like to name this element of ergonomics a triforce as a tribute to
Zelda :D
(ok it doesn't exactly looks like a triforce but... Imagine saying to someone
"click the triforce on your spreadsheet !" It's much better than clicking
"upperleft corner")
Hence, we could say right triforce, down triforce and triforce for right part,
lower part, and upper left part respectively.
While the contextual menu when right clicking right triforce or down triforce
is the same as right clicking columns or rows (after clicking X zone),
the contextual menu for the triforce is new.
It must be split in two parts :
- actions that can apply to both rows and columns
- actions that apply to cells
Back to the example, now you just need 2 clicks instead of 5 (right click
triforce, click unhide)
The number of mouse movements required would similarly be decreased.
Note that there is no UI regression. Any user can still work the old way by
left clicking the triforce then right clicking rows, columns or cells.
We can rename the triforce or ask Nintendo permission to use this name in
official documentation, it would just be the cheery on the cake.
But what is truly important is the ergonomics.
I hope I clearly presented my idea.
Best regards,
Laurent Lyaudet
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
