Package quadbase.util

Class SimpleSpreadSheet

java.lang.Object

quadbase.util.SimpleSpreadSheet

All Implemented Interfaces:

ISpreadSheetModel

public class SimpleSpreadSheet
extends Object
implements ISpreadSheetModel

This class provides a simple implementation for the ISpreadSheetModel interface. Data is read from arrays and maintained in memory.

Note : the row and column label array lengths always determine the size of the spreadsheet. The cell values are adjusted accordingly. The cells are initially default to null, and are later assigned as provided in the cell array.

See Also:

• ISpreadSheetModel

Constructor Summary

Constructors

Constructor	Description
SimpleSpreadSheet()	Default constructor
SimpleSpreadSheet(Object[] rowVals, Object[] columnVals, Object[][] vals)	A more Convenient constructor that can support almost any type
SimpleSpreadSheet(String[] rowVals, String[] columnVals, Double[][] vals)	Convenient constructor for strings and double spreadsheet
SimpleSpreadSheet(String[] rowVals, String[] columnVals, Integer[][] vals)	Convenient constructor for strings and integer spreadsheet

Method Summary

Modifier and Type	Method	Description
void	addSpreadSheetModelListener(ISpreadSheetModelListener l)	Adds the given listener to the listener list
protected void	fireSpreadSheetChanged(SpreadSheetModelEvent e)	Notifies all listeners of the given event
int	getColumnCount()	Returns the number of columns (except the row labels)
Object	getColumnLabel(int i)	Get the label for the given column
int	getColumnLabelType()	Returns the data type of the column labels
int	getRowCount()	Returns the number of rows
Object	getRowLabel(int i)	Get the label for the given row
int	getRowLabelType()	Returns the data type of the row labels
Object	getValueAt(int i, int j)	Get the value at a given row and column indexes (beginning at 1)
int	getValueType()	Returns the data type of the values
void	removeSpreadSheetModelListener(ISpreadSheetModelListener l)	Removes the given listener from the listener list
void	setCellValue(int i, int j, Object x)	Assign value to cell.
void	setColumnInfo(int sqlType, Object[] columnVals)	Set the column cell information Please use setColumnInfo(Object[] columnVals, Object[][] vals) if array size is changed
void	setColumnInfo(Object[] columnVals, Object[][] vals)	Set column labels and value cells
void	setRowInfo(int sqlType, Object[] rowVals)	Set the row cell information.
void	setRowInfo(Object[] rowVals, Object[][] vals)	Set row labels and value cells
void	setValueInfo(int sqlType, Object[][] vals)	Set the value cell information
void	setValueInfo(Object[] rowVals, Object[] columnVals, Object[][] vals)	Reset the whole spread sheet

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SimpleSpreadSheet

public SimpleSpreadSheet()

Default constructor

SimpleSpreadSheet

public SimpleSpreadSheet(String[] rowVals,
 String[] columnVals,
 Double[][] vals)

Convenient constructor for strings and double spreadsheet

SimpleSpreadSheet

public SimpleSpreadSheet(String[] rowVals,
 String[] columnVals,
 Integer[][] vals)

Convenient constructor for strings and integer spreadsheet

SimpleSpreadSheet

public SimpleSpreadSheet(Object[] rowVals,
 Object[] columnVals,
 Object[][] vals)
                  throws IllegalArgumentException

A more Convenient constructor that can support almost any type

Throws:

IllegalArgumentException

Method Details

setRowInfo

public void setRowInfo(int sqlType,
 Object[] rowVals)

Set the row cell information. Please use setRowInfo(Object[] rowVals, Object[][] vals) if array size is changed

setRowInfo

public void setRowInfo(Object[] rowVals,
 Object[][] vals)
                throws IllegalArgumentException

Set row labels and value cells

Throws:

IllegalArgumentException

setColumnInfo

public void setColumnInfo(int sqlType,
 Object[] columnVals)

Set the column cell information Please use setColumnInfo(Object[] columnVals, Object[][] vals) if array size is changed

setColumnInfo

public void setColumnInfo(Object[] columnVals,
 Object[][] vals)
                   throws IllegalArgumentException

Set column labels and value cells

Throws:

IllegalArgumentException

setValueInfo

public void setValueInfo(int sqlType,
 Object[][] vals)

Set the value cell information

setValueInfo

public void setValueInfo(Object[] rowVals,
 Object[] columnVals,
 Object[][] vals)
                  throws IllegalArgumentException

Reset the whole spread sheet

Throws:

IllegalArgumentException

setCellValue

public void setCellValue(int i,
 int j,
 Object x)

Assign value to cell.

getColumnCount

public int getColumnCount()

Description copied from interface: ISpreadSheetModel

Returns the number of columns (except the row labels)

Specified by:

getColumnCount in interface ISpreadSheetModel

getRowCount

public int getRowCount()

Description copied from interface: ISpreadSheetModel

Returns the number of rows

Specified by:

getRowCount in interface ISpreadSheetModel

getColumnLabelType

public int getColumnLabelType()

Description copied from interface: ISpreadSheetModel

Returns the data type of the column labels

Specified by:

getColumnLabelType in interface ISpreadSheetModel

getRowLabelType

public int getRowLabelType()

Description copied from interface: ISpreadSheetModel

Returns the data type of the row labels

Specified by:

getRowLabelType in interface ISpreadSheetModel

getValueType

public int getValueType()

Description copied from interface: ISpreadSheetModel

Returns the data type of the values

Specified by:

getValueType in interface ISpreadSheetModel

getRowLabel

public Object getRowLabel(int i)

Get the label for the given row

Specified by:

getRowLabel in interface ISpreadSheetModel

Parameters:

i - the row index (beginning at 1)

getColumnLabel

public Object getColumnLabel(int i)

Get the label for the given column

Specified by:

getColumnLabel in interface ISpreadSheetModel

getValueAt

public Object getValueAt(int i,
 int j)

Get the value at a given row and column indexes (beginning at 1)

Specified by:

getValueAt in interface ISpreadSheetModel

Parameters:

i - the row index (beginning at 1)

addSpreadSheetModelListener

public void addSpreadSheetModelListener(ISpreadSheetModelListener l)

Adds the given listener to the listener list

Specified by:

addSpreadSheetModelListener in interface ISpreadSheetModel

removeSpreadSheetModelListener

public void removeSpreadSheetModelListener(ISpreadSheetModelListener l)

Removes the given listener from the listener list

Specified by:

removeSpreadSheetModelListener in interface ISpreadSheetModel

fireSpreadSheetChanged

protected void fireSpreadSheetChanged(SpreadSheetModelEvent e)

Notifies all listeners of the given event