Bug 67592 - SELECTING: allow to resize selection box from any corner
Summary: SELECTING: allow to resize selection box from any corner
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: All All
: highest enhancement
Assignee: Not Assigned
Whiteboard: target:4.2.0
: 69133 75073 (view as bug list)
Depends on:
Reported: 2013-07-31 16:49 UTC by J22Gim
Modified: 2014-02-17 03:10 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Here I show how the suggested feature would look like (two alternatives) (1.19 MB, application/pdf)
2013-07-31 16:49 UTC, J22Gim
Ideal situation: each of the 4 borders of the selection box can be used to resize it. When the mouse is over the boundary, it turns into a two-sided arrow indicating that if you click and drag you will move the boundary of the selection. (396.69 KB, image/jpeg)
2013-08-03 17:47 UTC, J22Gim
2nd best alternative: the four corners of the selection box are "resizing handles" (405.57 KB, image/jpeg)
2013-08-03 17:48 UTC, J22Gim

Note You need to log in before you can comment on or make changes to this bug.
Description J22Gim 2013-07-31 16:49:50 UTC
Created attachment 83382 [details]
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!!
Comment 1 J22Gim 2013-07-31 16:52:02 UTC
I think this could be a nice improvement...
Comment 2 J22Gim 2013-08-03 17:47:55 UTC
Created attachment 83590 [details]
Ideal situation: each of the 4 borders of the selection box can be used to resize it. When the mouse is over the boundary, it turns into a two-sided arrow indicating that if you click and drag you will move the boundary of the selection.
Comment 3 J22Gim 2013-08-03 17:48:38 UTC
Created attachment 83591 [details]
2nd best alternative: the four corners of the selection box are "resizing handles"
Comment 4 J22Gim 2013-08-03 18:00:30 UTC
Actually now I'm thinking that the 2nd best is maybe the best option, because by handling from one corner you can change the selection in both directions in the same action. Eg if you want to include more columns AND more rows, you can do it by handling the size from the corner...

But enough of talking alone here :)
Comment 5 Commit Notification 2013-08-08 21:14:04 UTC
Tomaž Vajngerl committed a patch related to this issue.
It has been pushed to "master":


fdo#67592 Resize selection box from all 4 corners

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Comment 6 Tomaz Vajngerl 2013-08-12 14:22:36 UTC

I implemented the 2nd option - you can check this out in the daily build. 

Regards, Tomaž
Comment 7 J22Gim 2013-09-05 22:19:13 UTC
I can't see it implemented, exactly which version do I have to test? This is the one I tested:

Build ID: aa9bef8271ed50a397c959ed53c91ee44b3dcb1
TinderBox: Win-x86@6-debug, Branch:libreoffice-4-1, Time: 2013-09-03_11:55:14
Comment 8 Tomaz Vajngerl 2013-09-06 07:28:19 UTC
This will be in LO 4.2 as it is an enhancement so you need a daily build to test this [1].

Regards, Tomaž

[1]: http://dev-builds.libreoffice.org/daily/master/Win-x86@6-debug/
Comment 9 Tomaz Vajngerl 2013-09-09 09:31:43 UTC
*** Bug 69133 has been marked as a duplicate of this bug. ***
Comment 10 J22Gim 2013-09-11 09:40:02 UTC
I have tried two times already with different daily builds and it crashes when I resize the selection.

What I do is
- type eg 5 numbers in a column
- place a formula in any cell with SUM(range)
- resize the selection box
- press ENTER
- Calc crashes.

I'm using Version:
Build ID: a8865e5df62b5f33aa769d459b9823eb5b110d4b
TinderBox: Win-x86@6-debug, Branch:master, Time: 2013-09-03_14:36:22
Comment 11 Tomaz Vajngerl 2013-09-11 10:34:50 UTC
I don't think this is related to this feature - it may be a recent bug. I will take a look what is causing the problems.
Comment 12 Tomaz Vajngerl 2013-09-11 11:23:42 UTC
I think I found the problem and fixed it in master. It should work as expected in the next available daily build.
Comment 13 J22Gim 2013-09-13 13:59:25 UTC
sorry to say it still doesn't work.. keeps crashing.
Comment 14 Tomaz Vajngerl 2013-09-13 14:57:19 UTC
There was no new successful windows daily build for quite some time.. I am not sure my fix is included in any of the available ones. Let's wait for the next successful daily build.
Comment 15 Tomaz Vajngerl 2013-10-08 07:45:03 UTC
The functionality is now in daily builds.
Comment 16 Victor Krymskiy 2013-10-12 09:54:58 UTC
(In reply to comment #15)
> The functionality is now in daily builds.

I tested it on this buld (under Ubuntu):

Build ID: b1caf176a44b6979d2e0ea47f495a3dacf86e197
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2013-10-12_06:04:49

The corners are moving in spite of the fact the sum is not calculating. By the way it seems to be working.
Comment 17 Mateusz 2013-11-26 09:20:15 UTC
GNU/Linux Mint 15 and LO 4.1 beta1.

Build ID: f4ca7b35f580827ad2c69ea6d29f7c9b48ebbac7

I don't see any changes.
Comment 18 J22Gim 2013-11-26 13:00:19 UTC
I don't see it implemented...
I'm using 
LO Version:
Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a

Win7 x64
Comment 19 Tomaz Vajngerl 2013-11-26 13:55:45 UTC
J22Gim: For the second time - you need LO 4.2 if you want to test this. This will never be in LO 4.1 as it is a enhancement and not a bug.
Comment 20 J22Gim 2013-11-27 21:36:03 UTC
Tomaz Vajngerl: sorry, and yes!! it works!! thanks!!

Build ID: 1de7d0aba4142424fe0082071a4ac64ec377cea0
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2013-11-27_00:02:42
Comment 21 m_a_riosv 2014-02-17 03:10:56 UTC
*** Bug 75073 has been marked as a duplicate of this bug. ***