Features and Usages"

From Documentation
m
Line 7: Line 7:
 
[[File:essentials-feature-ui.png | center | 900px]]
 
[[File:essentials-feature-ui.png | center | 900px]]
  
The above screenshot is Spreadsheet user interface, and each part of above is introduced as follows:
+
Above is a screenshot of ZK Spreadsheet's user interface, each section is introduced in the following:  
 
# Toolbar
 
# 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 for web page and email address:
+
#:The toolbar contains all commonly-used functions including setting cell's style, alignment, border, background color, font, font color, merging (and unmerging) of cells, sorting, auto filter, protection and grid line visibility. It has 2 tabs, another tab is used to insert charts, images, and hyperlinks for web page and email address:
 
#: [[File:essentials-feature-toolbar.png | 700px]]
 
#: [[File:essentials-feature-toolbar.png | 700px]]
 
#: The 3 leftmost buttons, "New Book", "Save Book", and "Export to PDF", are not built-in functions. You have to implement them by yourself.
 
#: The 3 leftmost buttons, "New Book", "Save Book", and "Export to PDF", are not built-in functions. You have to implement them by yourself.
Line 19: Line 19:
 
#: 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.
 
#: 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
 
# Sheet bar
#: A list of all sheets of this book. You can navigate to any sheet by clicking on it. Click [[File:essentials-feature-addSheet.png]] 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.  
+
#: A list of all sheets in this book. You can navigate to any sheet by clicking on it. Click [[File:essentials-feature-addSheet.png]] 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.  
 
#: [[File:essentials-feature-sheet-contextmenu.png | center]]
 
#: [[File:essentials-feature-sheet-contextmenu.png | center]]
  
Line 81: Line 81:
  
  
After selecting "Custom sort" on the toolbar, a dialog appears. You can add sorting criteria at most to 3 columns. If your data includes column headings, make sure the "My data has headers" option is checked.
+
After selecting "Custom sort" on the toolbar, a dialog appears. You can add sorting criteria to 3 columns at the most. If your data includes column headings, make sure the "My data has headers" option is checked.
 
[[File:essentials-feature-customSortDialog.png | center]]
 
[[File:essentials-feature-customSortDialog.png | center]]
  
Line 89: Line 89:
  
 
== Filter ==
 
== Filter ==
The Filter can screen out data you don't want quickly and easily. We usually select the cells we want to filter first and select "Filter" on the toolbar.
+
The Filter can screen out data you don't want displayed quickly and easily. We usually select the cells we want to filter first and select "Filter" on the toolbar.
  
 
[[File:essentials-feature-filter-enable.png | center]]
 
[[File:essentials-feature-filter-enable.png | center]]
Line 117: Line 117:
 
== Format Cell ==
 
== Format Cell ==
  
In context menu appeared when right clicking a cell, "Format Cell" provides 10 different categories with total 47 formats to apply on cells.
+
A context menu appears when right clicking a cell, "Format Cell" provides 10 different categories with total of 47 formats to apply on cells.
 
[[File:essentials-feature-formatCell.png | center]]
 
[[File:essentials-feature-formatCell.png | center]]
  
  
 
== Validation ==
 
== Validation ==
Spreadsheet can read your validation settings in an Excel file and show hints and validate input for you. (OSE will ignore validation settings.)
+
Spreadsheet can read your validation settings in an Excel file and show hints and validate inputs for you. (Spreadsheet OSE will ignore validation settings.)
  
 
When you select a cell with validation settings, Spreadsheet will display input message aside the cell.
 
When you select a cell with validation settings, Spreadsheet will display input message aside the cell.
Line 132: Line 132:
  
  
If your validation criteria comes from a range of data, you can input that cell via drop-down list.
+
If your validation criteria comes from a range of data, you can input that cell via a drop-down list.
 
[[File:zss-essentials-feature-validation-list.png | center]]
 
[[File:zss-essentials-feature-validation-list.png | center]]
  

Revision as of 10:35, 16 October 2013


Features and Usages




Spreadsheet User Interface Overview

Essentials-feature-ui.png

Above is a screenshot of ZK Spreadsheet's user interface, each section is introduced in the following:

  1. Toolbar
    The toolbar contains all commonly-used functions including setting cell's style, alignment, border, background color, font, font color, merging (and unmerging) of cells, sorting, auto filter, protection and grid line visibility. It has 2 tabs, another tab is used to insert charts, images, and hyperlinks for web page and email address:
    Essentials-feature-toolbar.png
    The 3 leftmost buttons, "New Book", "Save Book", and "Export to PDF", are not built-in functions. You have to implement them by yourself.
  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 in 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 and it allows you to delete, rename, protect, and move the clicking sheet.
    Essentials-feature-sheet-contextmenu.png

Supported Hotkeys

Hotkey
Action
Ctrl+B bold
Ctrl+C copy
Ctrl+I italic
Ctrl+U underline
Ctrl+V paste
Ctrl+X cut
Ctrl+Y (EE only) redo
Ctrl+Z (EE only) undo
Delete clear content
Esc clear copy/cut clipboard


Usage

The following sections will introduce usages of some noticeable features which are all Available in ZK Spreadsheet EE only.


Special Paste

In addition to normal pasting, Spreadsheet also provides other special pasting options on the toolbar.

Essentials-feature-paste.png

You can select "Paste Special" to access all available pasting options in a dialog.

Essentials-feature-pasteSpecial.png

Custom Sort

The "Ascending" and "Descending" function can sort data by only one column but "Custom sort" can sort data by multiple columns.

Essentials-feature-customSort.png


After selecting "Custom sort" on the toolbar, a dialog appears. You can add sorting criteria to 3 columns at the most. If your data includes column headings, make sure the "My data has headers" option is checked.

Essentials-feature-customSortDialog.png


The sorting result of criteria above:

Essentials-feature-customSort-after.png

Filter

The Filter can screen out data you don't want displayed quickly and easily. We usually select the cells we want to filter first and select "Filter" on the toolbar.

Essentials-feature-filter-enable.png


Then each column will have a drop-down button. Click the drop-down button to select data to filter.

Essentials-feature-filter.png


Those rows that contain the unchecked item will not appear in the original table unless you check them back.

Essentials-feature-filter-after.png

If you insert more data after applying a filter, you can select "Reapply" on the toolbar to apply same criteria to new data.

Auto Fill

Auto fill is a handy feature to fill cells with data using a particular pattern based on selected cells. Text will be copied and numbers and dates will be increased (or decreased).

To use this, You should select one or more cells and drag the fill handle across or down the cells that you want to fill.

Essentials-feature-autoFill-select.png

Fill cells after dragging right.

Essentials-feature-autoFill.png


Format Cell

A context menu appears when right clicking a cell, "Format Cell" provides 10 different categories with total of 47 formats to apply on cells.

Essentials-feature-formatCell.png


Validation

Spreadsheet can read your validation settings in an Excel file and show hints and validate inputs for you. (Spreadsheet OSE will ignore validation settings.)

When you select a cell with validation settings, Spreadsheet will display input message aside the cell.

Zss-essentials-feature-validationHint.png


If you enter invalid data, Spreadsheet will prompt you with the error message you set in the Excel file.

Zss-essentials-feature-validationFailed.png


If your validation criteria comes from a range of data, you can input that cell via a drop-down list.

Zss-essentials-feature-validation-list.png


Protection

If you enable "Protect Sheet" for a sheet in Excel, Spreadsheet will keep this setting when reading the Excel file, hence, when you edit a protected sheet, you will receive an alert message on the top left-hand corner.

Zss-essentials-feature-protection.png





All source code listed in this book is at Github.


Last Update : 2013/10/16

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.