Revision as of 06:11, 5 August 2013

Spreadsheet User Interface Overview

The above screenshot is Spreadsheet user interface, and each part of above is introduced as follows:

Toolbar
The toolbar contains all commonly-used functions including setting cell's style, alignment, border, background color, font, font color, merging (and unmerging) cells, sorting, auto filter, protection and grid line visibility. It has 2 tabs, another tab is used to insert charts, images, and hyperlinks:
Formula bar
It displays editing text or formula of current selected cell and can be used to enter or edit a formula or data.
Sheet Area
It displays the content of current selected sheet, and you usually perform most editing operations in this area.
Context menu
Right clicking on a cell, a column header, or a row header pops up a context menu. It contains most options of the toolbar and works like a shortcut.
Sheet bar
A list of all sheets of this book. You can navigate to any sheet by clicking on it. Click can add a new sheet. Right clicking on a sheet pops a context menu: and it allows you to delete, rename, protect, and move the clicking sheet.

The default supported hot keys are: ^X^C^V^D^B^I^U#del.

@@ Line 23: / Line 23: @@
 == Hot Key ==
 The default supported hot keys are: ^X^C^V^D^B^I^U#del.
 {| border="2" style="text-align:center; font-size:18; padding:10px;"
@@ Line 28: / Line 30: @@
 ! <center>Hot Key</center> !! <center>Action</center>
 |-
-! Coupling with View
+! Ctrl+B
-| Loose with layout
+| bold
 |-
-! Coupling with Component
+! Ctrl+C
-| Tight
+| copy
 |-
-! Coding in View
+! Ctrl+D
-| Component ID
+| clear content
 |-
-! Controller Implementation
+! Ctrl+I
-| &nbsp;Extends ZK's composer&nbsp;
+| Italic
 |-
-! UI Data Access
+! Ctrl+U
-| Direct access
+| underline
 |-
-! Backend Data Access
+! Ctrl+V
-| Direct  access
+| paste
 |-
-! UI Updating
+! Ctrl+X
-| Manipulate components
+| cut
 |-
-! Component Controlling Granularity
+! Delete
-| Fine-grained
+| clear content
-|-
-! Performance
-| High
 |}
 == Auto Fill ==