Format Menu in Calc

OpenOffice.org 2.0

Document - ID	Specification Owner	Last Change	Status
	Matthias Müller-Prove	04/25/05	final
Conforms to	StarOffice Specification Workflow v0.1, Aug 2003
Applies to	Calc
Task ID(s)	I30269, i20500 (Merge Cell menu item)
Category	feature

Abstract

The Format menu in OOo2.0 Calc is no longer context sensitive, i.e. the set of menu commands is fixed for all objects to be edited. The structure and terminology is consistent with the Writer module and matches competitive applications.

i-Team Members (The specification owner is part of the i-Team)

	Name	E-mail Address
User Experience	Matthias Müller-Prove /MMP	mprove@sun.com,
Development	Daniel Rentz /DR	Daniel.Rentz@Sun.COM,
Quality Assurance	Oliver Craemer /OC	oliver.craemer@sun.com,
Documentation	Derek Dreger /DD	derek.dreger@sun.com
		mail to iTeam

Approved for Implementation

	Approved by	Date
User Experience	Matthias Müller-Prove	06/23/04, 06/25/04
Development	Daniel Rentz	06/18/04, 06/24/04
Quality Assurance	Oliver Craemer	06/23/04
Documentation	Derek Dreger	06/23/04, 06/24/04
String Review	Eliazabeth Matthis	07/07/04

Document Change History

Rev. Level	Change	Initials	Date
	initial version	MMP	06/16/04
	"Graphic" to "Picture" change in Insert menu;	MMP	06/21/04
	DR-1 some contexts are missing, back to draft status	MMP	06/23/04
	added missing context to Competitive Analyses: StarOffice; integrated menu items into Format menu.	MMP	06/24/04
	added mnemonics	MMP	06/25/04
	removed already hidden menu commands	MMP	06/30/04
	The Alignment submenu aplies also to the plain text/cell context	MMP	06/30/04
1.0	string review by EM; changes are marked green	MMP	07/08/04
	Row 233: The Merge Cells submenu is no longer used for OOo 2.0. Instead the menu item “Merge Cells” is a toggle menu item. Cf i20500	MMP	04/25/05

Contents

Glossary	4

1	Motivation	4

2	User Scenarios	4

3	Goals	4

4	Requirements and Dependencies	4

4.1	Requirements	4

4.2	Technical Dependencies	4

5	Competitive Analysis	4

5.1	StarOffice 7	4

5.2	MS Excel 2003	8

6	Detailed Specification	10

6.1	Format Menu in Calc	10

6.2	Submenus of the Format Menu in Calc	10

6.3	Insert Menu in Calc	13

6.4	Style Catalog	13

6.5	G11n	13

6.6	Error Conditions	13

6.7	Migration	14

7	Future Tasks	14

8	Notes	14

9	References	14

Glossary

Term	Description
<Term 1>	

Motivation

The context-sensitivity of the Format menu of OOo 1.1 confuses the user. It is also not possible to customize such a changing menu.

User Scenarios

<A user scenario is a idealized description of a specific interaction. This description shall be written short and specific. User scenarios can describe a leak of functionality, or based on the requirements, a solution.>

Goals

Define a context-independent Format menu for OOo 2.0.

Adopt terminology and structure of competitors.

Be consistent with Writer's new Format menu [Format Menu in Writer]

Requirements and Dependencies

Requirements

<State the requirement(s) of this feature here.>

Technical Dependencies

<Are there any technical dependencies for this feature? Does the implementation of this feature create any technical dependencies to other program parts? Or very important any issues for automatedd GUI Testing?>

Competitive Analysis

StarOffice 7

StarOffice Calc has 5 contexts for the Format menu. The contexts are 1) Cell, 2)Text, 3) Graphic, 4)Text in Graphic, 5) Control.

Context Cell and Text

Format	Comment
Cell	Text

Default	x	x

---------------	x	x

Character...	x

Cells...	x	x

Row	>	x	x

Column	>	x	x

Sheet	>	x	x

Merge Cells	>	x	x

---------------	x	x

Page...	x	x

Print Ranges	>	x	x

---------------	x	x

Case/Characters	>	x	x

---------------	x	x

Style Catalog...	x	x

Stylist	x	x

AutoFormat...	x	x

Conditional Formatting...	x	x

Context: Graphic

Format	Comment
Graphic

Line...

Area...

Text...

Position and Size...

Control...

Form...

---------------

Flip	>

Arrange	>

Alignment	>

Anchor	>

---------------

Edit Points

FontWork

---------------

Group	>

Context Text in Graphic

Format	Comments

Default

---------------

Style	>

Alignment	>

Line Spacing	>

---------------

Character...

Paragraph...

---------------

Case/Characters	>

---------------

Text

Fontwork

Context: Control

Format	Comments

Position and Size...

Control...

Form...

---------------

Arrange	>

Alignment	>

Anchor	>

---------------

Group	>

Submenus

Row	>	Comments
context: Cell, Text

Height...

Optimal Height

Hide

Show

Column	>	Comments
context: Cell, Text

Width...

Optimal Width...

Hide

Show

Sheet	>	Comments
context: Cell, Text

Rename...

Hide

Show...

Merge Cells	>	Comments
context: Cell, Text

Define

Remove

Print Ranges	>	Comments
context: Cell, Text

Define

Add

Remove

---------------

Edit...

Case/Characters	>	Comments
context: Cell, Text, Text in Graphic

Uppercase

Lowercase

Half-width

Full-width

Hiragana

Katakana

Flip	>	Comments
context: Graphic

Vertically

Horizontally

Arrange	>	Comments
context: Graphic, Control

Bring to Front

Bring Forward

Send Backward

Send to Back

---------------

To Foreground

To Background

Alignment	>	Comments
context: Graphic

Left

Centered

Right

---------------

Top

Center

Bottom

Group	>	Comments
context: Graphic, Control

Group

Ungroup

Edit Group

Exit Group

Style	>	Comments
context: Text in Graphic

Bold

Italic

Underline

Strikethrough

Shadow

Outline

---------------

Superscript

Subscript

Alignment	>	Comments
context: Text in Graphic

Left

Right

Centered

Justified

Anchor	>	Comments
context: Graphic, Control

To Page

To Cell

Line Spacing	>	Comments
context: Text in Graphic

Single

1.5 lines

Double

MS Excel 2003

The Format menu of MS Excel is static.

The Format menu between MS Excel 2002 and MS Excel 2003 hasn't changed:

MS Excel Format Menu

Format	Comment

Cells...

Row	>

Columns	>

Sheet	>

---------------

AutoFormat...

Conditional Formatting...

Style...

Row	>	Comment

Height...

AutoFit

Hide

Unhide

Columns	>	Comment

Width...

AutoFit Selection

Hide

Unhide

Standard Width...

Sheet	>	Comment

Rename

Hide

Unhide...

---------------

Background...

Tab Color...

Detailed Specification

Format Menu in Calc

OOo 2.0 has a Format menu with a static set of menu command.

OpenOffice.org Calc Format Menu

Format	Comment

Default Formatting	was “Default”; context: Cell, Text, Text in Graphic

---------------

Cells...	MS

Row	>	MS

Column	>	MS: Columns

Sheet	>	MS

Merge Cells	toggle menu item

---------------

Page...

Print Ranges	>

---------------

Character...	context Cell, Text, Text in Graphic

Paragraph...	context: Text in Graphic

Change Case	>	was “Case/Characters”; context: Cell, Text, Text in Graphic

Text	removed; context: Text in Graphic; also in context menu

Fontwork	removed; context: Graphic, Text in Graphic; also in context menu

---------------

Styles and Formatting	was “Stylist”; cf. [Assigning Styles]

Style Catalog...	removed; cf. [Format Menu in Writer]

AutoFormat...	MS

Conditional Formatting...	MS

---------------

Anchor	>	context: Graphic, Control

Alignment	>	context: Graphic, Text in Graphic, Control

Arrange	>	context: Graphic, Control

Flip	>	context: Graphic

Group	>	context: Graphic, Control;	// Data>Outline provides also grouping commands

---------------

Picture	>	new submenu

Control...	context: Graphic, Control

Form...	context: Graphic, Control

The submenus Style and Line Spacing are no longer part of the menu. Nonetheless the menu commands can still be configured.

Submenus of the Format Menu in Calc

The submenus are unchanged compared to OOo1.1.

Row	>	Comment

Height...	MS

Optimal Height	MS: AutoFit

Hide	MS

Show	MS: Unhide

Column	>	Comment

Width...	MS

Optimal Width...	MS: AutoFit Selection

Hide	MS

Show	MS: Unhide

Sheet	>	Comment

Rename...	MS

Hide	MS

Show...	MS: Unhide...

Merge Cells	>	Comment

Define

Remove

The Merge Cells submenu is no longer used for OOo 2.0. Instead the menu item “Merge Cells” is a toggle menu item.

Print Ranges	>	Comment

Define

Add

Remove

---------------

Edit...

Change Case	>	Comment

Uppercase

Lowercase

Half-width	cf. section on G11n

Full-width	cf. section on G11n

Hiragana	cf. section on G11n

Katakana	cf. section on G11n

Anchor	>	Comments
context: Graphic, Control

To Page

To Cell

Alignment	>	Comments
Graphic	Text in Graphic	Text,Cell

Standard	x

Left	x	x	x

Centered	x	x	x

Right	x	x	x

Justified	x	x

---------------	x	x

Top	x	x

Center	x	x

Bottom	x	x

Arrange	>	Comments
context: Graphic, Control

Bring to Front

Bring Forward

Send Backward

Send to Back

---------------

To Foreground

To Background

Flip	>	Comments
context: Graphic

Vertically

Horizontally

Group	>	Comments
context: Graphic, Control

Group

Ungroup

Edit Group

Exit Group

Graphic	>	Comments
context: Graphic, Control

Position and Size...	context: Control

Line...

Area...

Text...

---------------

Edit Points

String list

Item	English	German	Comments
menu item	~Default Formatting	Standardformatierung	was “Default”
menu item	~Change Case	Groß/Kleinschreibung	was “Case/Characters”
menu item	P~icture	Bild	
menu item	Ch~aracter...		new mnemonic
menu item	Para~graph		new mnemonic
menu item	A~nchor		new mnemonic
menu item	Alignmen~t		new mnemonic
menu item	A~rrange		new mnemonic
menu item	F~lip		new mnemonic
menu item	Gro~up		new mnemonic
menu item	~Control		new mnemonic
menu item	~Form		new mnemonic

Key Board Shortcuts

Mnemonics for the Format menu are directly marked in the opening list of the detailed specification.

Insert Menu in Calc

In the Format menu the menu item “Graphics...” changes to “Picture...”. As a consequence the same change happens in the Insert Menu.

Insert	Comment

...

Picture	>	was “Graphics”

...

String list

Item	English	German	Comments
menu item	Pic~ture	Bild	was “Graphics”

Style Catalog

The Style Catalog is no longer available. All functions are accessible via the Stylist and File>Templates>Organize.

G11n

The menu items i) Half-width, ii) Full-width, iii) Hiragana, and iv) Katakana in the Change Case submenu are only present in the menu structure if Asian Languages Support is enabled. For more details see [Asian menu items, i30041].

Error Conditions

n/a

Migration

n/a

Future Tasks

n/a

Notes

Addressed Issues

DR-1 The spec needs to cover the contexts for Controls, Graphics, Text in Graphics

References

Assigning Styles	http://specs.openoffice.org/writer/formatting/Assigning_Styles_in_Writer.sxw

Menu Terminology	http://so-doc.germany.sun.com/Teams/User_Experience/Team/em/SpecStrgRevs_SO8/MenuTerms.sxw

Format Menu in Writer	http://specs.openoffice.org/writer/menus/FormatMenu.sxw

Format Menu in Calc	http://specs.openoffice.org/calc/menus/FormatMenu.sxw

Asian menu items	i30041

14	Format Menu in Calc

Format Menu in Calc	14

http://specs.openoffice.org/calc/menus/FormatMenu.sxw

Matthias Müller-Prove

2004-04-05T14:23:37

Matthias Müller-Prove