HancomMobileSheet

Copyright (c) 2002 HancomLinux, Inc. All rights reserved.
www.hancom.com

File Menu
- New
- Open
- Close
- Save
- Save as
- Exit

Edit Menu
- Undo / Redo
- Cut
- Copy
- Paste
- Paste special
- Paste link
- Fill
- Clear
- Delete
- Delete sheet
- Find/Replace
- Go to

View Menu
- Standard/Formatting
- Formula bar
- Protection mark
- Grid line
- Full screen
- Zoom
- Split
- Freeze panes
- Workbook

Insert Menu
- Cells, Rows, Columns, Worksheet
- Function
- Name
- Hyperlink

Format Menu
- Cells
- Row
- Column
- Sheet

Tool Menu
- Protect cell
- Protect sheet
- Recalculate / Manual calculation
- Sort
- Automatic filter
- About



File Menu Top

New
Create a new workbook with an automatic temporary file name.

Open
To view or edit a previously saved document, you must first open the document in the current window. The Open dialog box of HancomMobileSheet shows a list of files. Tap the file you want to open in the list window.

Close
When the [File-Close] menu is run the current document will be closed. If the final changes of the current document are not saved a dialog box asking whether to save or not will appear.

Save
In saving the document for the first time, the save dialog box will appear. Designate a name and tap on the save button. The file names can accomodate with up to 127 2-byte and 255 English letters or numbers. If the file was a previous document and opened in the open menu, select the save menu again, then the file will be saved without having to view the dialog box.

Save as
This is used to create a new document name using the current document's information. When you select [File-Save as], the Save dialog box appears.

Exit
Exits HancomMobileSheet.



Edit Menu Top

Undo / Redo
[Undo] and [Redo] return most of the actions made in documentation to the previous status, by canceling the previous command, deleting typed text or undeleting text.

Cut
The Cut menu is used to temporarily cut away data from the selected cell, or set a block and move it to a different location. The data can be re-added within the document by selecting [Edit-Paste].

Copy
Copy is used just like Cut, but leaves the original information intact, but now you have a copy in memory that can be pasted somewhere else.

Paste
When there is data stored in memory by running Copy or Cut, you can paste it elsewhere by removing or moving the data. There are several ways to paste data, such as [Paste special] and [Paste link].

Paste Special
To paste cut or copied data into another location, just press [Edit-Paste]. However, there are cases where you may have to paste only the data value or only the format of the cell. In such cases, you can use [Paste special]. When there is copied data and you select this menu, the Paste dialog box will appear.

* Paste
This allows you to select an item to paste among the copied data, and refers to only pasting the results of a formula. When you run a Formula paste, the copied results will appear depending on which copy method is used, relative reference or absolute reference. Format refers to cell settings of fonts, color, etc. regardless of the values.

* Operation
With similar looking data tables, this will show the results of sum, subtraction, multiplication and division by pasting the values of the data table.


Paste Link
[Paste link] will copy changes. For example, when there is a sales invoice composed of 3 sheets, and the sum value of Sheet1 and Sheet2 are pasted in Sheet3. The three sheets are linked, therefore, the data will automatically change.

Fill


* Down
Select an area, copy the data on the left, and the data will be filled automatically in all cells below.

* Right
This function allows data to be filled by using the menu. You can select a specific area, then the data on the very left of the area will be copied and filled in all cells to the right.

*
Up
Select an area, copy the data on the very bottom and the data will be filled in all the cells on the top.

*
Left
Select an area, copy the data on the very right and the data will be filled in all of the cells on the left.


Clear

* All
This is the simplest way to clear data. This will clear all data within the selected area or cell. When data is cleared in this way, not only are text or number data cleared but also formats as well. This is very useful for initializing an area and not having any hidden surprises.

*
Formats
Using this option will allow you to clear all the formating options such as font and color, but the data remains intact.

*
Contents
This option just clears the data, with all formating options maintained. This is the inverse of the previous function.


Delete
This option physically removes data, rows and columns. As you can see from the following dialog, you can specify how to shift the data accordingly.

Delete Sheet
This is used to delete a sheet in the current document.

Find / Replace


*
Find
This menu is used to find a word, text, number or an equation within the current document. You can set the [Find] menu with a horizontal or vertical direction and also match the case of the string as an option.

*
Replace
This menu is used to find and replace any text or a number on a sheet. You can set the Find function with a horizontal and vertical direction and match the case option. You can use the text typed in the Find or Replace dialog box in both Find and Replace menus as well.

Go to
This will help you find cells without using the keyboard or stylus. For example, if you wish to find the 100th row of a column SR, select [Edit - Go to] and directly type the cell name in the dialog box and click [OK].


View Menu Top

Standard/Formatting
You can close and open toolbars as necessary, or to create a larger working area on the screen.

Formula Bar
Inputbar indicates the contents of the currently selected cell. You may change the contents of a cell in the Inputbar directly.

Protection Mark
Cells can be set to be protected when the contents of the cell should not be randomly deleted or changed. Select [View-Protection mark], then the Protected Cell will be indicated by a symbol in blue in the upper left corner. By selecting this menu once it will be activated and by selecting it twice it will be deactivated.

Grid Line
This determines if the gridlines for cell division on the sheet are indicated or not.

Full Screen
This will display the current window in full screen mode.

Zoom
Enlarging or to reducing the size of the view screen can be modified from 10%~400% or a user defined value.

Split
This function will separate the current window into several windows to assist in viewing while multi-tasking.

Freeze Panes
Freeze Panes will fix a certain location within a file. The fixed location will not move even when you scroll down, therefore, only allowing you to scroll up and down, left and right on the unfrozen panes. This is used when there is a substantial amount of data, and you need to check what kind of data is being input. Freeze Panes will fix the upper row and left column of the fixed cell.

Workbook
This shows all the files that are currently open. From here, you can open, close, change names, and delete the files.



Insert Menu Top

Cells, Rows, Columns, Worksheet
This is used to insert a new cell. Select [Insert - Cells], and set the path of the previous cell when inserting a cell in the dialog box. You can use [Insert - Rows], [Insert - Columns], and [Insert - Work sheet] to insert new rows, columns and work sheets on the Sheet.

Function
Functions consist of the function name, parentheses, and invariables. Each invariable can include value, cell area, or letter according to the function type. The number of invariables differ according to the functions and there are various types of functions, including numbers, letters, area, and arrangement. Select [Insert-Function...] and functions can be entered through the dialog box.

Name
Indicate a name in a certain area of the Sheet.

Hyperlink
This function allows you to easily link to another document or an Internet web page.
The following example shows how to call up another document with an inserted hyperlink.



Format Menu Top

Cells
Select [Format - Cells...] menu to assign various cell formats.

Types of Data Format
Draw Border
Font
Alignment
Pattern

Types of Data Format
When you enter data into a cell, it will take on a default attribute for its type such as currency, string, numeric, etc.

Draw Border
As shown in the following example, you can draw a border easily by pressing the Draw Border button or by selecting one from the line input window. According to the number of selected cells, the number of 'text' letters indicated in 'the line input window' will differ. As shown in the figure above, when more than 2 cells are selected, you can select a line between the cells.

Font
This is the menu used to set text font, size, color, and attributes. You can change part or all of the text objects according to your preference.

Alignment
Select [Format-cells], and choose the alignment tab. Select the position of the cell data in a horizontal or vertical direction or the angle of letter rotation.

*
Horizontal Alignment
With default setting, the letters will be aligned on the right and the numerics will be aligned on the left.

*
Vertical Alignment
Cell data will be positioned vertically.

*
Merge Cell
This function is used to merge several cells into a single cell. When several cells are merged together, the contents of the merged cell will be the one on the top left cell. Cancelling the merge cell will show the hidden cells.


Patttern
Selecting the color and pattern for a cell.
You can select 64 colors for use. In the automatic form, the basic setting is used. For example, after selecting [Yellow] for the background color of the cell in the basic setting, the background color of the cell will turn yellow with a selection of the automatic form.

Row

*
Height / AutoFit
The default height value of a row is set to '1' and modification is allowed. To return to the default height tap [Autofit] menu or select [Use default] from the cell height dialog box.

*
Hide / Unhide
To hide or unhide a row, select the row head and tap the [Format-Row-Hide] menu and the row will be hidden. To see the row again, tap [Format-Row-Unhide].

Column

*
Width / AutoFit Selection
The default width value of a column is set to '8', but can be modified. To return to the default width tap [Autofit selection] menu or tap [Use default] from cell width dialog box.

*
Hide / Unhide
To hide or unhide a column, select the column head and run [Format - Column - Hide], and the column will be hidden. To see the column again, select [Format - Column - Unhide].

*
Standard Width
The default width is set to '8', but you can modify it as you like.

Sheet

*
Rename
Changes the name of the sheet.

*
Hide / Unhide
To hide or unhide a sheet, just tap the [Format-Sheet-Hide] menu and the sheet will be hidden. A list of hidden sheets will be shown at the dialog box with the selection of [Unhide...] button.


Tools Menu Top

Protect cell
This prevents any changes in the cell or data on the sheet. This menu will be "Remove cell protection" in case the selected cell is protected.

Protect Sheet
This will stop any new values from being added to the sheet.

Recalculate / Manual calculation
If many cells have an equation input, it can take a long time to calculate. If there are many equations, select either the automatic or manual calculation option to calculate equations again. With the automatic option, calculations are immediately carried out as soon as the cell information changes.

With the manual option, either press the option or select [Tools - Recalculate] to calculate all the euqations. Thus, the previous information will be indicated in the cell before recalculation. If the file is saved in the manual calculation mode, recalculation will be carried out to update the equation results, then saved.

Sort
This will allow you to sequence information in alphabetical or numeric ascending or descending order.

Automatic Filter
This provides a function that will allow yiou to select only desired information from the sheet. The auto filter of HancomMobileSheet can be applied not only to the column direction but also to the row direction.

About
Displays the about dialog, which shows copyright and version information.
Top