README
Sharp Tools Spreadsheet
Version 1.0
for Java(TM) 2 SDK, v1.3.0
Sharp Tools Software
<sharp@cs.columbia.edu>
Sharp Tools spreadsheet was originally a Software Engineering course project
finished in the fall of 2000 by five CS students at Columbia University. It
is not a commecial product, nor is it meant to replace StarOffice, but it has
all the basic functionality as a spreadsheet. We also hope people can learn
from the code.
Sharp Tools Spreadsheet Version 1.0 fully implements various features, such
as:
- File Operations
- Open and Save files using a tab-delimited format (*.sts) that is compatible with other existing spreadsheet applications
- Editing Operations
- Undo and Redo functionality, allowing for the recovery of changes up to the last file load
- Cut, Copy, and Paste functions
- One-click cell deletion
- Find and Find Next, allowing for easy searching
- Table Operations
- Row and column range selection
- Insert and Delete Row and Column operations, allowing for table resizing
- Fill Range, allowing for simple input of repetitive entries
- Sort Row and Column, for easier analysis of data
- Printing
- Windows and Unix printing capability
- Histograms
- Multiple Histograms
- Regraphable
- Configurable
- Help
- Built-in Help Browser
- Function Help
- Formula Operations
- Dynamic formula value updating
- Variable-length parameter input to formulas (using string
literals, relative addressing, absolute addressing, and range
specification)
- Symbolic formula operations, including: addition,
subtraction, floating-point division, multiplication, modulo, and exponent
- Formula functions include: summation (SUM), average
(AVERAGE), count (COUNT), minimum (MIN),
maximum(MAX), absolute value (ABS), range (RANGE), sine
(SIN), cosine (COS), tangent (TAN), arcsine
(ASIN), arccosine (ACOS), arctangent (ATAN), rounding
(ROUND), square root (SQRT), logarithm (LOG), mean
deviation (MEANDEV), standard deviation (STDDEV), pi
(PI), and e (E)
- Security
- A user-defined password option
- Preferences
- User-specified startup options via the sharptools.cfg file
The on-line Sharp Tools Spreadsheet Documentation [web] contains complete javadocs
and reference pages for Sharp Tools Spreadsheet. This documentation is also available
in the doc directory.
Sharp Tools Spreadsheet requires Java 2 SDK, v 1.3.0 or above on Windows, Linux,
and Solaris.
You should have about 1 MB of free disk space before attempting to install
the Sharp Tools Spreadsheet package.
To install Sharp Tools Spreadsheet, simply copy the bin directory from the distribution to your hard drive. From within that directory you may use the sharptools bash script to run the software. If the script if run with a parameter, that file will be loaded.
java SharpTools ../doc/sample.sts
Alternatively, Windows users may simply double-click on SharpTools.bat
within the same directory, and Linux/Unix users can run the script SharpTools.
Users who wish to install from the source may do so using gnumake
and executing the following commands (make sure the correct javac is in your
PATH):
cd src
make (on Unix/Linux)
or
javac SharpTools.java (on Windows)
You may submit bug reports and comments via http://www.cs.columbia.edu/sharptools/.
This section contains a general summary of the files and directories in the Sharp
Tools Spreadsheet package.
- src: all source files.
- doc: documentation. Javadocs and manuals for the Sharp Tools Spreadsheet,
sample spreadsheet files, as well as a manifest of the entire contents of
the package
- bin: pre-compiled class files and a SharpTools.bat for Windows..
- testing: testing documents.
Sharp Tools Spreadsheet is a product of the Sharp Tools Software Engineering Team:
- Hua Zhong (Team Leader)
- Ricky Chin
- Daniel Goldberg
- Andrei Scudder
- Daniel Medina
Contact us by email: sharp@cs.columbia.edu
Contact us online at http://www.cs.columbia.edu/sharptools
Daniel Medina
2000-12-06