Back to index

wims  3.65+svn20090927
Classes
Package SharpTools

This is an object the represents the coordinates of a cell in the table. More...

Classes

class  AddressField
 This class is used to only allow address input (letters followed by numbers). More...
class  Cell
 This is a wrapper class for all objects in the table. More...
class  CellPoint
class  CellRange
 This class specifies how a range of cells are represented. More...
class  Config
 This class reads configuration file and provides get functions for other classes to retrieve the information. More...
class  ConnectDialog
 This class provides a database conection dialog. More...
class  Database
 This contains database operations on the spreadsheet table. More...
class  Debug
class  EditOp
 This contain certain higher level edit operations on the spreadsheet table. More...
class  FileOp
 Handles the saving and opening of files, and the updating of the table model appropriately. More...
class  RecentFileListener
 This is the listener for "Recent Files" menu. More...
class  FindDialog
 This class provides a find dialog. More...
class  Formula
 This is the class for formula processing. More...
class  Function
 Function classes used only by Formula to evaluate functions. More...
class  FunctionSum
 SUM
usage: =SUM(parameter list)
returns the arithmetic sum of the specified parameters
example: =SUM(-1,2,57) returns 58.0 More...
class  FunctionCount
 COUNT
usage: =COUNT(parameter list)
returns the number of parameters specified
example: =COUNT(A1:A7) returns 7.0 More...
class  FunctionAverage
 AVERAGE
usage: =AVERAGE(parameter list)
returns the arithmetic mean of the specified parameters
example: =AVERAGE(1,2,3) returns 2.0 More...
class  FunctionMedian
 MEDIAN
usage: =MEDIAN(parameter list)
returns the median (the value in the middle) of the specified parameters
example: =MEDIAN(1,2,5) returns 2.0 More...
class  FunctionMin
 MIN
usage: =MIN(parameter list)
returns the minimum value of the specified parameters
example: =MIN(5,6,-1) returns -1.0 More...
class  FunctionMax
 MAX
usage: =MAX(parameter list)
returns the maximum value of the specified parameters
example: =MAX(5,6,-1) returns 6.0 More...
class  FunctionRange
 Range More...
class  FunctionAbs
 ABS
usage: =ABS(parameter)
accepts only one literal or address
returns the absolute value of the specified parameter
example: =ABS(-92) returns 92.0 More...
class  FunctionSin
 SIN
usage: =SIN(parameter)
accepts only one literal or address
returns the sine of the specified parameter (in radians)
example: =SIN(45) returns 0.8509035 More...
class  FunctionCos
 COS
usage: =COS(parameter)
accepts only one literal or address
returns the cosine of the specified parameter (in radians)
example: =COS(30) returns 0.15425146 More...
class  FunctionTan
 TAN
usage: =TAN(parameter)
accepts only one literal or address
returns the tangent of the specified parameter (in radians)
example: =TAN(60) returns 0.32004037 More...
class  FunctionAsin
 ASIN
usage: =ASIN(parameter)
accepts only one literal or address
returns the arcsine of the specified parameter (in radians)
example: =ASIN(60) returns 0.5235988 More...
class  FunctionAcos
 ACOS
usage: =ACOS(parameter)
accepts only one literal or address
returns the arccosine of the specified parameter (in radians)
example: =ACOS(.5) returns 1.0471976 More...
class  FunctionAtan
 ATAN
usage: =ATAN(parameter)
accepts only one literal or address
returns the arctangent of the specified parameter (in radians)
example: =ATAN(60) returns 1.5541312 More...
class  FunctionInt
 INT returns the integer part of a number More...
class  FunctionRound
 ROUND
usage: =ROUND(parameter, num_digits)
Rounds a number to a specified number of digits
example: =ROUND(1.534, 2) returns 1.53 More...
class  FunctionSqrt
 SQRT
usage: =STDDEV(parameter)
returns the standard deviation of the specified parameter
example: =SQRT(19044) returns 138.0 More...
class  FunctionLog
 LOG
usage: =LOG(parameter)
returns the logarithm base E of the specified parameter
example: =LOG(1) returns 0.0 More...
class  FunctionMeandev
 MEANDEV
usage: =MEANDEV(parameter list)
returns the mean deviation of the specified parameters
example: =STDDEV(100,60,60,80,80) returns 12.8 More...
class  FunctionStddev
 STDDEV
usage: =STDDEV(parameter list)
returns the standard deviation of the specified parameters
example: =STDDEV(100,60,60,80,80) returns 16.7332 More...
class  FunctionPI
 This gives us contant PI. More...
class  FunctionE
 This gives us contant E. More...
class  HelpOp
 Code taken from http://www.inquiry.com/techtips/java_pro/answer.asp?pro=java_pro&docID=2282. More...
class  FunctionListListener
 Implements help on functions. More...
class  HistoDialog
 This is used to provide options configuration for a histogram. More...
class  Histogram
 This is a fully functional histogram class (including UI). More...
class  History
 This is the class to support nearly-arbitrary undo/redo operations. More...
class  MainApplet
class  NewFileDialog
 This class provides a new-file dialog. More...
class  Node
 Node is basic unit for Formula processing. More...
class  NumberField
 This class is used to only allow number input (int/float). More...
class  ParserException
 This Exception is raised when Formula fails in tokenizing or parsing the formula. More...
class  PasswordDialog
 This class provides a password validating dialog. More...
class  SharpCellEditor
 This is the only editor for the SharpTableModel because it is the only cell object editor. More...
class  SharpCellRenderer
 The class for rendering (displaying) individual Cell objects in a JTable. More...
class  SharpClipboard
class  SharpDialog
class  SharpOptionPane
class  SharpTableModel
 This is the table data structure of the spreadsheet (i.e. More...
class  SharpTools
 This is the graphical user interface class for the spreadsheet. More...
class  SharpToolsProperties
class  SortDialog
 This class provides a sort dialog. More...
class  TableOp
 This contain certain higher level operations on the spreadsheet table such as sorting. More...
class  TabPanel
 A class for one panel, which includes the image panel and all the control components. More...
class  HistoPanel
 The is the panel to draw histogram on. More...

Detailed Description

This is an object the represents the coordinates of a cell in the table.

This class provides dialogs that can display a message or receive input to the user.

This is a customized dialog which provides standard buttons.

This clipboard class holds the objects that will be cut and pasted to a spreadsheet.

It is used as entries in the reference list of each cell. In addition, it is sometimes used as parameters of table manipulation methods. CellPoints are better parameters because there is no worry that someone will switch the order of parameters (ie. type column first and then row instead of the other way around).

Author:
Ricky Chin
Version:
Revision:
1.13

Actually, it creates a string representation of the range of cell objects that is compatible with Microsoft Excel and the Windows clipboard. It also remembers the range of the cells in the table from which it was created. This class is used for many table manipulation methods.

Author:
Ricky Chin
Version:
Revision:
1.18
Author:
Hua Zhong
Version:
Revision:
1.3

It has customized Buttons.

The class is used to replace JOptionPane.

Author:
Hua Zhong
Version:
Revision:
1.9

Class Documentation

class SharpTools::SharpToolsProperties

Definition at line 3 of file SharpToolsProperties.java.