io.keikai.api.model.impl

Class CellDataImpl

java.lang.Object

io.keikai.api.model.impl.CellDataImpl

All Implemented Interfaces:

CellData, Serializable

public class CellDataImpl
extends Object
implements CellData, Serializable

Since:

3.0.0

Author:

dennis

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface io.keikai.api.model.CellData

CellData.CellType

Constructor Summary

Constructors

Constructor and Description
CellDataImpl(RangeImpl range)

Method Summary

Modifier and Type	Method and Description
Boolean	getBooleanValue()
int	getColumn()
Date	getDateValue()
Double	getDoubleValue()
String	getEditText()
String	getFormatText()
String	getFormulaValue()
CellData.CellType	getResultType() Gets the cell result type.
String	getRichText()
int	getRow()
String	getStringValue()
CellData.CellType	getType() Gets the cell type. If the cell is a formula then you are possible getting the CellData.CellType.FORMULA or CellData.CellType.ERROR. You could use CellData.getResultType() to get result type for a cell or a formula-cell.
Object	getValue()
boolean	isBlank()
boolean	isFormula()
void	setEditText(String editText) Sets the edit text, for example, "123" is number, "2012/1/1" is date, "=SUM(A1:B1)" is formula
void	setRichText(String htmlString) Sets the rich text in html format.
void	setValue(Object value) Sets the data object, it should be a String, Number, Date or Boolean
boolean	validateEditText(String editText) Validates the edit text if this cell has validation constraint

Methods inherited from class java.lang.Object

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

Constructor Detail

CellDataImpl

public CellDataImpl(RangeImpl range)

Method Detail

getRow

public int getRow()

Specified by:

getRow in interface CellData

Returns:

the row index

getColumn

public int getColumn()

Specified by:

getColumn in interface CellData

Returns:

column index

getResultType

public CellData.CellType getResultType()

Description copied from interface: CellData

Gets the cell result type.

Specified by:

getResultType in interface CellData

Returns:

cell result type

getType

public CellData.CellType getType()

Description copied from interface: CellData

Gets the cell type.
If the cell is a formula then you are possible getting the CellData.CellType.FORMULA or CellData.CellType.ERROR.
You could use CellData.getResultType() to get result type for a cell or a formula-cell.

Specified by:

getType in interface CellData

Returns:

cell type

getValue

public Object getValue()

Specified by:

getValue in interface CellData

Returns:

the data object, it is String, Number, Boolean

getFormatText

public String getFormatText()

Specified by:

getFormatText in interface CellData

Returns:

the formatted text string

getEditText

public String getEditText()

Specified by:

getEditText in interface CellData

Returns:

the edit text

setValue

public void setValue(Object value)

Description copied from interface: CellData

Sets the data object, it should be a String, Number, Date or Boolean

Specified by:

setValue in interface CellData

Parameters:

value - the data object

setEditText

public void setEditText(String editText)

Description copied from interface: CellData

Sets the edit text, for example, "123" is number, "2012/1/1" is date, "=SUM(A1:B1)" is formula

Specified by:

setEditText in interface CellData

validateEditText

public boolean validateEditText(String editText)

Description copied from interface: CellData

Validates the edit text if this cell has validation constraint

Specified by:

validateEditText in interface CellData

Parameters:

editText - the edit text

Returns:

false if the editText can't pass the validation

isBlank

public boolean isBlank()

Specified by:

isBlank in interface CellData

Returns:

true if it is a blank cell

isFormula

public boolean isFormula()

Specified by:

isFormula in interface CellData

Returns:

true if it is a formula cell

getDoubleValue

public Double getDoubleValue()

Specified by:

getDoubleValue in interface CellData

Returns:

the double data object of this cell

getDateValue

public Date getDateValue()

Specified by:

getDateValue in interface CellData

Returns:

the date data object of this cell

getStringValue

public String getStringValue()

Specified by:

getStringValue in interface CellData

Returns:

the string object of this cell

getFormulaValue

public String getFormulaValue()

Specified by:

getFormulaValue in interface CellData

Returns:

the string object that represent the formula of this cell

getBooleanValue

public Boolean getBooleanValue()

Specified by:

getBooleanValue in interface CellData

Returns:

the boolean object of this cell

setRichText

public void setRichText(String htmlString)

Description copied from interface: CellData

Sets the rich text in html format.

Specified by:

setRichText in interface CellData

getRichText

public String getRichText()

Specified by:

getRichText in interface CellData

Returns:

rich text in html format; null if not a rich text.