Spreadsheet Toolkit
A B C D E F G H I J L M N O P R S T U V W X Y Z

C

calculateCol(int) - Method in class corpus.doodle.AbstractVisualisationPane
Convert from a x pixel back to the x coordinate.
calculateRow(int) - Method in class corpus.doodle.AbstractVisualisationPane
Convert from a y pixel back to the y coordinate.
calculateX(double) - Method in class corpus.doodle.Animation
 
calculateX(double) - Method in class corpus.doodle.AbstractVisualisationPane
Convert a x coordinate into a pixel coordinate.
calculateY(double) - Method in class corpus.doodle.Animation
 
calculateY(double) - Method in class corpus.doodle.AbstractVisualisationPane
Convert a y coordinate into a pixel coordinate.
calculateZ(int) - Method in class corpus.doodle.AbstractVisualisationPane
Convert a z coordinate into a pixel coordinate.
CARET - Static variable in class corpus.excel.Operator
 
Cell - class corpus.excel.Cell.
Used to store the internal representation of a Cell.
Cell(int, int) - Constructor for class corpus.excel.Cell
Creates a new Cell at Col x and Row y
Cell(int, int, String, String) - Constructor for class corpus.excel.Cell
Creates a new Cell at Col x and Row y with a value and a formula (both as strings).
Cell(int, int, String, String, String[]) - Constructor for class corpus.excel.Cell
Creates a new Cell at Col x and Row y with a value and a formula.
CellCluster - class corpus.doodle.CellCluster.
Displays Cell classifications on a grid.
CellCluster(WorkSheet) - Constructor for class corpus.doodle.CellCluster
Create a Cell Cluster diagram for the parameter WorkSheet
CellCluster(WorkSheet, String) - Constructor for class corpus.doodle.CellCluster
Create a Cell Cluster diagram for the parameter WorkSheet with the given title.
cellGrid() - Method in class corpus.excel.WorkSheet
A grid version of the cells in this worksheet.
cellHeight - Variable in class corpus.doodle.AbstractVisualisationPane
The pixel height of a single cell in the visualisation
CellReference - class corpus.excel.CellReference.
Used to store the internal representation of a referecnce to a single Cell in a Formula.
CellReference(int, int, boolean, boolean, String) - Constructor for class corpus.excel.CellReference
 
CellReference(int, int, int) - Constructor for class corpus.excel.CellReference
Creates a new CellReference for the Cell at Col x and Row y and Sheetdepth z.
CellReferenceParser - class corpus.excel.parser.CellReferenceParser.
A parser for a formula component.
CellReferenceParser() - Constructor for class corpus.excel.parser.CellReferenceParser
 
cellWidth - Variable in class corpus.doodle.AbstractVisualisationPane
The pixel width of a single cell in the visualisation
center - Variable in class corpus.doodle.RadarWidget
 
center - Variable in class corpus.doodle.EquivalenceWidget
 
checkNaN() - Method in class corpus.analyser.MathVector
Returns true if one of the components of the MathVector is a Double.NaN
checkPath(String) - Static method in class corpus.fileIO.FileIO
Converts file paths to use local OS path.separator.
checkPoints(double, double, double) - Method in class corpus.doodle.AbstractVisualisationPane
Records the largest and smallest x,y,z values seen
checkPoints(double, double, double, double, double, double) - Method in class corpus.doodle.AbstractVisualisationPane
Records the largest and smallest x,y,z values seen
classification(Cell) - Static method in class corpus.excel.Cell
Dumps the classification of the cell to System.out
classificationString(Cell) - Static method in class corpus.excel.Cell
 
classify(Cell, Graphics, int, int, int, int) - Method in class corpus.doodle.EquivalenceWidget
Paint a cell at x,y based on its classification.
cleanUrlFile(String) - Static method in class corpus.fileIO.FileIO
Remove any duplicates (done at load time) and sort.
clear(int, int) - Method in class corpus.analyser.Grid
Sets the cell at x, y to null
close() - Method in class corpus.fileIO.Zip
Should be done after all entries have been added.
close() - Method in class corpus.fileIO.ZipInfo
 
closeDownExcel() - Method in class corpus.extractor.ExcelaccessorRead
Shutsdown excel, currently further attempts to use extractor will fail.
CLUSTER - Static variable in class corpus.analyser.Analyser
Similar to occupancy, except performs clustering using ClusterGraph.
ClusterAnalyser - class corpus.analyser.ClusterAnalyser.
This class is responsible for reading in a bunch of spreadsheets, using the extractor to get the data out, doing some processing on them, and then passing the information to the user as a clustering diagram.
ClusterAnalyser(String, int) - Constructor for class corpus.analyser.ClusterAnalyser
 
ClusterGraph - class corpus.doodle.ClusterGraph.
Displays Cells stored in a grid and clusters that contain them.
ClusterGraph(Grid) - Constructor for class corpus.doodle.ClusterGraph
 
ClusterGraph(Grid, String) - Constructor for class corpus.doodle.ClusterGraph
 
ClusterGraph(Grid, String, boolean, boolean, boolean) - Constructor for class corpus.doodle.ClusterGraph
 
COL_PATTERN - Static variable in class corpus.excel.parser.CellReferenceParser
Useg with GNU regular expressions to recoginse a cells column component.
colorBar(Color[]) - Method in class corpus.doodle.AbstractVisualisationPane
Dumps the ColorCodeTable at the bottom of the screen.
colorBar(int) - Method in class corpus.doodle.AbstractVisualisationPane
Creates and then dumps the ColorCodeTable for N to the screen.
colorLookup - Variable in class corpus.doodle.AbstractVisualisationPane
A fairly evenly distributed range of colors.
colorMax - Variable in class corpus.doodle.AbstractVisualisationPane
The maximum number of colors
Column - class corpus.excel.Column.
Used to store the internal representation of a Column in a grid.
COLUMN_PATTERN - Static variable in class corpus.excel.parser.VectorParser
 
Column(String, Grid) - Constructor for class corpus.excel.Column
 
ColumnRange - class corpus.excel.ColumnRange.
Used to store the internal representation of a Column Range.
ColumnRange(Column, Column) - Constructor for class corpus.excel.ColumnRange
 
ComboDialog - class corpus.fileIO.ComboDialog.
Used to provide a Dialog Box that contains a Combobox of possible inputs.
ComboDialog(Object[]) - Constructor for class corpus.fileIO.ComboDialog
Very Basic ComboDialog
compare(Function) - Method in class corpus.excel.Function
 
COMPARISON - Static variable in class corpus.excel.Operator
 
COMPARRISON_PATTERN - Static variable in class corpus.excel.parser.OperatorParser
 
Component - class corpus.excel.Component.
Used to store the internal representation of a Spreadsheet.
Component() - Constructor for class corpus.excel.Component
 
compress(byte[]) - Static method in class corpus.fileIO.Zip
Given a byte array will return a zip compressed version.
compressDirectory(Directory) - Static method in class corpus.fileIO.Zip
Will compress all the files in a directory and store them in a zip file in the directories parent.
COMPRESSION - Static variable in class corpus.analyser.Analyser
Reports on zip compresison levels for saved workbooks.
CompressionAnalyser - class corpus.analyser.CompressionAnalyser.
This class is responsible for reading in a bunch of spreadsheets, using the extractor to get the data out, doing some processing on them, and then passing the information onto Doodler.
CompressionAnalyser(String, int) - Constructor for class corpus.analyser.CompressionAnalyser
 
compressionLevel(byte[]) - Static method in class corpus.fileIO.ZipInfo
Calculates the packed and unpacked size of the zip file and returns the compression ratio as a percentage (2 d.p.)
compressionLevel(String) - Static method in class corpus.fileIO.ZipInfo
Calculates the packed and unpacked size of the zip file and returns the compression ratio as a percentage (2 d.p.)
computeArrowHead(Point2D, Point2D) - Method in class corpus.doodle.RadarWidget
Calculate the points used to represent the arrowhead.
computeArrowHead(Point2D, Point2D) - Method in class corpus.doodle.AbstractVisualisationPane
Calculate the points used to represent the arrowhead.
CONCATINATION_PATTERN - Static variable in class corpus.excel.parser.OperatorParser
 
CONCATIONATION - Static variable in class corpus.excel.Operator
 
contents(int, int) - Static method in class corpus.doodle.AbstractVisualisationPane
Returns a String about the element at the given coordinates.
contentsPaths() - Method in class corpus.fileIO.Directory
Creates a String[] containing the path for each file/directory in this Directory.
Context - class corpus.doodle.Context.
The Context class provides a mechanism to control the environment in which the program is running.
Context() - Constructor for class corpus.doodle.Context
 
coords - Variable in class corpus.excel.CellReference
The coordinates of this cell 0: Column 1: Row 2: Depth of the worksheet that the cell being referred to is in.
coords - Variable in class corpus.excel.Cell
The coordinates of this cell 0: Column 1: Row 2: Depth
corpus.analyser - package corpus.analyser
Provides classes and interfaces for analysing the contents of spreadsheets.
corpus.doodle - package corpus.doodle
Provides classes and interfaces for displaying the contents of spreadsheets.
corpus.excel - package corpus.excel
Provides classes and interfaces for representing the contents of individial spreadsheets.
corpus.excel.parser - package corpus.excel.parser
Classes to parse a String formula into the toolkits internal format.
corpus.extractor - package corpus.extractor
Provides classes and interfaces for converting between Excel's BIFF encoding to that used by the toolkit.
corpus.fetcher - package corpus.fetcher
Downloads ands stores files from the Internet.
corpus.fileIO - package corpus.fileIO
Helper io classes.
corpus.gobbler - package corpus.gobbler
Finding spreadsheets on the Internet using Google.
countCatagory(Function[]) - Static method in class corpus.excel.Function
Takes an array of functions and counts how many occupy each of the different categories.
create(String) - Static method in class corpus.fileIO.Directory
Create a new directory for the given path.
createBWColorCodeTable(int) - Method in class corpus.doodle.AbstractVisualisationPane
Generates a greyscale series of colors such that the distribution of the colors is (fairly) evenly spaced from white to black.
createCellGrid() - Method in class corpus.excel.WorkSheet
Create Cell Grid, turns the values and formula grids into a cell grid.
createColorCodeTable(int, boolean) - Method in class corpus.doodle.AbstractVisualisationPane
Generates a series of colors such that the distribution of the colors is (fairly) evenly spaced throughout the color spectrum.
crossProduct(MathVector, MathVector) - Static method in class corpus.analyser.MathVector
Anton pg787
CryptoLibrary - class corpus.fileIO.CryptoLibrary.
Used to perfrom BASE64 encription and decription around a master password.
CryptoLibrary(String) - Constructor for class corpus.fileIO.CryptoLibrary
Create the encryption/decription object for the given master password.

Spreadsheet Toolkit
A B C D E F G H I J L M N O P R S T U V W X Y Z
Project Home Page