Description: When I drag a cell to perform sequential auto-fill, if the data contained in the sheet is not at the beginning of the sheet, while I drag the page it returns to the initial cells of the sheet Steps to Reproduce: 1. Enter a number in cell A100 2. Drag to autofill 3. The page jumps and returns to the top cells Actual Results: The page jumps and returns to the top cells Expected Results: autofill Reproducible: Always User Profile Reset: No Additional Info: None
I can't reproduce Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded Please test in safe mode, Menu/Help/Restart in Safe Mode Please paste here the information on Menu/Help/About LibreOffice (There is an icon to copy) Also, please detail exactly how you are dragging.
I'm also experiencing this. The bug appears to be triggered when dragging off the bottom edge of the visible spreadsheet, drag to fill works fine when the mouse cursor remains in the visible spreadsheet. I'm triggering the autofill function by making a selection of a few cells, and dragging from the handle at the bottom right corner of the last cell to be added to the selection. While the mouse cursor is in motion, the 'drag destination' keeps being set somewhere else. Sometimes the autofill region will move to the top of the current column, sometimes to the left of the current row. The autofill area pops between one of these incorrect destinations and the destination given by the cursor, as though two different routines are alternating in which sets the extent of the autofill region. If I leave my cursor stationary near just off of the bottom edge of the spreadsheet, it will extend the autofill selection downward by one row every few seconds, which seems like the expected behaviour. So this seems to be triggered by mouse motion. Version: 25.8.1.1 (X86_64) / LibreOffice Community Build ID: 54047653041915e595ad4e45cccea684809c77b5 CPU threads: 12; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: en-CA (en_CA.UTF-8); UI: en-US Flatpak Calc: threaded
Hmm, I realize the version of LibreOffice I was running was a little out of date. I just patched it to the latest available on my package manager. The issue is still present, but it isn't nearly as bad. While dragging an autofill region off of the bottom edge of the visible spreadsheet, the region selection will occasionally snap to the top of the spreadsheet, but much less frequently. Version: 25.8.3.2 (X86_64) / LibreOffice Community Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 12; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: en-CA (en_CA.UTF-8); UI: en-US Flatpak Calc: threaded
Created attachment 205398 [details] Video demonstrating behavior since LibreOffice 26.2 I don't think I was experiencing this bug in LibreOffice 25.8.x and older, but now I am suddenly facing this bug (or a variant of it) with LibreOffice 26.2.x, in a very erratic and annoying way that makes autofill pretty much unusable. I thought it was a 26.2 regression, until I saw this report here. See attached video. In my case I don't have to be dragging near the bottom edge of the window at all, I could be in the middle of the window and autofill would make the scrollbars jump like that. One thing that may be worth noticing when pausing the video is that in the GTK3 version there's a popover widget to indicate the content of the cell that would be autofilled, I wonder if this has any influence. It happens on a spreadsheet with 1000 rows, but not on a spreadsheet with 3-4 rows of data. Tested on Fedora 43's GNOME 49.3 Wayland with a mouse (not touchpad), with: Version: 26.2.0.3 (X86_64) Build ID: afbbd0df0edb6d40b450b0337ac646b0913a760c CPU threads: 8; OS: Linux 6.18; UI render: default; VCL: gtk3 Flatpak Calc: threaded
Setting as NEW according to comments 2,3,4.