Coloring tabs in Calc

Share Button

I just checked in to go-oo trunk the latest patch from Daniel Watson that enables coloring of sheet tabs in Calc. With his latest patch, the tab color dialog looks more compact and polished, which I definitely prefer over the previous version.

In case it’s not obvious how to use this feature, here are some screenshots to show how.

In the context menu on the sheet tab, there is now a new entry called Tab Color.

Select that menu to bring up the color palette dialog.

Select a color and click OK. The sheet tab now has a sliver of color at the bottom. When you switch to another sheet, you’ll notice that the tab you just colored is now filled entirely with that color. And when you color all of your tabs, you’ll get something like this:

Pretty cool huh?

BTW Daniel did this almost entirely on his own, with just a teeny bit of help from Eric Bachard and myself. He is very thorough and the quality of his code is pretty high. He maintains the spec for this feature right here. He is also anxious to get this feature upstreamed, and judging by the kind of reaction he is getting from the upstream Calc team, I’m pretty sure this feature is on a fast track to upstream acceptance. ;-) Great job Daniel!

Oh, one last thing. Please try out this feature and test it out.

About Kohei Yoshida

LibreOffice hacker, spreadsheet nerd, and machine learning beginner.
This entry was posted in and tagged , , . Bookmark the permalink.

7 Responses to Coloring tabs in Calc

  1. Mario Rivera says:

    Hi!

    This patch loocks very good, but i’m trying to test without results

    I try copying the macros listed in Eric Bachard’s page

    I apreciate if you can help me how i can do that

    Thanks

  2. Kohei Yoshida says:

    Hi Mario,

    This patch is in Go-OO build, so you need to somehow get a hold of one of Go-OO builds. What platform are you on? If it’s Linux, then try to find a beta build of 3.1 which is most likely a Go-OO based. For example, for openSUSE, there is a beta build available from the OpenOffice.org UNSTABLE repository:

    http://en.opensuse.org/Additional_YaST_Package_Repositories#OpenOffice.org_UNSTABLE

    We just released the beta3 source packages, so other distros may start providing a binary package from it.

    Let me know if this helps.

    Kohei

  3. Mario Rivera says:

    Thanks.

    I use Ubuntu, Gnome i think because i use Fvwm-Crystal

    This weekend i give a try looking a beta build

    This beta had to be Go-oo and how i determine if it’s not OO

    Thaks for your answer

  4. Avi Alkalay says:

    I just installed BrOffice.org 3.1 and this feature is not there yet.

    :-(

  5. Morvan says:

    Hi, Kohei. And what about to make this feature randomic, as in Firefox (with an extension called “ColourFullTabs”)? In Firefox, with ColourFullTabs installed, the Browser puts at random the colour of the tabs. If you want, you can change individually each colour of them.
    Nice Feature. Nice idea.

    Cheers,

    Morvan, Linux User #433640

  6. Marco says:

    How can i try this patch out (Windows), where can i download this patch?

    Marco

  7. Kohei Yoshida says:

    Right now, you can either try Go-OO (http://go-oo.org/download/ there is a Windows version) or try to build your own from the sources from the calctabcolor cws (http://hg.services.openoffice.org/cws/calctabcolor).

Comments are closed.