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
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.
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].
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.
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.
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.
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.
 |