Package adams.data.spreadsheet

Class CellView

java.lang.Object

adams.data.spreadsheet.CellView

All Implemented Interfaces:

Cell, Serializable

public class CellView
extends Object
implements Cell

Wrapper for a cell.

Author:

FracPete (fracpete at waikato dot ac dot nz)

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface adams.data.spreadsheet.Cell

Cell.ContentType

Field Summary

Fields

Modifier and Type	Field	Description
protected Cell	m_Cell	the wrapped cell.
protected Row	m_Owner	the owner.

Fields inherited from interface adams.data.spreadsheet.Cell

FORMULA_ERROR, PREFIX_FORMULA

Constructor Summary

Constructors

Constructor	Description
CellView(Row owner, Cell cell)	Initializes the wrapper.

Method Summary

Modifier and Type	Method	Description
void	assign(Cell cell)	Obtains the content/type of the other cell, but not the owner.
void	calculate()	Recalculates the value from the cell's formula.
Cell	getCell()	Returns the underlying cell.
String	getContent()	Returns the content of the cell.
Cell.ContentType	getContentType()	Returns the content type.
String	getFormula()	Returns the formula.
Object	getNative()	Returns the cell as native object, according to its type.
Object	getObject()	Returns the object.
boolean	getOnlyStoreFormulas()	Returns whether to only store formulas and not evaluate them.
Row	getOwner()	Returns the row this cell belongs to.
SpreadSheet	getSpreadSheet()	Returns the spreadsheet this cell belongs to.
int	index()	Returns the column this cell is in.
boolean	isAnyDateType()	Checks whether the cell represents a date, time or date/time value.
boolean	isBoolean()	Checks whether the cell represents a boolean value.
boolean	isDate()	Checks whether the cell represents a date value.
boolean	isDateTime()	Checks whether the cell represents a date/time value.
boolean	isDateTimeMsec()	Checks whether the cell represents a date/time with msec value.
boolean	isDouble()	Returns whether the content represents a double number.
boolean	isEmpty()	Checks whether the cell is either missing or has no content.
boolean	isFormula()	Returns whether the content represents a formula.
boolean	isLong()	Returns whether the content represents a long number.
boolean	isMissing()	Checks whether the cell contains a missing value.
boolean	isNumeric()	Checks whether the stored string is numeric.
boolean	isObject()	Returns whether the content represents an object.
boolean	isQuiet()	Returns whether logging output is suppressed, e.g., from parse errors.
boolean	isTime()	Checks whether the cell represents a time value.
boolean	isTimeMsec()	Checks whether the cell represents a time/msec value.
Cell	parseContent(String value)	Attempts to determine the data type of the string.
Object	parseContent(String value, Cell.ContentType type)	Parses the content of the cell using the specified type.
Cell	setContent(DateTime value)	Sets the content of the cell.
Cell	setContent(DateTimeMsec value)	Sets the content of the cell.
Cell	setContent(Time value)	Sets the content of the cell.
Cell	setContent(TimeMsec value)	Sets the content of the cell.
Cell	setContent(Boolean value)	Sets the content of the cell.
Cell	setContent(Byte value)	Sets the content of the cell.
Cell	setContent(Double value)	Sets the content of the cell.
Cell	setContent(Float value)	Sets the content of the cell.
Cell	setContent(Integer value)	Sets the content of the cell.
Cell	setContent(Long value)	Sets the content of the cell.
Cell	setContent(Short value)	Sets the content of the cell.
Cell	setContent(String value)	Sets the content of the cell.
Cell	setContent(Date value)	Sets the content of the cell.
Cell	setContentAs(String value, Cell.ContentType type)	Sets the content of the cell, trying to parse the content using the specified content type.
Cell	setContentAsString(String value)	Sets the string content of the cell.
Cell	setFormula(String value)	Sets the formula content of the cell.
void	setMissing()	Sets the cell to missing.
Cell	setNative(Object value)	Determines the best set-method based on the class of the provided object.
Cell	setObject(Object value)	Sets the object content of the cell.
void	setOwner(Row owner)	Sets the row this cell belongs to.
Date	toAnyDateType()	Returns the date content, null if not a date, time or date/time.
Boolean	toBoolean()	Returns the boolean content, null if not a boolean.
Date	toDate()	Returns the date content, null if not a date.
DateTime	toDateTime()	Checks whether the cell represents a date/time with msec value.
DateTimeMsec	toDateTimeMsec()	Returns the date/time msec content, null if not a date/time.
Double	toDouble()	Returns the content as double, if possible.
Long	toLong()	Returns the content as long, if possible.
String	toString()	Returns the content of the cell.
Time	toTime()	Returns the time content, null if not a time.
TimeMsec	toTimeMsec()	Returns the time/msec content, null if not a time/msec.

Methods inherited from class java.lang.Object

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

Field Detail

m_Owner

protected Row m_Owner

the owner.

m_Cell

protected Cell m_Cell

the wrapped cell.

Constructor Detail

CellView

public CellView(Row owner,
                Cell cell)

Initializes the wrapper.

Parameters:

owner - the owning row

cell - the cell to wrap

Method Detail

setOwner

public void setOwner(Row owner)

Sets the row this cell belongs to.

Specified by:

setOwner in interface Cell

Parameters:

owner - the owner

getOwner

public Row getOwner()

Returns the row this cell belongs to.

Specified by:

getOwner in interface Cell

Returns:

the owner

getSpreadSheet

public SpreadSheet getSpreadSheet()

Returns the spreadsheet this cell belongs to.

Specified by:

getSpreadSheet in interface Cell

Returns:

the spreadsheet

assign

public void assign(Cell cell)

Obtains the content/type of the other cell, but not the owner.
Not implemented!

Specified by:

assign in interface Cell

Parameters:

cell - the cell to get the content/type from

setMissing

public void setMissing()

Sets the cell to missing.
Not implemented!

Specified by:

setMissing in interface Cell

setContent

public Cell setContent(Boolean value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Byte value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Short value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Integer value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Long value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Float value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null or NaN is intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Double value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null or NaN is intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Date value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null is intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(DateTime value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null is intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(DateTimeMsec value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null is intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(Time value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null is intepreted as missing value

Returns:

the cell itself

setContent

public Cell setContent(TimeMsec value)

Sets the content of the cell.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content; null is intepreted as missing value

Returns:

the cell itself

parseContent

public Cell parseContent(String value)

Attempts to determine the data type of the string.
Not implemented!

Specified by:

parseContent in interface Cell

Parameters:

value - the non-empty string to parse

Returns:

the cell itself

setContent

public Cell setContent(String value)

Sets the content of the cell. Tries to determine whether the cell content is numeric or not.
Not implemented!

Specified by:

setContent in interface Cell

Parameters:

value - the content

Returns:

the cell itself

parseContent

public Object parseContent(String value,
                           Cell.ContentType type)

Parses the content of the cell using the specified type. If the string cannot be parsed according to the type, missing is used instead.
Not implemented!

Specified by:

parseContent in interface Cell

Parameters:

value - the content

type - the expected type

Returns:

the parsed content

setContentAsString

public Cell setContentAsString(String value)

Sets the string content of the cell.
Not implemented!

Specified by:

setContentAsString in interface Cell

Parameters:

value - the content

Returns:

the cell itself

setContentAs

public Cell setContentAs(String value,
                         Cell.ContentType type)

Sets the content of the cell, trying to parse the content using the specified content type.
Not implemented!

Specified by:

setContentAs in interface Cell

Parameters:

value - the content

type - the type to use

Returns:

the cell itself

setObject

public Cell setObject(Object value)

Sets the object content of the cell.
Not implemented!

Specified by:

setObject in interface Cell

Parameters:

value - the content

Returns:

the cell itself

setFormula

public Cell setFormula(String value)

Sets the formula content of the cell.
Not implemented!

Specified by:

setFormula in interface Cell

Parameters:

value - the content

Returns:

the cell itself

getFormula

public String getFormula()

Returns the formula.

Specified by:

getFormula in interface Cell

Returns:

the formula, null if none used

getObject

public Object getObject()

Returns the object.

Specified by:

getObject in interface Cell

Returns:

the object, null if none set

getContent

public String getContent()

Returns the content of the cell.

Specified by:

getContent in interface Cell

Returns:

the content

getContentType

public Cell.ContentType getContentType()

Returns the content type.

Specified by:

getContentType in interface Cell

Returns:

the type

setNative

public Cell setNative(Object value)

Determines the best set-method based on the class of the provided object. Fallback is the setObject(Object) method.
Not implemented!

Specified by:

setNative in interface Cell

Parameters:

value - the value to set

Returns:

the cell itself

getNative

public Object getNative()

Returns the cell as native object, according to its type. If a cell is missing, the result is the SpreadSheet.MISSING_VALUE string.

Specified by:

getNative in interface Cell

Returns:

the corresponding object

index

public int index()

Returns the column this cell is in.

Specified by:

index in interface Cell

Returns:

the column index, -1 if not available

isEmpty

public boolean isEmpty()

Checks whether the cell is either missing or has no content.

Specified by:

isEmpty in interface Cell

Returns:

true if empty

isNumeric

public boolean isNumeric()

Checks whether the stored string is numeric.

Specified by:

isNumeric in interface Cell

Returns:

true if the content is numeric

isMissing

public boolean isMissing()

Checks whether the cell contains a missing value.

Specified by:

isMissing in interface Cell

Returns:

true if missing value

isBoolean

public boolean isBoolean()

Checks whether the cell represents a boolean value.

Specified by:

isBoolean in interface Cell

Returns:

true if boolean value

toBoolean

public Boolean toBoolean()

Returns the boolean content, null if not a boolean.

Specified by:

toBoolean in interface Cell

Returns:

the date, null if not boolean

isAnyDateType

public boolean isAnyDateType()

Checks whether the cell represents a date, time or date/time value.

Specified by:

isAnyDateType in interface Cell

Returns:

true if date, time or date/time value

toAnyDateType

public Date toAnyDateType()

Returns the date content, null if not a date, time or date/time.

Specified by:

toAnyDateType in interface Cell

Returns:

the date, null if not date, time or date/time

isDate

public boolean isDate()

Checks whether the cell represents a date value.

Specified by:

isDate in interface Cell

Returns:

true if date value

toDate

public Date toDate()

Returns the date content, null if not a date.

Specified by:

toDate in interface Cell

Returns:

the date, null if not date

isDateTime

public boolean isDateTime()

Checks whether the cell represents a date/time value.

Specified by:

isDateTime in interface Cell

Returns:

true if date/time value

toDateTime

public DateTime toDateTime()

Checks whether the cell represents a date/time with msec value.

Specified by:

toDateTime in interface Cell

Returns:

true if date/time msec value

isDateTimeMsec

public boolean isDateTimeMsec()

Checks whether the cell represents a date/time with msec value.

Specified by:

isDateTimeMsec in interface Cell

Returns:

true if date/time msec value

toDateTimeMsec

public DateTimeMsec toDateTimeMsec()

Returns the date/time msec content, null if not a date/time.

Specified by:

toDateTimeMsec in interface Cell

Returns:

the date/time msec, null if not date/time

isTime

public boolean isTime()

Checks whether the cell represents a time value.

Specified by:

isTime in interface Cell

Returns:

true if time value

toTime

public Time toTime()

Returns the time content, null if not a time.

Specified by:

toTime in interface Cell

Returns:

the time, null if not time

isTimeMsec

public boolean isTimeMsec()

Checks whether the cell represents a time/msec value.

Specified by:

isTimeMsec in interface Cell

Returns:

true if time/msec value

toTimeMsec

public TimeMsec toTimeMsec()

Returns the time/msec content, null if not a time/msec.

Specified by:

toTimeMsec in interface Cell

Returns:

the time/msec, null if not time/msec

isDouble

public boolean isDouble()

Returns whether the content represents a double number.

Specified by:

isDouble in interface Cell

Returns:

true if a double

toDouble

public Double toDouble()

Returns the content as double, if possible.

Specified by:

toDouble in interface Cell

Returns:

the content as double, if representing a number, otherwise null

isLong

public boolean isLong()

Returns whether the content represents a long number.

Specified by:

isLong in interface Cell

Returns:

true if a long

toLong

public Long toLong()

Returns the content as long, if possible. First, a Double object is created and then the longValue() method called to return the value.

Specified by:

toLong in interface Cell

Returns:

the content as long, if representing a number, otherwise null

isFormula

public boolean isFormula()

Returns whether the content represents a formula.

Specified by:

isFormula in interface Cell

Returns:

true if a formula

isObject

public boolean isObject()

Returns whether the content represents an object.

Specified by:

isObject in interface Cell

Returns:

true if an object

isQuiet

public boolean isQuiet()

Returns whether logging output is suppressed, e.g., from parse errors.

Specified by:

isQuiet in interface Cell

Returns:

true if quiet

getOnlyStoreFormulas

public boolean getOnlyStoreFormulas()

Returns whether to only store formulas and not evaluate them.

Specified by:

getOnlyStoreFormulas in interface Cell

Returns:

true if only stored

calculate

public void calculate()

Recalculates the value from the cell's formula.

Specified by:

calculate in interface Cell

getCell

public Cell getCell()

Returns the underlying cell.

Returns:

the cell

toString

public String toString()

Returns the content of the cell.

Specified by:

toString in interface Cell

Overrides:

toString in class Object

Returns:

the content

See Also:

getContent()