AOO UX Design Exploration - Spreadhseet Editor Task Pane Content - User Interface Design

From Apache OpenOffice Wiki
Revision as of 02:53, 22 November 2012 by Greenyo (Talk | contribs)

Jump to: navigation, search

< AOO User Experience Home | < AOO 4.0 Dockable Task Pane (Side Bar) Design Exploration

Spreadsheet Editor Task Pane Content

Information Design Analysis

Lotus Symphony 3.0.1 provides both contextual and non-contextual task pane content. The following sections explores the LS task pane content and seeks to better understand the mapping to the AOO UI to assist in understanding the features and sizing development effort.

Text Properties (cell selected)

Task pane spread text cell selected properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control Expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Font Drop-down n/a Yes Drop-down n/a .
Font size Drop-down n/a Yes Drop-down n/a .
Increase font size Command button Yes Yes Command button Yes UI DESIGN REQUIRED: need to decide which icons to use
Decrease font size Command button Yes Yes Command button Yes .
Bold Option toggle command button Yes Yes Option toggle command button Yes
Italic Option toggle command button Yes Yes Option toggle command button Yes
Underline Option toggle command button Yes Yes Option toggle command button Yes
Strike through Option toggle command button Yes Yes Drop-down No UI DESIGN REQUIREMENT: icon artwork required
Shadow Option toggle command button Yes Yes Drop-down No UI DESIGN REQUIREMENT: icon artwork required
Font colour Colour grid picker Yes Yes Colour grid picker Yes UI DESIGN REQUIREMENT: adopt Symphony colour picker palette design


Text Properties (Editing)

Task pane spread text cell editting properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control Expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Font Drop-down n/a Yes Drop-down n/a .
Font size Drop-down n/a Yes Drop-down n/a .
Increase font size Command button Yes Yes Command button Yes UI DESIGN REQUIRED: need to decide which icons to use
Decrease font size Command button Yes Yes Command button Yes .
Bold Option toggle command button Yes Yes Option toggle command button Yes
Italic Option toggle command button Yes Yes Option toggle command button Yes
Underline Option toggle command button Yes Yes Option toggle command button Yes
Strike through Option toggle command button Yes Yes Drop-down No UI DESIGN REQUIREMENT: icon artwork required
Shadow Option toggle command button Yes Yes Drop-down No UI DESIGN REQUIREMENT: icon artwork required
Font colour Colour grid picker Yes Yes Colour grid picker Yes UI DESIGN REQUIREMENT: adopt Symphony colour picker palette design
Superscript Option toggle command button Yes Yes Option toggle command button Yes
Subscript Option toggle command button Yes Yes Option toggle command button Yes
Character spacing Drop-down Yes Yes Drop-down No UI DESIGN REQUIREMENT: icon artwork required
Highlight Colour grid picker Yes Yes Colour grid picker Yes UI DESIGN REQUIREMENT: Should we consider limiting palette to common highlighter colours, with option for more colours?


Alignment Properties (cell selected)

Task pane spread alignment cell selected properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control Expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Align left Option toggle command button Yes Yes Option toggle command button Yes
Align center Option toggle command button Yes Yes Option toggle command button Yes
Align right Option toggle command button Yes Yes Option toggle command button Yes
Justified Option toggle command button Yes Yes Option toggle command button Yes
Align top Option toggle command button Yes Yes Option toggle command button  ???
Align middle justified Option toggle command button Yes Yes Option toggle command button  ???
Align bottom Option toggle command button Yes Yes Option toggle command button  ???
Left indent Number spinner Yes Yes  ???  ???
Wrap text Check box Yes Yes  ???  ???
Merge cells Check box Yes Yes  ???  ???
Text orientation Custom control Yes Yes  ???  ???
Orientation degrees Drop-down Yes Yes  ???  ???
Vertically stacked Check box Yes Yes  ???  ???


Number Format Properties (cell selected)

Task pane spread number cell selected properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Category Drop-down No  ???  ???  ???
Number Option toggle command button Yes  ???  ???  ???
Currency Option toggle command button Yes  ???  ???  ???
Date Option toggle command button Yes  ???  ???  ???
Text Option toggle command button Yes  ???  ???  ???
Decimal places Spin Box No  ???  ???  ???


Leading zeros Spin Box No  ???  ???  ???
Negative numbers red Check box No  ???  ???  ???
Thousands separator Check box No  ???  ???  ???


Cell Appearance Properties (cell selected)

Task pane spread appearance cell selected properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Cell background Colour grid picker Yes  ???  ???  ???
Cell boarder Drop-down Yes  ???  ???  ???
Cell Line style Drop-down Yes  ???  ???  ???
Cell line Colour grid picker Yes  ???  ???  ???
Show cell grid lines Check box n/a  ???  ???  ???


Area Properties

Task pane spread area properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Area fill scope Drop-down No No Drop-down Yes use AOO fill scope and colour selector control design pattern - bucket icon for scope fill, colour swatch for colour
Area fill Colour grid picker Yes Yes Colour grid picker No use AOO fill scope and colour selector control design pattern - bucket icon for scope fill, colour swatch for colour
Transparency scope Drop-down No Yes Drop-down Yes use AOO transparency icon
Transparency percentage Number spinner No Yes Drop-down No UI DESIGN REQUIREMENT: icon artwork required, or not? determine percentage pattern


Line Properties

Task pane spread line properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Line width Drop-down n/a Yes Number spinner Yes
Line colour Colour grid picker Yes Yes Colour grid picker No use AOO line and colour selector control design pattern - bucket icon for scope fill, colour swatch for colour
Line style Drop-down No Yes Drop-down Yes use AOO transparency icon
Line transparency percentage Number spinner No Yes Number spinner No UI DESIGN REQUIREMENT: icon artwork required, or not? determine percentage pattern
Beginning arrowhead Drop-down No Yes Drop-down Yes UI DESIGN REQUIREMENT: Use LS pattern with separate arrow head selection, AOO uses dialog, not menu.
Ending arrowhead Drop-down No Yes Drop-down Yes UI DESIGN REQUIREMENT: Use LS pattern with separate arrow head selection, AOO uses dialog, not menu.


Position and Size Properties (text, line, shape)

Task pane spread posandsize textlineshape properties.png


LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Shape width Number spinner No Yes Number spinner No
Shape height Number spinner Yes Yes Number spinner No
Keep ratio Check box option No Yes Check box option No
Rotation customer control Rotation control No Yes Rotation control No UI DESIGN REQUIREMENT: determine which custome control to implement, LS or AOO
Rotation degrees Number spinner No Yes Number spinner No
Flip vertically Option toggle command button Yes Yes Option toggle command button Yes
Flip horizontally Option toggle command button Yes Yes Option toggle command button Yes


Position and Size Properties (Graphic)

Task pane spread posandsize graphic properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control Expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Width Number spinner No Yes Number spinner No
Height Number spinner No Yes Number spinner No
Keep ratio Check box option No Yes Check box option No


Position and Size Properties (Chart)

Task pane spread posandsize chart properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Horizontal Number spinner No Yes Number spinner No
Vertical Number spinner No Yes Number spinner No
Width Number spinner No Yes Number spinner No
Height Number spinner No Yes Number spinner No
Keep ratio Check box option No Yes Check box option No


Graphic Properties

Task pane spread graphic properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Expand/collapse section control Expand/collapse Yes No UI DESIGN REQUIRED: need to create property section as part of AOO task pane container design
More options command Command button Yes No UI DESIGN REQUIRED: need to create more options command button as part of AOO task pane container design
Brightness Number spinner No Yes Number spinner Yes
Contrast Number spinner No Yes Number spinner Yes
Colour mode Drop-down Yes Yes Drop-down No Nice LS drop down, with embedded icon
Transparency percentage Number spinner No Yes Number spinner Yes
Red percentage Number spinner Yes Yes Number spinner Yes
Green percentage Number spinner Yes Yes Number spinner Yes
Blue percentage Number spinner Yes Yes Number spinner Yes
Gamma percentage Number spinner Yes Yes Number spinner Yes


Style List Content

Task pane spread styles.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Collapse tab Command button Yes
Style categories Drop-down No  ???  ???  ???
View style group Drop-down No  ???  ???  ???
Styles list List view No  ???  ???  ???
Apply style Command button Yes  ???  ???  ???
New style Drop-down command button Yes  ???  ???  ???
Modify Drop-down command button Yes  ???  ???  ???
Fill styles Command button Yes  ???  ???  ???
Load styles Command button Yes  ???  ???  ???


Clipart Content

Task pane spread clipart.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Collapse tab Command button Yes
New clipart theme Command button Yes  ???  ???  ???
Clipart theme list List Yes  ???  ???  ???
Clipart Gallery List view Yes  ???  ???  ??? Thumbnails in list view in LS
Get clipart online Hypertext command Yes  ???  ???  ???


Navigator Content

Task pane spread navigator.png


Functions Content

Task pane spread function.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Collapse tab Command button Yes
Insert function Command button Yes  ???  ???  ???
Display available functions Drop-down No  ???  ???  ???
Functions List view No  ???  ???  ???
Function details Text string No  ???  ???  ???


Function Content

Task pane spread function.png

  • Insert function command - icon
  • Display available functions drop-down
  • Function list view
  • Function details string


Data Pilot Content

Task pane spread task pilot properties.png

LS Task Pane Content LS UI Control LS Icon Command in AOO? AOO UI Control AOO Icon Notes
Collapse tab Command button Yes
Data pilot action Drop-down Yes  ???  ???  ???
Field option Option toggle command button Yes  ???  ???  ???
Show detail Option toggle command button Yes  ???  ???  ???
Ascending order option Option toggle command button Yes  ???  ???  ???
Descending order option Option toggle command button Yes  ???  ???  ???
Field List view No  ???  ???  ???
Page area List view Yes  ???  ???  ???
Column area List view Yes  ???  ???  ???
Row area List view Yes  ???  ???  ???
Data area List view No  ???  ???  ???
Update Command button No  ???  ???  ???
Automatically update Check box No  ???  ???  ???


User Interface Control Analysis

Standard Controls

  • expand/collapse
  • drop-down menu
  • number spinner
  • command button
  • option toggle command button
  • colour grid picker
  • check box option
  • list control
  • tree control
  • hyperlink command
  • text strings

Custom Controls

  • drop-down menus with nested controls (drop-down menus, command buttons, number spinners)
  • line properties drop downs
  • fill properties drop downs
  • rotation control
  • clipart thumbnails




Personal tools