Ask Your Question

How can I select a Calc sheet without it dragging the contents? [closed]

asked 2017-11-27 17:46:08 +0200

bulgogikitchen gravatar image

Using: Fedora 26, LibreOffice v5.3.7.2, ODS format.

Normally I would be able to left-click a sheet at the bottom of a Calc document, and it would switch sheets. The issue is when a sheet is left-clicked, the sheet will change to the desired selection, but will also grab onto the sheet and be attached to the mouse. This means I need to hit ESC to release the contents, left-click onto the sheet contents to release the contents, or left-click on the sheets bar which rearranges the sheet order.

Could there be a Libre setting, which affects this behavior?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by bulgogikitchen
close date 2017-11-29 22:25:33.106947

1 Answer

Sort by » oldest newest most voted

answered 2017-11-27 17:57:06 +0200

librebel gravatar image

Hello @bulgogikitchen,

instead of clicking with the mouse, you could also select a Sheet by keyboard:

CTRL+PageUp goes to the previous sheet;

CTRL+PageDown goes to the next sheet.

HTH, lib

edit flag offensive delete link more


Not only does this get around the problem for me, but oddly enough, after using the hotkey the problem immediately disappeared. Now I can click sheets with normal behavior. Thanks!

bulgogikitchen gravatar imagebulgogikitchen ( 2017-11-29 22:25:11 +0200 )edit

Hehe that's great to read :)

librebel gravatar imagelibrebel ( 2017-11-29 22:38:03 +0200 )edit

Question Tools

1 follower


Asked: 2017-11-27 17:46:08 +0200

Seen: 40 times

Last updated: Nov 27 '17