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.