Features and Usages"

From Documentation
Line 24: Line 24:
 
== Hot Key ==
 
== Hot Key ==
 
The default supported hot keys are: ^X^C^V^D^B^I^U#del.
 
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;"
 +
|+
 +
! <center>Hot Key</center> !! <center>Action</center>
 +
|-
 +
! Coupling with View
 +
| Loose with layout
 +
|-
 +
! Coupling with Component
 +
| Tight
 +
|-
 +
! Coding in View
 +
| Component ID
 +
|-
 +
! Controller Implementation
 +
| &nbsp;Extends ZK's composer&nbsp;
 +
|-
 +
! UI Data Access
 +
| Direct access
 +
|-
 +
! Backend Data Access
 +
| Direct  access
 +
|-
 +
! UI Updating
 +
| Manipulate components
 +
|-
 +
! Component Controlling Granularity
 +
| Fine-grained
 +
|-
 +
! Performance
 +
| High
 +
|}
  
 
== Auto Fill ==
 
== Auto Fill ==

Revision as of 04:32, 5 August 2013


Features and Usages




Spreadsheet User Interface Overview

Essentials-feature-ui.png

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

  1. 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:
    Essentials-feature-toolbar.png
  2. Formula bar
    It displays editing text or formula of current selected cell and can be used to enter or edit a formula or data.
  3. Sheet Area
    It displays the content of current selected sheet, and you usually perform most editing operations in this area.
  4. 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.
  5. Sheet bar
    A list of all sheets of this book. You can navigate to any sheet by clicking on it. Click Essentials-feature-addSheet.png can add a new sheet. Right clicking on a sheet pops a context menu: Essentials-feature-sheet-contextmenu.png and it allows you to delete, rename, protect, and move the clicking sheet.

Usage

Hot Key

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

Hot Key
Action
Coupling with View Loose with layout
Coupling with Component Tight
Coding in View Component ID
Controller Implementation  Extends ZK's composer 
UI Data Access Direct access
Backend Data Access Direct access
UI Updating Manipulate components
Component Controlling Granularity Fine-grained
Performance High

Auto Fill