Calc/Features/Sheet tab color

From Apache OpenOffice Wiki
< Calc‎ | Features
Revision as of 19:50, 23 February 2010 by Kohei (Talk | contribs)

Jump to: navigation, search

Sheet tab color

Specification Status
Author Kohei Yoshida
Last Change See wiki history
Status In progress in CWS calctabcolor  .


Calc's sheet tab now supports non-default background color. When a sheet tab has a non-default color, Calc displays a sliver of its color below the name if the sheet that the tab is associated with is active. For all the other tabs that are associated with the non-active sheets, their non-default color becomes their respective background color.


Reference Document Check Location (URL)
Issue ID (required) available Issue 5560
Test case specification (required) n/a


Role Name E-Mail Address
Developer Kohei Yoshida
Quality Assurance Oliver Craemer Oliver.Craemer@Sun.COM
Documentation up for grabs!
User Experience up for grabs!

Detailed Specification

Original specification authored by Daniel Watson is available here. This specification only covers parts that are relevant for QA purposes.


New menu entry in the toolbar menu.

This feature introduce a new menu entry Tab Color... under Format > Sheet which launches the Tab color dialog when selected. This menu item is disabled when the active sheet is protected.

Context menu

New menu entry in the context menu.

The context menu for the sheet tabs now has a new entry Tab Color... which launches the Tab color dialog when selected. This new menu entry is present only when the active sheet is not protected.

Tab color dialog

Tab color dialog.

The Tab Color dialog consists of a number of pre-defined colors and the option for the Default color. A new color gets applied to the tabs of all selected sheet, but the color will not get applied to the tabs of protected sheets in case one or more of the selected sheets are protected.

Either double-clicking a color directly, or hitting ENTER while a color is selected assigns that color to the selected tab(s) and dismisses the dialog.

The color table that this dialog contains can be edited in the Colors page of the Options dialog (Tools - Options).





File Format

This feature requires a file format change in the ODF specification. A proposal to the ODF specification has been submitted here. In a nutshell, the sheet tab color information is stored as a table property attribute as part of the automatic table styles.

Open Issues

Not yet determined.


A large part of this feature was developed by Daniel Watson.

Personal tools