Uses of Interface
csheets.core.Cell

Packages that use Cell

Package	Description
csheets.core	Provides the core classes for the application's data model, i.e. workbooks, spreadsheets, cells, addresses and values.
csheets.core.formula	Provides classes for representing formulas.
csheets.core.formula.compiler	Provides classes for compiling formulas from strings.
csheets.core.formula.lang	Provides the operators, functions and references supported by the formula language.
csheets.ext	Provides an extension mechanism for the application.
csheets.ext.assertion	Provides support for user-specified and system-generated assertions.
csheets.ext.assertion.ui	Provides UI components for displaying and providing editing of assertions.
csheets.ext.comments	Provides an extension to support comments on cells.
csheets.ext.comments.ui	Provides the UI of an extension to support comments on cells.
csheets.ext.database.controller
csheets.ext.database.core
csheets.ext.database.ui
csheets.ext.deptree	Provides customized JTree components for displaying dependencies between cells.
csheets.ext.share.controller	Package that contains the controllers of the sharing extension
csheets.ext.share.core	The package of the main core of extension
csheets.ext.share.ui	The package of the Sharing Extension UI.
csheets.ext.style	Provides support for cell style, i.e. font, format, alignment, color and border.
csheets.ext.test	Provides support for test cases and test case parameters.
csheets.ext.test.ui	Provides specialized JTable components for displaying and providing editing of test cases and test case parameters.
csheets.ui.ctrl	Provides controllers and actions for the user interface.
csheets.ui.ext	Provides an extension mechanism for the application's user interface.
csheets.ui.sheet	Provides customized components for displaying and providing editing of spreadsheets.

Uses of Cell in csheets.core

Classes in csheets.core that implement Cell

Modifier and Type	Class and Description
class	CellImpl The implementation of the Cell interface.

Methods in csheets.core that return Cell

Modifier and Type	Method and Description
Cell	SpreadsheetImpl.getCell(Address address)
Cell	Spreadsheet.getCell(Address address) Returns the cell at the given address.
Cell	SpreadsheetImpl.getCell(int column, int row)
Cell	Spreadsheet.getCell(int column, int row) Returns the cell at the given column and row in the spreadsheet.
Cell[]	SpreadsheetImpl.getColumn(int index)
Cell[]	Spreadsheet.getColumn(int index) Returns the cells in the given column.
Cell	CellImpl.getExtension(String name)
Cell[]	SpreadsheetImpl.getRow(int index)
Cell[]	Spreadsheet.getRow(int index) Returns the cells in the given row.

Methods in csheets.core that return types with arguments of type Cell

Modifier and Type	Method and Description
SortedSet<Cell>	SpreadsheetImpl.getCells(Address address1, Address address2)
SortedSet<Cell>	Spreadsheet.getCells(Address address1, Address address2) Returns the cells in the range between the given addresses.
SortedSet<Cell>	CellImpl.getDependents()
SortedSet<Cell>	Cell.getDependents() Returns the dependents of the cell, i.e. the cells that contain a reference to the cell in their formula.
SortedSet<Cell>	CellImpl.getPrecedents()
SortedSet<Cell>	Cell.getPrecedents() Returns the precedents of the cell, i.e. the cells that the formula in the cell references.
Iterator<Cell>	SpreadsheetImpl.iterator()

Methods in csheets.core with parameters of type Cell

Modifier and Type	Method and Description
void	CellListener.cellCleared(Cell cell) Invoked when a cell has been cleared.
void	CellListener.cellCopied(Cell cell, Cell source) Invoked when a cell has been copied.
int	CellImpl.compareTo(Cell cell) Compares this cell with the specified cell for order, by comparing their addresses.
void	CellListener.contentChanged(Cell cell) Invoked when the content of a cell has been changed.
void	CellImpl.copyFrom(Cell source)
void	Cell.copyFrom(Cell source) Copies all data from the source cell to this one.
void	CellListener.dependentsChanged(Cell cell) Invoked when a new dependent has been registered on a cell, or when an old one has been removed.
void	CellImpl.moveFrom(Cell source)
void	Cell.moveFrom(Cell source) Moves all data from the source cell to this one.
void	UpdateCellContent.triggerUpdate(Cell cell, Value value) updates a cell's content
void	CellListener.valueChanged(Cell cell) Invoked when the value of a cell has changed, either by a change in its content, or by a change of value in one of its precedents.

Uses of Cell in csheets.core.formula

Methods in csheets.core.formula that return Cell

Modifier and Type	Method and Description
Cell	Formula.getCell() Returns the cell to which the formula belongs.

Methods in csheets.core.formula that return types with arguments of type Cell

Modifier and Type	Method and Description
SortedSet<Cell>	Reference.getCells() Returns the cell addresses (or address) that the reference points to.

Constructors in csheets.core.formula with parameters of type Cell

Constructor and Description
Formula(Cell cell, Expression expression) Creates a new formula.

Uses of Cell in csheets.core.formula.compiler

Methods in csheets.core.formula.compiler with parameters of type Cell

Modifier and Type	Method and Description
Expression	NumberSignExpressionCompiler.compile(Cell cell, String source)
Formula	FormulaCompiler.compile(Cell cell, String source) Compiles a formula for the given cell from the given string.
Expression	ExpressionCompiler.compile(Cell cell, String source) Compiles an expression from the given string.
Expression	ExcelExpressionCompiler.compile(Cell cell, String source)
protected Expression	NumberSignExpressionCompiler.convert(Cell cell, antlr.collections.AST node) Converts the given ANTLR AST to an expression.
protected Expression	ExcelExpressionCompiler.convert(Cell cell, antlr.collections.AST node) Converts the given ANTLR AST to an expression.

Uses of Cell in csheets.core.formula.lang

Methods in csheets.core.formula.lang that return Cell

Modifier and Type	Method and Description
Cell	CellReference.getCell() Returns the cell to which the reference points.
Cell[][]	RangeReference.getCells(Reference reference1, Reference reference2) Returns the range of cells formed by the two cell references.

Methods in csheets.core.formula.lang that return types with arguments of type Cell

Modifier and Type	Method and Description
SortedSet<Cell>	RelationalOperatorImpl.getCells()
SortedSet<Cell>	ReferenceOperation.getCells()
SortedSet<Cell>	CellReference.getCells()

Constructors in csheets.core.formula.lang with parameters of type Cell

Constructor and Description
CellReference(Cell cell) Creates a new cell reference to the given address.
CellReference(Cell cell, boolean columnAbsolute, boolean rowAbsolute) Creates a new cell reference to the given address, using the given reference mode.

Uses of Cell in csheets.ext

Classes in csheets.ext that implement Cell

Modifier and Type	Class and Description
class	CellExtension A base class for extensions of cells in a spreadsheet that uses delegation to provide cell data.

Methods in csheets.ext that return Cell

Modifier and Type	Method and Description
Cell	SpreadsheetExtension.getCell(Address address)
Cell	SpreadsheetExtension.getCell(int column, int row)
Cell[]	SpreadsheetExtension.getColumn(int index)
Cell	CellExtension.getDelegate() Returns the extension's delegate.
Cell	CellExtension.getExtension(String name)
Cell[]	SpreadsheetExtension.getRow(int index)

Methods in csheets.ext that return types with arguments of type Cell

Modifier and Type	Method and Description
SortedSet<Cell>	SpreadsheetExtension.getCells(Address address1, Address address2)
SortedSet<Cell>	CellExtension.getDependents()
SortedSet<Cell>	CellExtension.getPrecedents()
Iterator<Cell>	SpreadsheetExtension.iterator()

Methods in csheets.ext with parameters of type Cell

Modifier and Type	Method and Description
void	CellExtension.cellCleared(Cell cell)
void	CellExtension.cellCopied(Cell cell, Cell source)
int	CellExtension.compareTo(Cell cell)
void	CellExtension.contentChanged(Cell cell)
void	CellExtension.copyFrom(Cell source)
void	CellExtension.dependentsChanged(Cell cell)
CellExtension	Extension.extend(Cell cell) Returns an extension of the given cell.
void	CellExtension.moveFrom(Cell source)
void	CellExtension.valueChanged(Cell cell)

Constructors in csheets.ext with parameters of type Cell

Constructor and Description
CellExtension(Cell delegate, String name) Creates a new cell extension.

Uses of Cell in csheets.ext.assertion

Classes in csheets.ext.assertion that implement Cell

Modifier and Type	Class and Description
class	AssertableCell An extension of a cell in a spreadsheet, with support for assertions.

Methods in csheets.ext.assertion with parameters of type Cell

Modifier and Type	Method and Description
void	AssertableCell.contentChanged(Cell cell)
AssertableCell	AssertionExtension.extend(Cell cell) Makes the given cell assertable.

Constructors in csheets.ext.assertion with parameters of type Cell

Constructor and Description
AssertableCell(Cell cell) Creates a assertable cell extension for the given cell.

Uses of Cell in csheets.ext.assertion.ui

Methods in csheets.ext.assertion.ui with parameters of type Cell

Modifier and Type	Method and Description
void	AssertableCellDecorator.decorate(JComponent component, Graphics g, Cell cell, boolean selected, boolean hasFocus) Decorates the given graphics context if the cell being rendered has an assertion error.

Uses of Cell in csheets.ext.comments

Classes in csheets.ext.comments that implement Cell

Modifier and Type	Class and Description
class	CommentableCell An extension of a cell in a spreadsheet, with support for comments.

Methods in csheets.ext.comments with parameters of type Cell

Modifier and Type	Method and Description
CommentableCell	CommentsExtension.extend(Cell cell) Makes the given cell commentable.

Constructors in csheets.ext.comments with parameters of type Cell

Constructor and Description
CommentableCell(Cell cell) Creates a comentable cell extension for the given cell.

Uses of Cell in csheets.ext.comments.ui

Methods in csheets.ext.comments.ui with parameters of type Cell

Modifier and Type	Method and Description
void	CommentedCellDecorator.decorate(JComponent component, Graphics g, Cell cell, boolean selected, boolean hasFocus) Decorates the given graphics context if the cell being rendered has a comment.

Uses of Cell in csheets.ext.database.controller

Methods in csheets.ext.database.controller with parameters of type Cell

Modifier and Type	Method and Description
String[][]	ControllerUpdate.cellsTo2dArray(Cell[][] cells) converts selected spreadsheet content in a 2D String array
void	ControllerExport.setDataToExport(Cell[][] cells, String user, String pass, String tableName) sets data to be exported
void	ControllerSync.startSync(String user, String pass, Cell[][] cells, String tableName, String url, Observer observer) Start the sync between application and database
void	ControllerUpdate.updateTable(String tableName, String[][] tableData, String[][] selectedCells, Cell[][] cells) updates a database table based on the selected cells
void	ControllerUpdate.updateTableWithDeletion(String tableName, String[][] tableData, String[][] selectedCells, Cell[][] cells) updates a spreadsheets table by deleting unselected cells and editing modified cells

Uses of Cell in csheets.ext.database.core

Methods in csheets.ext.database.core with parameters of type Cell

Modifier and Type	Method and Description
String[][]	DatabaseFacade.cellsTo2dArray(Cell[][] cells) converts selected spreadsheet content in a 2D String array
void	HsqlDBConnection.createTable(String tableName, Cell[][] cells)
void	DerbyConnection.createTable(String tableName, Cell[][] cells)
void	DBConnectionStrategy.createTable(String tableName, Cell[][] cells) creates a new table in the database
void	DatabaseFacade.exportData(Cell[][] cells, String tableName) exports data to a database
void	DatabaseFacade.startSync(String user, String pass, Cell[][] cells, String tableName, String url, Observer observer) Starts a new sync with database
void	DatabaseFacade.updateTable(String tableName, String[][] tableData, String[][] selectedCells, Cell[][] cells) updates a database table based on the selected cells
void	DatabaseFacade.updateTableWithDeletion(String tableName, String[][] tableData, String[][] selectedCells, Cell[][] cells) updates a database table by deleting unselected rows and editing modified rows

Constructors in csheets.ext.database.core with parameters of type Cell

Constructor and Description
ThreadExport(Cell[][] cells, String url, String user, String pass, String tableName)
ThreadExport(Cell[][] cells, String url, String user, String pass, String tableName, String dbName, ControllerExport ctrlExp)
ThreadImport(Cell cell, String url, String user, String pass, String tableName, String dbName, ControllerImport ctrlImp) construtor
ThreadSync(Cell[][] cells, String url, String user, String pass, String table, String dbName, Observer observer) Creates a new thread for sync function
ThreadUpdate(String url, String user, String pass, String dbName, ControllerUpdate ctrlUp, Cell[][] cells) construtor

Uses of Cell in csheets.ext.database.ui

Constructors in csheets.ext.database.ui with parameters of type Cell

Constructor and Description
UIExport(Cell[][] cells) Export GUI constructor
UISync(Cell[][] cells) Creates a new sync ui
UITableSelectUpdate(Cell[][] cells, String dbName, ControllerUpdate ctrlUp) constructor of the GUI for table selection
UIUpdate(Cell[][] cells) Update GUI constructor

Uses of Cell in csheets.ext.deptree

Methods in csheets.ext.deptree that return Cell

Modifier and Type	Method and Description
Cell	CellNode.getCell() Returns the cell of the node.

Constructors in csheets.ext.deptree with parameters of type Cell

Constructor and Description
CellNode(Cell cell, DefaultTreeModel treeModel) Creates a new cell node.
DependentsNode(Cell cell, DefaultTreeModel treeModel) Creates a new dependents node.
PrecedentsNode(Cell cell, DefaultTreeModel treeModel, UIController uiController) Creates a new precedents node.

Uses of Cell in csheets.ext.share.controller

Methods in csheets.ext.share.controller with parameters of type Cell

Modifier and Type	Method and Description
void	ReceiveController.startClient(Connections connection, Cell cellStart, Observer observer, String password) Method that will create a new client and will start the connection
void	ReceiveController.startClient(String IP, int port, Cell cellStart, String password, Observer observer) Method that will create a new client and will start the connection
void	SendController.startServer(int port, Cell[][] cells, String password, String properties, Observer observer) Method that will create a new server and will start the connection

Uses of Cell in csheets.ext.share.core

Methods in csheets.ext.share.core that return Cell

Modifier and Type	Method and Description
Cell	CellNetworkListenerServer.getCell() method to return the cell changed
Cell	CellNetworkListenerClient.getCell() method to return the cell changed
Cell[][]	Server.getCells() Return the cells to be share

Methods in csheets.ext.share.core with parameters of type Cell

Modifier and Type	Method and Description
void	CellNetworkListenerServer.cellCleared(Cell cell) not implemented
void	CellNetworkListenerClient.cellCleared(Cell cell) not implemented
void	CellNetworkListenerServer.cellCopied(Cell cell, Cell source) not implemented
void	CellNetworkListenerClient.cellCopied(Cell cell, Cell source) not implemented
void	CellNetworkListenerServer.contentChanged(Cell cell) when a cell is changed this method change the flag and in other method of program will detect this process and start to treat that
void	CellNetworkListenerClient.contentChanged(Cell cell)
void	CellNetworkListenerServer.dependentsChanged(Cell cell) not implemented
void	CellNetworkListenerClient.dependentsChanged(Cell cell) not implemented
void	CellNetworkListenerServer.setCell(Cell cell) method to set the cell
void	CellNetworkListenerClient.setCell(Cell cell) method to set the cell
void	Client.startClient(Connections connection, Cell cellStart, Observer observer, String password) Method that will start the client and receive cells throw network
void	Client.startClient(String IP, int port, Cell cellStart, String password, Observer observer) Method that will start the client and receive cells throw network
void	Server.startServer(int port, Cell[][] cells, String password, String properties, Observer observer) Method that will start the server and share the cells throw network
void	CellNetworkListenerServer.valueChanged(Cell cell) not implemented
void	CellNetworkListenerClient.valueChanged(Cell cell) not implemented

Constructors in csheets.ext.share.core with parameters of type Cell

Constructor and Description
ThreadClient(Cell cellStart, Socket sock, CellNetworkListenerClient listener, Observer observer) ThreadClient's builder
ThreadServer(Cell[][] cells, Socket sock, String password, Observer observer) Create internaly a new client

Uses of Cell in csheets.ext.share.ui

Methods in csheets.ext.share.ui with parameters of type Cell

Modifier and Type	Method and Description
void	ReceiveUI.createUI(Cell cellStart) Create a user interface for the receive action
void	SendUI.createUI(Cell[][] cells) Create the UI for the send action

Uses of Cell in csheets.ext.style

Classes in csheets.ext.style that implement Cell

Modifier and Type	Class and Description
class	StylableCell An extension of a cell in a spreadsheet, with support for style, i.e. font, format, alignment, color and border.

Methods in csheets.ext.style with parameters of type Cell

Modifier and Type	Method and Description
void	StylableCell.cellCleared(Cell cell) Removes the style from the cell.
void	StylableCell.cellCopied(Cell cell, Cell source) Copies the style from the source cell to this one.
StylableCell	StyleExtension.extend(Cell cell) Makes the given cell stylable.

Constructors in csheets.ext.style with parameters of type Cell

Constructor and Description
StylableCell(Cell cell) Creates a stylable cell extension for the given cell.

Uses of Cell in csheets.ext.test

Classes in csheets.ext.test that implement Cell

Modifier and Type	Class and Description
class	TestableCell An extension of a cell in a spreadsheet, with support for test cases.

Methods in csheets.ext.test with parameters of type Cell

Modifier and Type	Method and Description
void	TestableCell.cellCleared(Cell cell) Removes the test case parameters from the cell.
void	TestableCell.cellCopied(Cell cell, Cell source) Copies the user-specified test case parameters from the source cell to this one.
void	TestableCell.contentChanged(Cell cell) Invoked to indicate that the content of the cell in the spreadsheet was modified and that test cases and test case paremeters that depend on that data must be updated, and new ones generated.
TestableCell	TestExtension.extend(Cell cell) Makes the given cell testable.

Constructors in csheets.ext.test with parameters of type Cell

Constructor and Description
TestableCell(Cell cell) Creates a testable cell extension for the given cell.

Uses of Cell in csheets.ext.test.ui

Methods in csheets.ext.test.ui with parameters of type Cell

Modifier and Type	Method and Description
void	TestableCellDecorator.decorate(JComponent component, Graphics g, Cell cell, boolean selected, boolean hasFocus) Decorates the given graphics context if the cell being rendered has a test error.

Uses of Cell in csheets.ui.ctrl

Methods in csheets.ui.ctrl that return Cell

Modifier and Type	Method and Description
Cell	UIController.getActiveCell() Returns the active cell of the active workbook's active spreadsheet.
Cell	SelectionEvent.getCell() Returns the active cell.
Cell	SelectionEvent.getPreviousCell() Returns the previous active cell.

Methods in csheets.ui.ctrl with parameters of type Cell

Modifier and Type	Method and Description
void	UIController.setActiveCell(Cell cell) Sets the active cell of the application, and thereby also the active spreadsheet and workbook.

Constructors in csheets.ui.ctrl with parameters of type Cell

Constructor and Description
SelectionEvent(Object source, Workbook workbook, Spreadsheet spreadsheet, Cell cell, Workbook prevWorkbook, Spreadsheet prevSpreadsheet, Cell prevCell) Creates a new selection event.

Uses of Cell in csheets.ui.ext

Methods in csheets.ui.ext with parameters of type Cell

Modifier and Type	Method and Description
abstract void	CellDecorator.decorate(JComponent component, Graphics g, Cell cell, boolean selected, boolean hasFocus) Decorates the given graphics context, by drawing visualizations of extension-specific data on it.

Uses of Cell in csheets.ui.sheet

Methods in csheets.ui.sheet that return Cell

Modifier and Type	Method and Description
Cell	CellEditor.getCellEditorValue() Returns the cell that is (or was) being edited.
Cell	SpreadsheetTable.getSelectedCell() Returns the active cell of the spreadsheet table.
Cell[][]	SpreadsheetTable.getSelectedCells() Returns the currently selected cells in the spreadsheet table.

Constructors in csheets.ui.sheet with parameters of type Cell

Constructor and Description
CellTransferable(Cell[][] cells) Creates a new cell transferable.