I am having an issue with using the fill handle in calc. When I try to use the fill handle to fill cells, the sheet starts scrolling to the top, regardless of cursor position, causing me to fill cells above the source by accident. Is there a way to fix this, or turn off the scrolling with the fill handle in lieu?
Do you use a mouse or touchpad?
Do you need to duplicate the cell content, the cell style, both?
Please, edit your question and share the version information for your system (you will find a copy button at menu Help - About LibreOffice). Thanks.
Mouse, there is a touchpad which is disabled with the mouse plugged in.
Iām working on a laptop running a fedora 41 fork with the latest libre office available. Iāll pull the version number tomorrow.
Iām looking to replicate the cell contents with incrementing, for example;
A A B C
Row 1 [01] becomes [01][02][03]....
While Iām aware there is a hotkey way to do this, I would like to keep using the fill handle (at least thatās what excel calls it) if at all possible.
So, you want to fill to the right, and LibreOffice insists filling upward.
Can you try in Safe Mode (menu Help)?
Yes, thatās the correct name in LibreOffice also.
Cant figure out how to edit the origional post. āeditā button doesnt let me change anything on the main post.
Version: 25.8.1.1 (X86_64) / LibreOffice Community
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 12; OS: Linux 6.16; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded
Sort of. When i grab the fill handle, the page scrolls to the top regardless of mouse position. So no matter which way I attempt to fill, if what Iām trying to fill is below what is visible while scrolled all the way up I get dragged to the top and canāt get to the desired cells.
Itās behaving similarly to how it would if you tried to drag something off screen and used mouse edge scrolling, but without my mouse being anywhere near the edge of the visible part of the worksheet.
The pencil icon below your question. See This is the guide - How to use the Ask site? - #3 by Hrbrgr
Have you tested in Safe Mode?
I dont have that button there, I have [share] [bookmark] [suggest a solution] [comment]. Looking at the guide you shared, Iām also missing the āmoreā button. For what itās worth, I do have those buttons on my own replies, just not the origional post.
Just did, same effect.
Welcome to ask LibreOffice.
As a new user you have fewer privileges so you cannot edit your own post after 24 hours, see the Discourse page, Understanding Discourse Trust Levels
It doesnāt take too much participation to go up a level. Cheers, Al
1 Like
I checked on my desktop and it does the same thing there.
This seems to be Wayland-specific. If I run GDK_BACKEND=x11 libreoffice --calc, forcing it to run using Xwayland, it seems to work fine
I was having the same problem. Then I was pointed at this post. So I just tried it again to see if restarting in safe mode would fix it. I opened my spreadsheet and copied two columns into a new spreadsheet (to avoid any possible corruption of my original), tried the fill down and it worked perfectly! So I went back to my original spreadsheet and tried it again there. Again, it worked perfectly. Iām confused to say the least. I never touched nuffink guv, honest. The only thing I have done is reboot. Maybe the old āturn it off and turn it on againā trick has worked for me this time.
I use CachyOS (Arch based)
LO Info
Version: 25.2.7.2 (X86_64) / LibreOffice Community
Build ID: 75ea2c28000e31be7a59c87663c143f9f83cd1b9
CPU threads: 4; OS: Linux 6.17; UI render: default; VCL: kf6 (cairo+wayland)
Locale: en-AU (en_GB.UTF-8); UI: en-US
25.2.7-2.1
Calc: threaded