CellImpl (Keikai Spreadsheet Build 5.0.0 API)

java.lang.Object
- io.keikai.model.impl.AbstractCellAdv
- - io.keikai.model.impl.CellImpl

All Implemented Interfaces:

CellStyleHolder, FormulaContent, LinkedModelObject, SCell, Serializable
```
public class CellImpl
extends AbstractCellAdv
```
Since:

3.5.0

Author:

dennis

See Also:

Serialized Form

Nested Class Summary
- Nested classes/interfaces inherited from interface io.keikai.model.SCell
  SCell.CellType

Constructor Summary

Constructors
Constructor and Description

CellImpl(AbstractRowAdv row, int index)

Constructors
Constructor and Description
`CellImpl(AbstractRowAdv row, int index)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`checkOrphan()`
`void`	`clearFormulaResultCache()` Clear the formula result cache if there is evaluation result
`void`	`clearValue()` clear cell value , reset it to blank
`void`	`deleteComment()` Delete the comment associated with this cell.
`void`	`destroy()` Destroy / release this model object, for example all the dependency, parent linking.
`protected void`	`evalFormula()`
`SCellStyle`	`getCellStyle()` Get the style, if it doesn't has local style, it will possible look up it's parent's style
`SCellStyle`	`getCellStyle(boolean local)` Get the cell style locally or look up from the parent
`int`	`getColumnIndex()`
`SComment`	`getComment()`
`CellValue`	`getEvalCellValue(boolean evaluatedVal)`
`FormulaExpression`	`getFormulaExpression()`
`SCell.CellType`	`getFormulaResultType()`
`Object`	`getFromulaResultValue()`
`SHyperlink`	`getHyperlink()`
`protected Ref`	`getRef()`
`String`	`getReferenceString()`
`int`	`getRowIndex()`
`SSheet`	`getSheet()`
`int`	`getTextHeight()`
`int`	`getTextWidth()`
`SCell.CellType`	`getType()`
`Object`	`getValue(boolean evaluatedVal)`
`boolean`	`isCalcAutoHeight()`
`boolean`	`isFormulaParsingError()`
`boolean`	`isNull()` Because you always get a not-null cell object, use this method to judge the cell is really null or not.
`void`	`setCalcAutoHeight(boolean b)`
`void`	`setCellStyle(SCellStyle cellStyle)` Set the local style
`void`	`setComment(SComment comment)`
`void`	`setFormulaResultValue(ValueEval value)`
`void`	`setFormulaValue(String formula)` set formula with string without '=', e.g.
`void`	`setFormulaValue(String formula, Locale locale)`
`void`	`setHyperlink(SHyperlink hyperlink)` Set or clear a hyperlink
`void`	`setTextHeight(int heightPx)`
`void`	`setTextWidth(int widthPx)`
`void`	`setValue(Object newVal)`
`protected void`	`setValue(Object newVal, boolean aString)`
`String`	`toString()`

Methods inherited from class io.keikai.model.impl.AbstractCellAdv
checkFormulaResultType, checkType, getBooleanValue, getDateValue, getErrorValue, getFormulaValue, getNumberValue, getRichTextValue, getStringValue, getValue, isRichTextValue, setBooleanValue, setDateValue, setErrorValue, setNumberValue, setStringValue, setupComment, setupHyperlink, setupRichTextValue

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - CellImpl
```
public CellImpl(AbstractRowAdv row,
                int index)
```
- Method Detail
  - getType
```
public SCell.CellType getType()
```
    Returns:
    
    the cell type
  - isNull
```
public boolean isNull()
```
    Description copied from interface: SCell
    
    Because you always get a not-null cell object, use this method to judge the cell is really null or not.
    
    Returns:
    
    TRUE if this cell is really null which means it have not been created.
  - getRowIndex
```
public int getRowIndex()
```
  - getColumnIndex
```
public int getColumnIndex()
```
  - getReferenceString
```
public String getReferenceString()
```
    Returns:
    
    cell reference like A1
  - checkOrphan
```
public void checkOrphan()
```
  - getSheet
```
public SSheet getSheet()
```
  - destroy
```
public void destroy()
```
    Description copied from interface: LinkedModelObject
    
    Destroy / release this model object, for example all the dependency, parent linking. this method has to be called before remove this linking from parent object
  - getCellStyle
```
public SCellStyle getCellStyle()
```
    Description copied from interface: CellStyleHolder
    
    Get the style, if it doesn't has local style, it will possible look up it's parent's style
    
    See Also:
    
    CellStyleHolder.getCellStyle(boolean)
  - getCellStyle
```
public SCellStyle getCellStyle(boolean local)
```
    Description copied from interface: CellStyleHolder
    
    Get the cell style locally or look up from the parent
    
    Parameters:
    
    local - true to get the local style only
  - setCellStyle
```
public void setCellStyle(SCellStyle cellStyle)
```
    Description copied from interface: CellStyleHolder
    
    Set the local style
    
    Parameters:
    
    cellStyle - the style to set, null to clean local style
  - evalFormula
```
protected void evalFormula()
```
  - getFormulaResultType
```
public SCell.CellType getFormulaResultType()
```
  - clearValue
```
public void clearValue()
```
    Description copied from interface: SCell
    
    clear cell value , reset it to blank
  - setFormulaValue
```
public void setFormulaValue(String formula)
```
    Description copied from interface: SCell
    
    set formula with string without '=', e.g. SUM(A1:B2)
  - setFormulaValue
```
public void setFormulaValue(String formula,
                            Locale locale)
```
    Specified by:
    
    setFormulaValue in class AbstractCellAdv
  - clearFormulaResultCache
```
public void clearFormulaResultCache()
```
    Description copied from interface: FormulaContent
    
    Clear the formula result cache if there is evaluation result
  - isFormulaParsingError
```
public boolean isFormulaParsingError()
```
    Returns:
    
    returns TRUE if it has parsing error, FALSE if no error found or not a formula content
  - getValue
```
public Object getValue(boolean evaluatedVal)
```
  - setValue
```
public void setValue(Object newVal)
```
  - setValue
```
protected void setValue(Object newVal,
                        boolean aString)
```
    Specified by:
    
    setValue in class AbstractCellAdv
  - getHyperlink
```
public SHyperlink getHyperlink()
```
  - setHyperlink
```
public void setHyperlink(SHyperlink hyperlink)
```
    Description copied from interface: SCell
    
    Set or clear a hyperlink
    
    Parameters:
    
    hyperlink - hyperlink to set, or null to clear
  - getComment
```
public SComment getComment()
```
  - setComment
```
public void setComment(SComment comment)
```
  - deleteComment
```
public void deleteComment()
```
    Description copied from interface: SCell
    
    Delete the comment associated with this cell.
  - getRef
```
protected Ref getRef()
```
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class Object
  - setFormulaResultValue
```
public void setFormulaResultValue(ValueEval value)
```
    Specified by:
    
    setFormulaResultValue in class AbstractCellAdv
  - getFormulaExpression
```
public FormulaExpression getFormulaExpression()
```
    Specified by:
    
    getFormulaExpression in class AbstractCellAdv
  - getFromulaResultValue
```
@Internal
public Object getFromulaResultValue()
```
  - setTextHeight
```
@Internal
public void setTextHeight(int heightPx)
```
    Specified by:
    
    setTextHeight in class AbstractCellAdv
  - getTextHeight
```
@Internal
public int getTextHeight()
```
    Specified by:
    
    getTextHeight in class AbstractCellAdv
  - setCalcAutoHeight
```
@Internal
public void setCalcAutoHeight(boolean b)
```
    Specified by:
    
    setCalcAutoHeight in class AbstractCellAdv
  - isCalcAutoHeight
```
@Internal
public boolean isCalcAutoHeight()
```
    Specified by:
    
    isCalcAutoHeight in class AbstractCellAdv
  - setTextWidth
```
@Internal
public void setTextWidth(int widthPx)
```
    Specified by:
    
    setTextWidth in class AbstractCellAdv
  - getTextWidth
```
@Internal
public int getTextWidth()
```
    Specified by:
    
    getTextWidth in class AbstractCellAdv
  - getEvalCellValue
```
public CellValue getEvalCellValue(boolean evaluatedVal)
```
    Specified by:
    
    getEvalCellValue in class AbstractCellAdv

Class CellImpl

Nested Class Summary

Nested classes/interfaces inherited from interface io.keikai.model.SCell

Constructor Summary

Method Summary

Methods inherited from class io.keikai.model.impl.AbstractCellAdv

Methods inherited from class java.lang.Object

Constructor Detail

CellImpl

Method Detail

getType

isNull

getRowIndex

getColumnIndex

getReferenceString

checkOrphan

getSheet

destroy

getCellStyle

getCellStyle

setCellStyle

evalFormula

getFormulaResultType

clearValue

setFormulaValue

setFormulaValue

clearFormulaResultCache

isFormulaParsingError

getValue

setValue

setValue

getHyperlink

setHyperlink

getComment

setComment

deleteComment

getRef

toString

setFormulaResultValue

getFormulaExpression

getFromulaResultValue

setTextHeight

getTextHeight

setCalcAutoHeight

isCalcAutoHeight

setTextWidth

getTextWidth

getEvalCellValue