https://bugs.freedesktop.org/show_bug.cgi?id=67592
Priority: medium
Bug ID: 67592
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: SELECTING: allow to resize selection box from any
corner
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: j22...@gmail.com
Hardware: All
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 83382
--> https://bugs.freedesktop.org/attachment.cgi?id=83382&action=edit
Here I show how the suggested feature would look like (two alternatives)
Imagine the following very basic situation:
In the cell B15 I have =SUM(B3:B12)
But, now I want to include a few cells more in (eg to extend upwards until B1)
so to have the final selected range (B1:B12). So I double-click B15 and I see
the selection box showing me the currently selected range.
The selection box shows the "handle" (to resize the selection) at the bottom
right corner. So the only way to include the above cells in this case is:
1. locate the mouse inside the selection box so it turns into a "hand"
2. drag and drop to move the whole range two rows upwards
3. put the mouse on the bottom-right corner
4. click and drag to resize two rows downwards
This is a lot of steps for such a simple task. It can be greatly improved and
perhaps even made more intuitive and user friendly.
What I suggest is:
1. (1st option - Ideal) that the selection box can be resized using any of its
boundaries (not only from corners). For example when you put the mouse at any
boundary, the mouse pointer could turn into a double arrow indicating that you
can resize in that axis (something like the “Ideal” in the attached file). But
maybe this is too fancy.. it would still be perfect without the pointer change.
2. (2nd best - if the above is too ambitious) the selection box can be resized
using ANY of its 4 corners (it would look something like the “2nd_best” in the
attached file). In this case the mouse pointer keeps its current behavior (ie
turning into a hair cross when over the “handles” of the selection box.)
Considering that to move the selection box the mouse pointer needs to be
completely inside the selection box, there is no interference or conflicts
between "resizing" and "moving", therefore the borders of the box could be
fully used to resize and the "hand" will only move it.
The above case involves the range selected by a formula. But EXACTLY the same
as I explained can be applied to a regular selection of cells (ie a normal
selection to format cells, without involving any formula.)
More details:
(This is my personal interpretation, so please forgive my misuse or ignorance
of technical terms).
The behavior of the current resize method in Calc is inherited from Excel. In
Excel it makes sense to have only a specific point in the selection box because
the boundary is ALSO used to MOVE the selection box. Therefore the move and
resize are in some sense “in conflict”.
But in Calc, the move is completely different: you don use the boundaries of
the selection box. Therefore why not using the whole selection box for
resize??? This would be a great feature and would make life easier for everyone
in the day-to-day use of LibreOffice spreadsheets.
I included a PDF with hypothetical screen captures. Let me know what you
think!! I would love to see this implemented in Calc!
Thanks for your great contributions, LO Calc ROCKS!!
--
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
