Introduction
Thank you for choosing UMSpreadSheet. UMSpreadSheet is a Pure Java product written primarily for business and academic transactions. The software is a part of the OfficeSoft package. This user manual can help you get the most out of our product and treats the spreadsheet as a stand alone package. UMSpreadSheet features
·A Friendly Interface
·Configurable Preferences
·Formulas and References
·File Operations
Clipboard Operations Installing and Running
UMSpreadSheet is written for Java (TM) 2 SDK, v1.4.1. You can download Java from http://java.sun.com. The entire UMSpreadSheet package, including pre-compiled binaries, source files, and documentation), is about 850 KB.
Windows
The first step to installing UMSpreadsheet is to make sure Java 1.3.1 or higher is installed on your computer. If Java 1.3.1 is not installed, it can be downloaded from http://java.sun.com/. Once java is installed onto your computer, simply extract the zip file to a directory on your hard drive. UMSpreadsheet may now be started by running the UMSpreadsheet.bat file in the directory where you unzipped the file. You may also start UMSpreadsheet by issuing the following command in a command prompt:
java
–cp images.jar;UMSpreadSheet.jar;jcommon.jar;jfreechart.jar;UMSpreadSheet
&
Compiling from Source
UMSpreadsheet may also be compiled from its
source by entering the “src” directory and running the
“Make.bat” file, or by first setting the classpath to the current directory and incorporating the
following jar files: jcommon.jar and jfreechart.jar and issuing the command “ javac
*.java”. After compiling the
program from its source, you may then run it by issuing the following command
“java
–cp images.jar;UMSpreadSheet.jar;jcommon.jar;jfreechart.jar;UMSpreadSheet
&
”.
Linux/Solaris
The first step to installing UMSpreadsheet in a *NIX environment is to have Java 1.4.1 or higher installed. If it is not installed, it can be downloaded from http://java.sun.com/. Once java is installed on your computer, simply extract the zip file to a directory on your hard drive. You may now start UMSpreadsheet by either running the UMSpreadsheet.sh file (you may need to give this file execute permission by running the command “chmod u+x UMSpreadsheet.sh”) or by running the following command in a terminal window:
java
–cp images.jar;UMSpreadSheet.jar;jcommon.jar;jfreechart.jar;UMSpreadSheet
&
Compiling from Source
UMSpreadsheet may also be compiled from source by entering
the “src” directory and running the “make.sh” file (again, you may need to give this file execute
permission by running the command “chmod
u+x make.sh”) or by
issuing the command “javac
*.java”. After compiling the
program from its source, you may then run it by issuing the command “java
–classpath images.jar; UMSpreadsheet”.Using
Layout
·Title Bar: The name of the current file appears on the right side of the Title Bar. On the left are buttons to Minimize, Maximize, and Close the Application.
·Menu Bar: Menu items are divided logically under File, Edit, Format and Functions Menu Headers.
·Toolbar: Contains buttons for easier access to menu items. Frequently used format options, such as font size, font face, bold, and italic, are also available here
·Worksheet: The worksheet contains data within cells. Rows and columns can be selected with the alphabetic and numeric header labels.
·Horizontal Scroll Bar: Allows the worksheet to be scrolled left and right to view all the cells.
·Vertical Scroll Bar: Allows the worksheet to be scrolled up and down to view all the cells.
Menu Bar
File
New
Keyboard Shortcut: Ctrl-N
Creates a new SpreadSheet.
Open
Keyboard Shortcut: Ctrl-O
Open a SpreadSheet.
Save
Keyboard Shortcut: Ctrl-S
Saves the current file, with
current password (if set) and location; not available if the spreadsheet is
unchanged from the last save.
Save As...
Keyboard Shortcut: None.
Saves the current file, allowing
for a different filename and location; begins Save dialog.
Files
are filtered to list only those ending .ums. You can list all files by selecting
All Files (*.*) from the Files of type menu. To save the file
as a file listed in the dialog, click on the name once, then click
Save. To save the file with a different name, enter the filename in the
File name field. If you wish to change directories, use the Look
in menu. You may also navigate by using the Up one directory
button, or the Home button, and then double-clicking on the folder
you wish to navigate to. Use the Create new folder button to make a new
folder in the current directory. You may cancel at any time by clicking the
Cancel button.
Print...
Keyboard Shortcut: Ctrl-P.
Prints the current spreadsheet
and begins a print dialog for Windows or Unix.
The
Windows print dialog above is the native Windows printing interface.
Below
is the print dialog for Unix platforms. 
Exit
Exits program
Edit
Undo
Keyboard Shortcut: Ctrl-Z
Undo the last operation except
for text operations.
Redo
Keyboard Shortcut: Ctrl-Y
Redo the last undo operation
except for text operations.
Cut
Keyboard Shortcut: Ctrl-X
Simply select a cell or range of
cells to cut, then select either the Cut menu item or button to cut the
selection. If a row or column header is selected, Cut will cut all the
values, but will not actually remove the row or column. Cut clears all
the cells in the selected range and copies the contents to the clipboard
Copy
Keyboard Shortcut:
Ctrl-C
Copy
is very similar to Cut. Simply select a cell or range of cells to cut,
then select either the Copy menu item or button to copy the selection.
Copy leaves the contents of the selected cells where they are and
copies the values to the clipboard.
Paste
Keyboard Shortcut:
Ctrl-V
Paste
takes the contents of the clipboard and pastes the value back into the
spreadsheet. Simple select a cell on the spreadsheet, then select either the
Paste menu item or button to paste the contents of the clipboard. The
region in the clipboard will be inserted with the selected cell as the upper
left-hand corner of the region. If the clipboard region is larger than the
region that is available in the current spreadsheet, as much of the clipboard
region will be pasted as possible.
Clear
Keyboard Shortcut: Delete
Clear deletes the values of all selected cells
Find
Keyboard Shortcut: Ctrl-F
Looks for text that is specified
in all the cells within the SpreadSheet.
Format
Insert Row/Column
Keyboard Shortcut: Ctrl-Insert/Ctrl-Shift-Insert
Inserts a
Row or Column where the selected cell is located.
Delete Row/Column
Keyboard Shortcut: Ctrl-Delete/Ctrl-Shift-Delete
Deletes a
Row or Column where the selected cell is located.
Column Width
Resize the width of every cell in the selected column.
Row Height
Resizes the height of every cell in the selected row.
Format Cell
Provides options to format cell attributes. These attributes include the cell’s font face, font color, background color, and borders.
Functions
Sum
Sums the numbers or cells listed as the arguments.
Average
Averages the numbers or cells listed as the arguments.
Min
Computes the minimum of the numbers or cells listed in the arguments.
Max
Computes the maximum of the numbers or cells listed in the arguments.
Square Root
Computes the square root of the number or cell listed as the argument.
Sine
Computes the Sine of the number or cell listed as the argument.
Count
Counts the number of cells in the range listed as the argument.
The use of these functions are described in the Formulas section of this manual.
Graphs
Pie, Column, Row, Line
If the information is not structured in the following manner, the graphing option
will not produce any charts.
To be able to use the graphing utility, you must structure your
information in the following manner to produce the above charts:
Use string labels down the first column to label the
parts of the graph. The values that correspond to these
labels belong in the succeeding columns. See examples below.
COLUMN/ROW
1 2 3 4....
1 label1 12.0 13.0
2 label2 5.6 14.9
3 label3 7.6 6.0
4
.
.
.
PIE
1 2
1 label1 12.0
2 label2 5.6
3 label3 7.6
Note: With a Pie chart, you can have only 1 column of values.
Line
To create a Line chart, use 2 columns. The first column should contain values
that belong on the X-axis. The second column should contain values that correspond
to the Y-axis.
X
Y
2.0 40.0
4.0 23.0
6.0 56.0
20.0 2.0
Toolbar
·New: Create new file.
·Open: Load a file.
·Save: Save the current file; grayed out when nothing to be saved.
·Print: Prints the current file.
·Cut: Cut selected range.
·Copy: Copy selected range.
·Paste: Paste clipboard contents into spreadsheet.
·Format: Brings up format menu.
·Function selector: Picks a function for cell(s) operation.
·Font Face selector: Changes the font face of currently selected range.
·Font Size selector: Changes the font size of currently selected range.
·Italic: Toggles the Italic attribute of selected range.
Bold: Toggles the Bold attribute of selected range.Formulas
Input
Data is input to cells in the workspace. When a cell is clicked on, or highlighted, it is said to be selected. To make a cell editable, double-click on it. To select a range, select a cell and drag the mouse over the desired region. The selected range will be highlighted. When editing a cell, you may enter text, literals, or functions. These are a few examples of each:
·Text: “Final Score”, “First Name”, “Last Name”, etc.
·Literals: “-1”,
“0”,
“3.14”,
“100”,
etc.
·Formulas: “=SUM(A1, A3)”, “=(5+2)”, etc.
Formulas can be recognized because they all begin with the “=” sign. More information on formulas can be found later in this manual.
Symbolic Operators
UMSpreadSheet implements various symbolic formula operations:
·multiplication (*)
·addition (+)
·subtraction (-)
·floating-point division (/)
·modulo (%)
·exponent (^)
These operators can be used in formulas between number, other formulas, or combinations of both.
Functions
Functions are predefined formulas provided by UMSpreadsheet which perform a mathematical calculation.
Arguments
Arguments to a function can be numbers, cell addresses, or a range of cell addresses. A cell address is the address of a single cell, such as “A1”, or “B5”. A range of cell addresses is constructed by the first cell address of the range followed by a colon which is then followed by the last cell address of the range. For example, the range of cells from A1 to A3 (A1, A2, and A3) would be constructed as “A1:A3”. Ranges can also span columns such as “A1:B3”.
Function Usage
The structure of a function begins
with the equal sign (=), the function name, an opening
parenthesis, the arguments for the function separated by commas, and a closing
parenthesis.
=FUNCTION(ARGUMENT1,ARGUMENT2,...)
The following
are the details of the functions provided by UMSpreadsheet
·AVERAGE
Usage: =AVERAGE(argument1,argument2,...)
Returns the average (arithmetic mean) of its arguments.
Examples: =AVERAGE(A1, A2, B1:B3)
=AVERAGE(1, 2, 3)
·COUNT
Usage: =COUNT(argument1,argument2,...)
Returns the number of its arguments.
Example: =COUNT(A1:A25,B1) returns 26.0.
·MAX
Usage: =MAX(argument1,argument2,...)
Returns the largest number among its arguments.
Example:=MAX(99.99,100,99.9999) returns 100.0.
·MIN
Usage: =MIN(argument1,argument2,...)
Returns the largest average absolute deviation of its arguments.
Example: =MIN(5, 4, 3) returns 3
·SQRT
Usage: =SQRT(argument)
Returns the square root of its argument.
Example: =SQRT(A1)
·SUM
Usage: =SUM(argument1,argument2,...)
Adds up the specified arguments.
Example: =SUM(A1:A3, B1:B5)
·SIN
Usage: =SIN(argument)
Returns the sine of the argument
Example: =SIN(3.14)
Addressing modes
UMSpreadsheet uses two types of addressing in formulas, relative and absolute. Relative addressing means that when a cell is copied, the cell addresses in its function are changed to reflect their new position. Absolute addressing means that the addresses in the formula never change. To use absolute addressing place dollar signs ($) in front of the cell column and row. For example the cell “A1” would become “$A$1”. Absolute and relative addressing may both be used in the same formula like in the following example:
If the cell C1 contained the formula “=(B1/$A$1)”, if this formula is copied and pasted into the cell C2, that cell would then contain the formula “=(B2/$A$1)”. The use of relative and absolute addressing can be used with any formula or function.
Errors
Errors are of the form #ERROR?, where ERROR is the type of error. There are several errors that are possible when entering formulas:
·#PAREN: Missing a parenthesis.
Example: =SUM(A1:A25
·#NUM?: Improper number format.
Example: 2.3.4
·#OP?: Improper use of an operator.
Example: =2++3
·#NAME?: An unknown syntax.
Example: =AD
·#REFS?: A cell that does not exist has been referenced.
Example: =QQ123
·#EVAL?: The input cannot be evaluated properly.
Example: =A4:B4+1
·#FUNC?: An unknown function has been used
Example: =NOP()
·#PARAM?: Too many or too few arguments specified.
Example: =MIN()
·#
Example: Cell
A1 contains “=SUM(A2,
A3)”
Cell A3 contains “=SUM(A1:A2)”
Credits
UMSpreadsheet is a product of the OfficeSoft Engineering team:
·Patrick Hannon (Manager)
·Ricky Koo (Coding)
·Alvin Lam (Coding)
·Serey Lay (Coding)
·Amar Kalelkar (Tester)
·Johny John (Tester)
·Nora Husain (Tester)
Manual written by Jimi Kolawole
edited by: Ricky Koo, Amar Kalelkar