Bug 154578 - Fill square is reduced when pulling selection with CTRL pressed
Summary: Fill square is reduced when pulling selection with CTRL pressed
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Balázs Varga (allotropia)
URL:
Whiteboard: target:7.6.0
Keywords:
Depends on:
Blocks: AutoFill
  Show dependency treegraph
 
Reported: 2023-04-03 06:53 UTC by Gabor Kelemen (allotropia)
Modified: 2023-05-19 05:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc (8.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-04-03 06:53 UTC, Gabor Kelemen (allotropia)
Details
Normal behavior when moving the mouse downwards (38.42 KB, image/png)
2023-04-03 06:54 UTC, Gabor Kelemen (allotropia)
Details
Problematic behavior when pulling the mouse accidentally upwards (34.57 KB, image/png)
2023-04-03 06:54 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2023-04-03 06:53:54 UTC
Created attachment 186425 [details]
Example file from Calc

Attached example file contains some rows of numbers.
When a range containing the last few rows is selected, the CTRL is pressed and the mouse is moved upwards, the magenta rectangle indicating the target range shrinks to the first row of the range and autofilling downwards becomes impossible.

1. Open attached file
2. Select the range C12:H14 with the mouse
3. Press CTRL (so that values auto-increment would be disabled), then click the bottom right autofill square. The magenta fill-target-indicating rectangle appears around the selected range.
4. Move the mouse (accidentally) upwards a bit.

-> The magenta rectangle shrinks to the C12:H12 range and can be moved only horizontally, and filling does not work either.

Expected: the magenta rectangle does not shrink (or can be vertically grown), can be pulled downwards, as the normal user intention would be.

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 8e97ef854fb225dac37185c1911894b7d206fa8d
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: default

also happens in old 4.0 version, so likely not a regression.
Comment 1 Gabor Kelemen (allotropia) 2023-04-03 06:54:18 UTC
Created attachment 186426 [details]
Normal behavior when moving the mouse downwards
Comment 2 Gabor Kelemen (allotropia) 2023-04-03 06:54:48 UTC
Created attachment 186427 [details]
Problematic behavior when pulling the mouse accidentally upwards
Comment 3 ady 2023-04-03 19:05:10 UTC
I'd like to point out that if you change the order of the steps, by first using the mouse and, without releasing it, _then_ press the [CTRL] key, then the actions are performed as expected.

IOW, if you first press [CTRL] before grabbing with the mouse, there seems to be a problem. But, if you start first with the mouse and then press [CTRL] before releasing the former, then all should work.
Comment 4 Buovjaga 2023-04-06 12:11:32 UTC
NEW per comment 3
Comment 5 Commit Notification 2023-04-21 12:25:01 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/0293724d05953be608287629ed6178a7c05383a6

tdf#154578 sc fix: fill square is reduced when pulling selection with CTRL

It will be available in 7.6.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 ady 2023-04-27 10:09:13 UTC
(In reply to Commit Notification from comment #5)
> Affected users are encouraged to test the fix and report feedback.

Works as expected now in 7.6.alpha.