Package 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	Description
CellDataImpl(RangeImpl range)

Method Summary

Modifier and Type	Method	Description
Boolean	getBooleanValue()
int	getColumn()
Date	getDateValue()
Double	getDoubleValue()
String	getEditText()	For example, a cell displays $123,456.00, but its edit text is 123456.
String	getFormatText()	The text result after applying the number format, e.g.
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:

0-based row index

getColumn

public int getColumn()

Specified by:

getColumn in interface CellData

Returns:

0-based 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 cell value, it could be String, Number, or Boolean

getFormatText

public String getFormatText()

Description copied from interface: CellData

The text result after applying the number format, e.g. a cell has 123456, CellData.getFormatText() returns $123,456.00

Specified by:

getFormatText in interface CellData

Returns:

the formatted text

getEditText

public String getEditText()

Description copied from interface: CellData

For example, a cell displays $123,456.00, but its edit text is 123456.

Specified by:

getEditText in interface CellData

Returns:

the edit text before applying the format

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 value of this cell or null if the cell is blank

getDateValue

public Date getDateValue()

Specified by:

getDateValue in interface CellData

Returns:

the date data object of this cell or null if the cell is blank

getStringValue

public String getStringValue()

Specified by:

getStringValue in interface CellData

Returns:

the string value of this cell or null if the cell is blank

getFormulaValue

public String getFormulaValue()

Specified by:

getFormulaValue in interface CellData

Returns:

the formula string of this cell without leading "=" e.g. SUM(D1:D3)

getBooleanValue

public Boolean getBooleanValue()

Specified by:

getBooleanValue in interface CellData

Returns:

this cell's boolean value or null if the cell is blank

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.