[Libreoffice-ux-advise] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #9 from ady <adylo811517 at gmail.com> ---
(In reply to ady from comment #6)
> FWIW and only as a side note, see bug 131916 comment 14 (and/or the whole
> ticket) regarding the use of CTRL+* (in numeric pad) and CTRL+A in Calc (and
> in Excel).

@UX team,

When users apply an attribute to a selected range of cells, they are usually
expecting for the attribute to be applied to all the range of the selected
cells. If that's _all_ cells, then that should be it.

If devs are afraid of users misusing any selection method, the way it should be
considered should be to affect the resulting selection, not the attribute not
being applied to part of the selected cells.

For example, as mentioned in bug 131916 comment 14, if users use [CTRL]+[A],
the initial selection should cover the immediate active range of cells. The
second immediate consecutive [CTRL]+[A] should select the entire active range
of cells. Only the third [CTRL]+[A] would select the entire worksheet. This of
course should depend on whether a surrounding active range exists, and/or an
entire active range of cells exists; when either of them is not relevant, the
next "step" of the selection takes over.

So, for instance, if the worksheet is entirely blank, the first [CTRL]+[A]
immediately selects the entire worksheet.

Whichever the case, when a selection of cells is performed, the attributes or
actions that follow the selection should apply to the entire selected range.

IOW, please don't overprotect users from their own actions. Preventing users
from performing expected actions and receiving expected results should not be
overpowered by misused or "by-mistake" selections/actions. Help users, but
please don't "block" users from performing the intended action. Allow "steps"
for [CTRL]+[A] (for example) is a much better approach than silently affecting
a different range of cells than what was selected.

-- 
You are receiving this mail because:
You are on the CC list for the bug.