Velvet Star Monitor

Standout celebrity highlights with iconic style.

general

OpenOffice Calc - Sheet Tabs and Buttons

Writer Andrew Mclaughlin

The sheet tabs in Open Office Calc appear very pixelated to me. Also the buttons to change tabs are very tiny.

Screenshot:
alt text

Is there a way to fix this appearance? All the functionality is there, but it's bugging me. Hopefully this helps some other people too.

3 Answers

I had a similar problem, and even though the question is old, I want to provide another answer:

The sheet tabs height is defined by the width of the GTK themes scrollbar. I guess you're using Ambience, Ambience's scrollbars are a bit smaller than usual ones, so the sheet tabs get distorted.

I use a GTK theme with tiny scrollbars (Orta), so those sheet tabs were barely visible.

If you use another GTK theme, for example Clearlooks, it will look normal again. If you don't want to change your whole Desktop to another theme, you can start libreoffice/openoffice in a terminal with this command:

GTK2_RC_FILES=/usr/share/themes/Clearlooks/gtk-2.0/gtkrc libreoffice

Of course you can replace Clearlooks with any other theme that suits you more.

I created some launchers, so I don't have to do that every time. To do this, copy the original launchers anywhere into your home folder. They should be in /usr/share/applications/.

Make your copied launcher(s) executable by right clicking on it in a file manager and going to "properties". From there look in the "access rights" tab and click "mark as executable."

Or in the terminal, change directory to your folder and use chmod +x:

cd ~/YOURDIRECTORY
chmod +x libreoffice*

And now you have to edit each of them (right click - properties) to add the specific GTK theme to the beginning. Add env GTK2_RC_FILES=/usr/share/themes/Clearlooks/gtk-2.0/gtkrc in front of the command. It should look like this:

env GTK2_RC_FILES=/usr/share/themes/Clearlooks/gtk-2.0/gtkrc libreoffice %U
env GTK2_RC_FILES=/usr/share/themes/Clearlooks/gtk-2.0/gtkrc libreoffice --writer %U
env GTK2_RC_FILES=/usr/share/themes/Clearlooks/gtk-2.0/gtkrc libreoffice --calc %U
…

Copy these launchers to ~/.local/share/applications/.

Now libreoffice should look fine.

2

Here's an answer that works well (tested on Ubuntu 14.10), taken from an older ubuntu forum post:

Edit the ~/.gtkrc-2.0 file, and add the following into it:

style "scroll"
{
GtkScrollbar::slider-width = 25
}
class "*" style "scroll"

You can modify the value (25) to something else in order to influence the width of scroll-bars, and therefore also the size of Calc's sheet-tabs.

Try to install / use other themes like explained here:

You need to download themes or styles for OpenOffice via Synaptic. There are several themes (styles) available, such as: default, crystal, human, tango, industrial. In Synaptic, search for "openoffice.org" and scroll down to "openoffice-style-default" or any other styles you prefer (I installed everything), and mark for installation, then you will have it.

Or if it is already downloaded then launch openoffice writer: Tool --> Options --> Under "OpenOffice.org" --> View --> Icon Size and Style

You could choose the style there. I personally prefer "default" for XP and Ubuntu. Clean interface.

Source:

3

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy