User manual SHARP HANCOM MOBILE OFFICE SOFTWARE MANUAL

[. . . ] HancomMobileOffice Operation Manual 2 Copyright Notice Copyright Notice EULA(End User License Agreement) HancomMobileOffice is protected by the software copyright law and international copyright agreements. HancomMobileWord 1. 0, HancomMobileSheet 1. 0, HancomMobilePresenter 1. 0 are trademarks of HancomLinux, Inc. that comply with the general copyright laws. Hancom is a trademark of Haansoft Inc. , which is used by HancomLinux, Inc. [. . . ] The find function can be set with a horizontal and vertical direction and match case option. The text that has been previously entered on the find or replace dialog box can be utilized in both the find and replace menus as well. Go To This helps you find cells without using the keyboard or stylus. For example if you wish to find the 100th row of column SR, select [Edit-Go to] and directly input the cell name in the dialog box and tap OK. 46 CHAPTER 3: HancomMobileSheet View Menu Toolbars You can close and open toolbars as needed for use, or to create a larger working area on the screen. Standard Tool New Open Save Cut Copy Paste Undo Redo Automatic sum Function Comma Cell protection Remove cell protection Ascending sort Descending sort Draw border Erase border Right range selection Down range selection Formatting Tool Bold Italic Underline Alignment Left Alignment Center Alignment Right Alignment Standard Merge cells Alignment Horizontal title Alignment Vertical title Currency Percent Increase decimal digit Decrease decimal digit Cell color Font color Etc. Toggle Toolbar Zoom Full Screen Formula Bar The inputbar indicates the contents of the currently selected cell. You may change the contents of a cell at the Inputbar directly. CHAPTER 3: HancomMobileSheet 47 Protection Mark Cells can be set to be protected so that cells 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 is activated and by selecting it twice it is deactivated. Grid line This determines whether the grid lines for cell division on the sheet is indicated or not. Full screen Displays the current window in full screen mode. Zoom To enlarge or to reduce the size of view screen, can be modified from 10%~400% or a user defined value. Split This function separates the current window into several windows and help the view of multi-tasks. Freeze panes Freeze Panes fix a certain location within a file. The fixed location does not move even when scrolled down, only the remaining parts move up and down, left and right when scrolled. 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 freezes the upper row and left column to the fixed cell. Select cell B2 as the pane to freeze. When [View-Freeze panes] is selected a line appears and the pane is frozen around that specific location. You can cancel Freeze by selecting [View-Unfreeze panes]. 48 CHAPTER 3: HancomMobileSheet Workbook This shows all the files that are currently open, and from here, you can open, close, change names, and delete the files. Insert Menu Cells, Rows, Column, Work Sheet Used when inserting a new cell. Select "Insert-Cells", and set the path of the previous cell when inserting a cell in the dialog box. [Insert-Rows], [Insert-Columns], [Insert-Worksheet] menus are used when inserting new rows, columns, worksheets on the Sheet. Function Constitution of Functions 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. CHAPTER 3: HancomMobileSheet 49 Function Name PV Invariable (pmt, nper, rate, fv, point) Creating Functions The following is a simple example of a function and invariables. The formula of cell A4 uses multiple functions to perform a simple mathematical calculation. The result of cell A5 is an example of using the result of one function as an invariable of another function. Cell A5 is the average of the two results combination of profits and expenses. In this way, a function can also be used in a different function as an invariable. There are always parentheses around functions, therefore the two parenthesis must always match, otherwise an error will occur. Name To indicate a name in a certain area of the Sheet, put the cursor in cell A1 and select [Insert-Name], then the name define dialog box will appear. Name the area 'Jacky' and tap Add. [. . . ] Tap this menu to select different pen colors. To continue with the slide show, tap "Pause" again. (only *. hpt file) Exits the slide show and returns to the main screen of the program. Moving to a Desired Slide The title of each slide is displayed when you tap "Go To" from the Popup menu(If there are no titles for the slides, they will be displayed in a "1 Slide, 2 Slide. . . " format. ). You can move to a selected slide by tapping the title or the number of the slide. CHAPTER 4: HancomMobilePresenter 71 About Pen Marking To mark simple contents on the slide, tap "Pen Show" from the Popup menu and manually drag on the screen. By selecting a pen color, you enter pen mode. Tap "Pen Color" from the Popup menu to select a variety of pen colors. To finish using the pen marking, re-open the Popup menu, and tap "Pen Hide". 72 CHAPTER 4: HancomMobilePresenter To erase the contents marked on the slide, tap "Erase Pen" from the Popup menu. Ending a Slide Show The Slide Show will end and the program will return to the main screen when you tap the screen at the final slide. [. . . ]