Ask Your Question
0

Is there a way to make the sheet tabs in calc smaller?

asked 2019-09-27 04:02:34 +0100

thryduulf gravatar image

updated 2019-09-27 04:03:39 +0100

I've just installed 6.3.2.2 (the version currently on the main download page) to discover that the sheet tabs now take up approximately double the screen estate they used to. While this is probably a nice thing for those with poor eyesight, where is the option for the rest of us to turn this off? For my needs, the 1-2 rows fewer of data and now-required horizontal scrolling of the tab bar (my most used spreadsheet has 19 tabs) mean the 6.3 GUI is a significant downgrade on 6.2.

edit: This is on Xubuntu Linux, none of my system settings have changed since upgrading.

edit retag flag offensive close merge delete

Comments

I'm not talking about the length of the tab names, default or otherwise so these answers don't help. I'm talking about the font size used for the label and especially the amount of padding around the label. Both of which mean that a tab of the same name takes up much more space in 6.3 than in 6.2 (my tab names are usually as short as I can meaningfully make them anyway, e.g. "Data", "Locatns", "Qtype", "UKwa", etc.).

As I say this is probably good for visually impaired people, but it should be customisable for those of us who are fortunate enough to have eyesight that doesn't require large text and prefer to see data than unnecessary padding (seriously, it's about 2em!).

thryduulf gravatar imagethryduulf ( 2019-09-28 00:44:41 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-09-27 14:15:00 +0100

Pete of Ebor gravatar image

Try looking under Tools > Options > Libre Office Calc > Defaults

Here, you can set the number of sheets (n) and the default sheet name (usually "Sheet") Delete the word "Sheet" and all your sheets on a new document will simply be numbers 1 to n and the tabs will be correspondingly small. The tabs will of course get bigger if you rename them to something more useful.

edit flag offensive delete link more

Comments

Just spotted you use Linux. I usually use Win10, but I've just fired up my old PC using Linux Mint 19, and the paths are the same.

Pete of Ebor gravatar imagePete of Ebor ( 2019-09-27 14:21:05 +0100 )edit
0

answered 2019-09-27 10:44:14 +0100

ebot gravatar image

updated 2019-09-27 14:23:49 +0100

As far as I know, you can not change the width of the tabs. This is only partially true since the width of the tabs depends on the length of the label.

If you want to use short labels permanently, you can enter a short table name in the menu Tools>Options> LibreOfficeCalc>Preferences under the name of new tabs ", eg. "T".

Current tabs can be changed by right-clicking on the tab and choosing Rename table....

If my answer has solved your problem, please click on the checkmark in the circle image description to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.

edit flag offensive delete link more

Comments

With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: 6.3.1.2 (x64).

ebot gravatar imageebot ( 2019-09-27 10:44:31 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-27 04:02:34 +0100

Seen: 67 times

Last updated: Sep 27