Hi Falko,
one4you

.

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.

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?  


Sincerely,


Burt Adjoodani
CIO

This is a non implemented feature and no defect =>Changed issuetype 
to feature.

PLEASE DO NOT CHANGE FLAGS WITHOUT COMMENT

Regards, Oliver

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.

Sorry, I know this one is duplicate but I cannot find its brother.

started

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. 

*** Issue 39680 has been marked as a duplicate of this issue. ***

*** Issue 41959 has been marked as a duplicate of this issue. ***

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.

*** Issue 56452 has been marked as a duplicate of this issue. ***

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).  

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. 

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.

Seballa

*** Issue 63915 has been marked as a duplicate of this issue. ***

*** Issue 71640 has been marked as a duplicate of this issue. ***

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"?

Adding myself to CC

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
OO.org.  I really would rather use OOo or Gnumeric, but until this issue is
resolved, I'm stuck with Excel.

Hi Niklas, these RFEs are in your ownership.

Has this issue with 55 votes a chance to be done in 3.x?

cc'ing jrahemipour

Heavy users of other spreadsheets do color coding.  I know if this feature was
added, I would use it for each file I create.

Is it even possible to color the label name.

This issue is important and listed on the quarterly review for Calc:
http://wiki.services.openoffice.org/wiki/2008_Q2_Review_of_Spreadsheet_Project
Therefore adjusting target to 3.x.

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
done?

danielbw has begun some work :
http://wiki.services.openoffice.org/wiki/User:Danielbw#Calc:_Tab_Background_Color

I desire this in OO.

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

  

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?

Just added vote #128 & 129.

Many thanks to all of you to make this feature a reality.

Code freeze for target 3.1 is passed already some time, so that is not possible,
alas.

What are your plans for adding the tab colors to ODF?

@nn: I recommended to Daniel to store the color in table's view setting, and
that's how it's working at the moment.

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
http://wiki.services.openoffice.org/wiki/User:Danielbw 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

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.

*** Issue 101055 has been marked as a duplicate of this issue. ***

I really miss this feature in Calc.

Niklas,
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?
Regards,
K. Palagin.

je n'ai que 2 votes possible, mais ces deux votes représentent 20+ utilisateurs
qui utilisaient quotidiennement cette option sous ms office

Need+++

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. 

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. 

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.

@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.

Ubuntu (and probably most other distros) use different version of OO sources,
the one that is maintained by www.go-oo.org. 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
(http://lists.oasis-open.org/archives/office-comment/200907/msg00003.html), but
when it will be brought into specification is unknown.
I suggest pushing the proposal using nice guidance in
http://www.openoffice.org/servlets/ReadMsg?listName=dev&msgNo=25143 (no
flash-mobbing please).
Regards,
KP.

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.

re-assigning to myself for the integration work.

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.

Forgot to mention that, the work is on-going in the calctabcolor cws.

http://hg.services.openoffice.org/hg/cws/calctabcolor/

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.

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.

I've just submitted ODF file format change proposal.  You can see the detail of
my proposal here:

http://wiki.oasis-open.org/office/sheet_tab_color

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:

  [file]/xl/worksheets/sheet*.xml/worksheet.sheetPr.tabColor

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.

The wiki spec page is now available here:
http://wiki.services.openoffice.org/wiki/Calc/Features/Sheet_tab_color#Tab_color_dialog

Ok.  I'm done.  This is now fixed in the calctabcolor cws.

Re-assigning to oc for qa verification.

Kohei,

    Thanks so much for all of your help.

Danielbw

It was my pleasure, Daniel!

Kohei,
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?

>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. ;-)

*** Issue 111052 has been marked as a duplicate of this issue. ***

Is there any confirmation that version 3.3 will able colored tabs ?
Thanks

*** Issue 112222 has been marked as a duplicate of this issue. ***

In "high contrast" mode, we must not show the colors. This is important for
accessibility.

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.

I think the TabBar should be fine by adding this patch to TabBar's Paint method

@@ -1141,7 +1141,7 @@
                 }
                 else
                 {
-                    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.

Created attachment 69982 [details]
add: HC mode in painting

@kohei: if you like that patch, I can push it

@pl: Looks good to me.  Please go ahead and push.

done

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.

reassigning...

I looked at this and it's good now. So I'll take the QA role and mark it as
verified.

I put my name on CC, to know the status of this issue.
Morvan