Issue 5560 - Add possibility to change color of sheet labels (tabs)
Summary: Add possibility to change color of sheet labels (tabs)
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P4 Trivial with 150 votes (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
Keywords: ms_interoperability, rfe_eval_ok, usability
: 39680 41959 56452 63915 71640 101055 111052 112222 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2002-06-05 02:20 UTC by Unknown
Modified: 2017-05-20 11:42 UTC (History)
19 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

add: HC mode in painting (1.54 KB, patch)
2010-06-14 14:15 UTC, philipp.lohmann
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-06-05 02:20:27 UTC
Is there a way to give the Spreadsheet (Sheets) the tabs at the bottom, Color?
I would like to give each tab a different color and or font.

The font on my windows boxes is real small and hard to read, yet the font in 
linux is fine.  ONLY on the sheets lables.

Thanks for your consideration of this matter.

You guys and Gals are the SHIT !!!!

In case you didn't understand it means AWESOME !!!!

OpenOffice.Org 1.0 is the BOMB that will blow away M$ Office.....


Burt Adjoodani
Comment 1 daniel.rentz 2002-06-05 08:14:50 UTC
Hi Falko,
Comment 2 daniel.rentz 2002-06-05 08:15:08 UTC
Comment 3 peter.junge 2002-06-05 13:15:18 UTC
Hi Burt,

>You guys and Gals are the SHIT !!!!

>In case you didn't understand it means AWESOME !!!!

thanks a lot. But keep on explaining these phrases. We're a
multi-national bunch of people (especially lots of Germans) that may
not get any idiom ;-)

Best regards, Peter

BTW: Good idea.
Comment 4 Unknown 2002-06-05 20:53:59 UTC
Service with a SMILE!

I get an email back within 24 Hours?  You gotta LOVE it!

M$ has never emailed me back anything and I pay freakin toooo much 
$$$ for technet!
THose bunch of money grubbing bastards.  They don't like to share, 
YET they LOVE to STEAL!  That is why they love BSD.  BSD just plain
gives it away and doesn't ask you to give back your enhancements!

ANYway...  If there is something you guys think I can do, let me know.
Maybe help with the Manual...?  Web page?  Etc.  THe last time I 
volunteered was when I was in the Marine Corps.  Then I got my butt 
kicked chest pumped and brain tortured, now I hope to help a worth 
while cause.  An honest to goodness Application that can kick
M$'s tale on their own playground!  And to think OO is only 2 years 
old?!?  M$ Office is a lot older.  

What can be accomplished in the next 2 years?  


Burt Adjoodani
Comment 5 oc 2002-06-26 12:24:04 UTC
This is a non implemented feature and no defect =>Changed issuetype 
to feature.


Regards, Oliver
Comment 6 bettina.haberer 2003-03-17 17:31:17 UTC
Hello Burt, thank you for that issue, it´s a nice idea. 
Because prio 1 is the wrong one (prio 1 only makes sense in cases as
e.g. crashes, freezes, data lossor makes it impossible to create
documents), I had to change it.

Comment 7 falko.tesch 2003-10-15 14:34:29 UTC
Sorry, I know this one is duplicate but I cannot find its brother.
Comment 8 falko.tesch 2003-10-15 14:34:43 UTC
Comment 9 dubiel 2004-07-29 10:03:56 UTC
I have voted for this issue -- colorizing is good -- i have tabs that are date
input, i have tabs that are computations only, and others are output of data --
i would like to use different colors for all of them. 
Comment 10 frank 2005-01-13 16:17:35 UTC
*** Issue 39680 has been marked as a duplicate of this issue. ***
Comment 11 frank 2005-02-03 11:40:32 UTC
*** Issue 41959 has been marked as a duplicate of this issue. ***
Comment 12 arnel 2005-10-12 15:31:58 UTC
This would be a nice enhancement. We are hoping to switch our whole office to
OpenOffice from the WordPerfect suite. For the past year, only IT has been using
OO. With 30 more users switching to OO, it's little convenience features such as
this that potential new users ask for. This issue has been opened since 2002,
hopefully it will get some more attention soon. Thank you.
Comment 13 frank 2005-10-22 23:46:12 UTC
*** Issue 56452 has been marked as a duplicate of this issue. ***
Comment 14 surefire 2005-12-23 18:56:42 UTC
I agree that this is a very useful feature enhancement.  I use colored sheet 
tabs all the time in Excel (for workbooks with multiple sheets).  
Comment 15 bobharvey 2005-12-23 22:58:58 UTC
I had been considering filing an issue for 2.0 on Linux, saying that the 
difference between a white unselected tab and a bright white selected tab is 
not at all clear. 
On reflection, however, I think that this coloured tab idea is a good one, but 
would appeal that the implimentation of it include higher contrast between 
selected and unselected tabs. 
Comment 16 seballa 2006-01-27 09:43:13 UTC
I as well came across this issue because I hate the contrast between 
selected and unselected tabs.  If the tab is very small for example the names
are "1" "2" "3" .... you can hardly see a difference. I neither wanted to open a
new issue for the that if there is a chance of implending what was suggested
here in the near future. If this will still take sometime, it might be a good
idea to just change the color of  a selected Tab to Black with white font color
which should not be to difficult.


Comment 17 Regina Henschel 2006-04-03 15:49:53 UTC
*** Issue 63915 has been marked as a duplicate of this issue. ***
Comment 18 frank 2006-11-17 09:17:51 UTC
*** Issue 71640 has been marked as a duplicate of this issue. ***
Comment 19 8daysaweek 2007-02-08 11:53:30 UTC
This is a feature which is highly visible to end users.  As such, it is
something they will miss if transferring from MSO to OOo, and therefore would be
seen as a deficiency.  So, although not a high priority from a technical point
of view, I think it would be worthwhile to get this included as soon as possible.

As the status is already "Started" should there not be a properly set Target
milestone, rather than "OOo Later"?
Comment 20 8daysaweek 2007-02-08 11:54:39 UTC
Adding myself to CC
Comment 21 alose 2007-03-31 02:39:29 UTC
I just wanted to point out that this is a show stopper issue in my office. 
Everything else works fine, but because we need color tabs, i am unable to use  I really would rather use OOo or Gnumeric, but until this issue is
resolved, I'm stuck with Excel.
Comment 22 bettina.haberer 2007-09-26 15:57:01 UTC
Hi Niklas, these RFEs are in your ownership.
Comment 23 jr 2007-12-11 12:10:00 UTC
Has this issue with 55 votes a chance to be done in 3.x?

cc'ing jrahemipour
Comment 24 uuklanger 2008-01-08 15:32:21 UTC
Heavy users of other spreadsheets do color coding.  I know if this feature was
added, I would use it for each file I create.
Comment 25 okeymor57 2008-05-21 00:29:11 UTC
Is it even possible to color the label name.
Comment 26 frank.loehmann 2008-05-22 09:31:03 UTC
This issue is important and listed on the quarterly review for Calc:
Therefore adjusting target to 3.x.
Comment 27 mlmoushey 2008-10-07 20:53:45 UTC
I'm interested in seeing this one completed also.  It's been here now for over 6
years and appears to have been started 5 years ago.  Any idea when you'll get it
Comment 28 aladdin2k7 2009-01-22 10:37:03 UTC
danielbw has begun some work :
Comment 29 thejb 2009-02-12 01:10:27 UTC
I desire this in OO.

  I know that it can be done, so please, someone, anyone, get it done.

Comment 30 oooforum (fr) 2009-03-09 10:57:19 UTC
Good news! Kohei Yoshida has just checked in to go-oo this feature from Daniel
Watson (thanks to him).

Maybe this will be possible to build it in OOo trunk?

Targeted to next 3.1?
Comment 31 pautrel.dominique 2009-03-09 11:25:46 UTC
Just added vote #128 & 129.

Many thanks to all of you to make this feature a reality.
Comment 32 cno 2009-03-09 15:42:41 UTC
Code freeze for target 3.1 is passed already some time, so that is not possible,
Comment 33 niklas.nebel 2009-03-12 18:21:36 UTC
What are your plans for adding the tab colors to ODF?
Comment 34 kyoshida 2009-03-12 19:26:26 UTC
@nn: I recommended to Daniel to store the color in table's view setting, and
that's how it's working at the moment.
Comment 35 danielbw 2009-03-12 19:37:15 UTC
The patch that was committed to go-oo's trunk includes Kohei Yoshida's contrib-
ution which added support for reading and writing the sheet tab color inform-
ation for the ODS file type.

Please feel free to visit for specs and up to date
info on the feature.

At this point, I feel we need the following:
 * I-Team members for the specification.
 * Someone to commit to writing the help information.
 * Testers to test out the feature in go-oo.
 * QA Dev to lead quality assurance. This includes adding tests for the feature
 * Oasis specs sponsor to amend the Oasis Spreadsheet Spec to add support for
   Sheet Tab Color. The patch already supports reading/writing to ODS but we
   need the Oasis spec amended for completeness.

The specs and patch committed to go-oo should provide enough information to make
these tasks relatively easy. If you really need the patch, I have the latest
patch tarred up and I can provide it to you upon request.

Devs: Please feel free to add to/modify this list.

Thank you,
Daniel Watson
Comment 36 niklas.nebel 2009-03-13 12:28:43 UTC
It should be stored in the view settings only if it is a view setting. Should
the color be local to a view if there are several views open for one document?
Note that this would conflict with undo, with is handled per document.
Comment 37 kyoshida 2009-04-14 17:22:45 UTC
*** Issue 101055 has been marked as a duplicate of this issue. ***
Comment 38 richvegas 2009-06-16 00:52:47 UTC
I really miss this feature in Calc.
Comment 39 kpalagin 2009-06-28 21:00:44 UTC
do you know if anybody submitted request to amend Oasis specification to include
support for colored sheet tabs? When do you think it is reasonable to expect
Oasis spec to specify this feature?
K. Palagin.
Comment 40 carmeops 2009-07-01 15:40:10 UTC
je n'ai que 2 votes possible, mais ces deux votes représentent 20+ utilisateurs
qui utilisaient quotidiennement cette option sous ms office

Comment 41 lady_aleena 2009-07-28 19:49:42 UTC
Please add this as soon as possible. I just installed OpenOffice yesterday and
would like to start moving my Excel files over. I can't do that with all of them
because my tab colors would be missing. I have some spreadsheets with over 20
tabs with the tab color being the only way to differentiate the types of
spreadsheets used in that file. The sooner this can be done, the sooner I can
really start using this program. 
Comment 42 lady_aleena 2009-07-28 19:51:48 UTC
Please add this as soon as possible. I just installed OpenOffice yesterday and
would like to start moving my Excel files over. I can't do that with all of them
because my tab colors would be missing. I have some spreadsheets with over 20
tabs with the tab color being the only way to differentiate the types of
spreadsheets used in that file. The sooner this can be done, the sooner I can
really start using this program. 
Comment 43 afarris01 2009-08-05 23:03:01 UTC
Im sorry if this seems foolish, but doesn't this feature already exist in OOo 3.1? 

I'm running Ubuntu Linux, w/ OOo 3.1.0 (OOO310m11 build 9399) from the official
repos, and I've been using the colored tabs for a few months now.  Just "Rclk
> Tab Color" on a Calc sheet?

works just fine for me, anyway.
Comment 44 kyoshida 2009-08-05 23:42:48 UTC
@danielbw: Daniel, is it okay if we start with the patches that are in go-oo,
and start from there?  We can take care of the integration burden if you prefer.

I think a lot of users need this feature, so it's best to move this nice feature
forward.  Let us know what you think.
Comment 45 kpalagin 2009-08-06 08:54:57 UTC
Ubuntu (and probably most other distros) use different version of OO sources,
the one that is maintained by Sun does not include this feature
in their version (aka vanilla build) because ODF does not have provisionj for
this feature and we can't save color in our native format.
I have suggested this proposal to ODF
(, but
when it will be brought into specification is unknown.
I suggest pushing the proposal using nice guidance in (no
flash-mobbing please).
Comment 46 kyoshida 2009-09-11 20:31:45 UTC
Ok.  I got approval from Daniel (the code author) to contribute his code on his
behalf, so I'll work on upstreaming his code so that we can work our the
remaining issues with it (if any).

He has already signed SCA, so with his written approval, we can go ahead with this.
Comment 47 kyoshida 2009-09-17 20:54:20 UTC
re-assigning to myself for the integration work.
Comment 48 kyoshida 2009-09-18 03:04:36 UTC
Just committed and adjusted Daniel's patch against the latest milestone.  But
the part for the oox module needs to be re-worked a bit since a lot has changed
in that module.

BTW, undo/redo works just fine as-is.
Comment 49 kyoshida 2009-09-18 03:06:36 UTC
Forgot to mention that, the work is on-going in the calctabcolor cws.
Comment 50 kyoshida 2009-09-18 03:17:06 UTC
Ah, when you open a new window of the same document by Window - New Window, then
the same document can have multiple views.  In that case, the current
implementation goes out-of-sync in different views.
Comment 51 kyoshida 2009-09-18 18:27:49 UTC
Ok.  Finished re-working the xlsx import filter.  For now, the tab colors are
still treated as view properties, but we'll switch to treating them as sheet
model properties later once we get ODF TC's blessing.
Comment 52 kyoshida 2009-10-28 21:44:17 UTC
I've just submitted ODF file format change proposal.  You can see the detail of
my proposal here:
Comment 53 zulut 2010-01-03 14:49:21 UTC
FYI, MS Office 2007 does this and so the importer for .xlsx should be able to
get/set the color.  In the .xlsx format, the property is:

Comment 54 kyoshida 2010-02-22 15:22:21 UTC
Chaning the title, as we are not going to add an option changing the tab font,
at least not in this cycle.  That needs to be handled as a separate issue.
Comment 55 kyoshida 2010-02-23 20:29:55 UTC
The wiki spec page is now available here:
Comment 56 kyoshida 2010-02-24 04:18:12 UTC
Ok.  I'm done.  This is now fixed in the calctabcolor cws.
Comment 57 kyoshida 2010-02-24 04:20:02 UTC
Re-assigning to oc for qa verification.
Comment 58 danielbw 2010-02-24 04:38:14 UTC

    Thanks so much for all of your help.

Comment 59 kyoshida 2010-02-24 04:52:24 UTC
It was my pleasure, Daniel!
Comment 60 kpalagin 2010-02-24 23:34:03 UTC
thanks a lot for all your work!

"Note that the tab color attribute is only saved in the extended 1.2 ODF format. "
do you mean to say that color property will not be saved in .xls?
Comment 61 kyoshida 2010-02-25 00:13:10 UTC
>do you mean to say that color property will not be saved in .xls?

No, that's not what I meant.  The colors will be saved in the xls format safe
and sound since the xls format already supports tab colors.  So, no need to
extend its format specification there. ;-)
Comment 62 Regina Henschel 2010-04-21 21:13:54 UTC
*** Issue 111052 has been marked as a duplicate of this issue. ***
Comment 63 laurent_contact_81 2010-05-08 16:27:47 UTC
Is there any confirmation that version 3.3 will able colored tabs ?
Comment 64 Rainer Bielefeld 2010-06-10 05:10:40 UTC
*** Issue 112222 has been marked as a duplicate of this issue. ***
Comment 65 niklas.nebel 2010-06-10 17:49:25 UTC
In "high contrast" mode, we must not show the colors. This is important for

Some other problems:

- The general handling for file format additions is that when loading a file, we
should allow the new attribute in both the table and tableooo namespace.

- Undo for deleting a sheet doesn't restore the color.

When a sheet is copied, shouldn't the the color also be copied?

Maybe pl also wants to take a look at the TabBar changes.
Comment 66 philipp.lohmann 2010-06-11 16:56:26 UTC
I think the TabBar should be fine by adding this patch to TabBar's Paint method

@@ -1141,7 +1141,7 @@
-                    if ( !pItem->IsDefaultTabBgColor() )
+                    if ( !pItem->IsDefaultTabBgColor() && ! 
StyleSettings.GetHighContrastMode() )
                         SetFillColor( pItem->maTabBgColor );
                         SetTextColor( pItem->maTabTextColor );

I'll try that and provide an according complete patch taking HC into account.
Comment 67 philipp.lohmann 2010-06-14 14:15:20 UTC
Created attachment 69982 [details]
add: HC mode in painting
Comment 68 philipp.lohmann 2010-06-14 14:18:55 UTC
@kohei: if you like that patch, I can push it
Comment 69 kyoshida 2010-06-14 14:45:59 UTC
@pl: Looks good to me.  Please go ahead and push.
Comment 70 philipp.lohmann 2010-06-14 15:30:27 UTC
Comment 71 kyoshida 2010-06-15 03:49:23 UTC
The three issues that nn raised should be all fixed now.

* The import filter picks up the table:tab-color attribute names in addition to
the tableooo:tab-color names.

* Undo for deleted sheets should restore tab colors.

* Copying of a sheet should also copy the tab color.
Comment 72 niklas.nebel 2010-06-16 09:47:57 UTC
Comment 73 niklas.nebel 2010-06-16 09:48:38 UTC
I looked at this and it's good now. So I'll take the QA role and mark it as
Comment 74 morvan_br 2010-06-18 14:58:36 UTC
I put my name on CC, to know the status of this issue.