This is a static archive of the old Zorin Forum.

The information below may be outdated. Visit the new Zorin Forum here ›

If you have registered on the old forum, you will need to create an account on the new forum.

(SOLVED) LibreOffice Calcsheet tab size

gtobill

Sat Jan 24, 2015 5:30:39 pm

In LibreOffice calc the size of the sheet tabs is very small - the font is almost unreadable,

There is a simple method to change it in editing [in the terminall] the gtkrc file which is read only.
On a previous install I have done this once successfully but have lost my instructions.

Does anyone have a step-by-step how-to on this?

The file edit has something to so with these lines:
GtkScrollbar ::has-backward-stepper = 0
GtkScrollbar ::has-forward-stepper = 0
GtkScrollbar ::min-slider-length = 15
GtkScrollbar ::slider-width = 5
GtkScrollbar ::trough-border = 3
GtkScrollbar ::activate-slider = 1

and changing/adding to something like this:
style "large_scrollbar"
{
GtkScrollbar::slider-width = 15
GtkScrollbar::trough-border = 3
}
widget_class "*" style "large_scrollbar"

Thanks in advance for any help

Wolfman

Sat Jan 24, 2015 7:31:47 pm

Hi,

not really sure but you can try installing the package "overlay-scrollbar" if not already installed via the terminal (Ctrl + Alt + t) and see if that helps:

Code:
sudo apt-get install overlay-scrollbar


There are 2 further packages if that one doesn't work, you can try either:

overlay-scrollbar-gtk2

or

overlay-scrollbar-gtk3

Let us know if it helps. :D

gtobill

Sat Jan 24, 2015 9:03:00 pm

Hi Wolfman, Thanks for your suggestions.

I tried overlay-scrollbar and it installed
overlay-scrollbar-gtk2 and it installed and then wanted me to run autoremove for unnessecary files [ a lot associated with other apps as well]

In both cases after the intstall I checked a speadsheet and there was no change in the tab size. I shut down LibreOffice and restarted. No luck and then I did a restart of Zorin again no changes.

Next I tried to install overlay-scrollbar-gtk3 and got this message:
Building dependency tree
Reading state information... Done
overlay-scrollbar-gtk3 is already the newest version.
overlay-scrollbar-gtk3 set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.
qz@qz-Vostro-1000:~$

Next Step: how does one manually install overlay-scrollbar-gtk3?

Just for reference here is a screenshot of my sheet tabs
Image

Wolfman

Sun Jan 25, 2015 7:07:26 am

Hi,

I found this but it only refers to using "Elementary Theme" so you may have to install that for it to work:

http://howto.blbosti.com/2010/12/elemen ... breoffice/

Also:

http://askubuntu.com/questions/138623/s ... -too-small

Some good suggestions here although a tad old!:

https://bugs.launchpad.net/egtk/+bug/1013484

gtobill

Sun Jan 25, 2015 8:24:28 pm

Hi Wolfman, You have found what I was looking for. Thanks!
/usr/share/themes/ZorinLight/gtk-2.0 and opened gtkrc But could only View as it is write protected.
So in Terminal as su I used nano
nano /usr/share/themes/ZorinLight/gtk-2.0/gtkrc and I then edited and save the file.
I changed the value of from 5 to 25
GtkScrollbar ::slider-width = 25
which made a really big change
Image
so I switched down to 10
Image

Swarfendor437

Sun Jan 25, 2015 11:54:54 pm

Hi Wolfman - time to start a LibreOffice Tips thread! ;)

Wolfman

Mon Jan 26, 2015 2:26:38 pm

Hi gtobill,

glad to be of help, will mark this as solved!. :D

@Swarf, I don't use it enough to be able to write a full how-to, they have it covered for the most part with their list of manuals!:

http://www.libreoffice.org/get-help/documentation/

A zillion links here:

https://wiki.documentfoundation.org/Main_Page