Ask Your Question

Increase Font Size of Calc Formula Toolbar in LibreOffice Version 6

asked 2018-02-13 14:37:47 +0100

Steve R. gravatar image

The upgrade to LibreOffice version 6 seems to have eliminated the ability to adjust the font size of the Calc Formula Toolbar. It needs to be increased to improve legibility. The ability to modify the size of the formula toolbar, in prior versions of LibreOffice, was previously addressed in: How do you increase fontsize on the LibeOffice toolbar and dropdown menus? Apparently that answer no longer applies to LibreOffice version 6. The scaling option appears to have been depreciated. How can the font size of the Calc formula toolbar be increased to make more legible?

image description

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-02-13 14:55:37 +0100

updated 2018-02-13 15:28:17 +0100

The change happened in 2016 (this commit), and was introduced in version 5.3. It is because the feature to scale UI elements is a standard feature of all OSes and desktop environments, and LibreOffice obeys the OS settings. So users who need to have enlarged UI, should use OS-provided means to do that.

Links that Google provided:

edit flag offensive delete link more


What does "So users who need to have enlarged UI, should use OS-provided means to do that." mean? How can the font size of the toolbar be increased?

Steve R. gravatar imageSteve R. ( 2018-02-13 15:16:51 +0100 )edit

You didn't provide details about your OS. As I said, you should use your OS features to scale the UI, but I have no means to tell you how it is done in your OS without knowing which is that (and even when I know, there's no guarantee that I know the details about that specific OS - you should consult your OS manuals).

Mike Kaganski gravatar imageMike Kaganski ( 2018-02-13 15:20:31 +0100 )edit

My apologies. Linux. Specifically Ubuntu 16.04

Steve R. gravatar imageSteve R. ( 2018-02-13 15:50:15 +0100 )edit

Found the answer. Need to use the Tweak Tool. Fonts --> Scaling Factor. See: "How do I change fonts and adjust their size?"

Steve R. gravatar imageSteve R. ( 2018-02-13 15:58:28 +0100 )edit

@Mike Kaganski. I have Kubuntu 18.10. KDE Frameworks: 5.50.0. KDE Plasma v. 5.13.5. How do OI change the font size of the formula bar? None of the options in System Settings->Fonts work

raffam gravatar imageraffam ( 2018-12-20 12:42:29 +0100 )edit

answered 2019-04-17 20:37:12 +0100

I am using Galliium OS on an Acer 14" Chromebook, CB3 431. I recently installed version 3.0 beta. It is based on Xumbuntu 18.04. Working OK, except that in LibreOffice the toolbar icons are tiny and the text in the data entry window (input line) as well. Very hard to read. I can change the size of fonts in the spreadsheet cells. I can drag the border to increase the height of the input line, but the text remains tiny. I have gone to Tools, Options, View and changed the Toolbar Icon Size. If I put it to "large" it's somewhat better but still too small. If I put it to "Extra Large" the icons disappear and are replaced by grey patches that extend laterally off the page. I have gone into the settings menu of GalliumOS and changed the icon size and font size for menu displays. But it does not effect the input line or icons on the toolbars in LibreOffice.

Looking for suggestions.

edit flag offensive delete link more

answered 2019-01-15 19:23:25 +0100

I'm commenting here because I searched the web for months looking for a solution, and I grew tired of looking. As far as I can tell, it seems there is no solution in sight for recent versions, and since the Option->View->User interface disappeared, there is no way for users to change this setting.

For all those with reasonably modern monitors (i.e., newer than 2015) or all visually impaired people, it is a serious usability issue.

The suggestion of Steve R. above is a quick fix but it's a fall-back, not a real solution (it does not work for people using desktop environments other than Gnome, like KDE on Linux or Windows, for that matter).

I've re-opened the bug discussing this, I hope people will comment and provide feedback for it.

edit flag offensive delete link more


Don't know about other OSes, but surely it's possible for Windows (I did that). Also there are links about KDE and macOS. Please don't declare what is obviously not true.

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-15 19:29:14 +0100 )edit

Thanks for taking the time to reply here. That's great, actually! I wasn't able to find any solutions for KDE, that's why I commented. Could you please share it so I can test it?

Ntropia gravatar imageNtropia ( 2019-01-15 19:35:37 +0100 )edit

Did you read my answer above with the links? or did you try them, and they didn't help? then first mention that, and describe what was wrong.

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-15 20:03:01 +0100 )edit

My bad, I thought you were referring to something different. I'm sorry if that made you nervous.

As I mentioned in my comment, I've tried that, yes, and does not work for KDE. Also, by keeping googling, I found that the problem is present also on Macs.

I'm open to any suggestions, if you have any.

Ntropia gravatar imageNtropia ( 2019-01-15 23:21:26 +0100 )edit

In case somebody is looking for more information, here's the correct bug report, where they mention the issues of setting the font size across different DE's.

Ntropia gravatar imageNtropia ( 2019-01-15 23:56:25 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-13 14:37:47 +0100

Seen: 2,102 times

Last updated: Apr 17 '19