public class CellImpl extends AbstractCellAdv
SCell.CellType
Constructor and Description |
---|
CellImpl(AbstractRowAdv row,
int index) |
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() |
FormulaExpression |
getFormulaExpression() |
SCell.CellType |
getFormulaResultType() |
java.lang.Object |
getFromulaResultValue() |
SHyperlink |
getHyperlink() |
protected Ref |
getRef() |
java.lang.String |
getReferenceString() |
int |
getRowIndex() |
SSheet |
getSheet() |
SCell.CellType |
getType() |
java.lang.Object |
getValue(boolean evaluatedVal) |
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 |
setCellStyle(SCellStyle cellStyle)
Set the local style
|
void |
setComment(SComment comment) |
void |
setFormulaResultValue(ValueEval value) |
void |
setFormulaValue(java.lang.String formula)
set formula with string without '=', e.g.
|
void |
setFormulaValue(java.lang.String formula,
java.util.Locale locale) |
void |
setHyperlink(SHyperlink hyperlink)
Set or clear a hyperlink
|
void |
setValue(java.lang.Object newVal) |
protected void |
setValue(java.lang.Object newVal,
boolean aString) |
java.lang.String |
toString() |
checkFormulaResultType, checkType, getBooleanValue, getDateValue, getErrorValue, getFormulaValue, getNumberValue, getRichTextValue, getStringValue, getValue, isRichTextValue, setBooleanValue, setDateValue, setErrorValue, setNumberValue, setStringValue, setupComment, setupHyperlink, setupRichTextValue
public CellImpl(AbstractRowAdv row, int index)
public SCell.CellType getType()
public boolean isNull()
SCell
public int getRowIndex()
public int getColumnIndex()
public java.lang.String getReferenceString()
public void checkOrphan()
public SSheet getSheet()
public void destroy()
LinkedModelObject
public SCellStyle getCellStyle()
CellStyleHolder
public SCellStyle getCellStyle(boolean local)
CellStyleHolder
local
- true to get the local style onlypublic void setCellStyle(SCellStyle cellStyle)
CellStyleHolder
cellStyle
- the style to set, null to clean local styleprotected void evalFormula()
public SCell.CellType getFormulaResultType()
public void clearValue()
SCell
public void setFormulaValue(java.lang.String formula)
SCell
public void setFormulaValue(java.lang.String formula, java.util.Locale locale)
setFormulaValue
in class AbstractCellAdv
public void clearFormulaResultCache()
FormulaContent
public boolean isFormulaParsingError()
public java.lang.Object getValue(boolean evaluatedVal)
public void setValue(java.lang.Object newVal)
protected void setValue(java.lang.Object newVal, boolean aString)
setValue
in class AbstractCellAdv
public SHyperlink getHyperlink()
public void setHyperlink(SHyperlink hyperlink)
SCell
hyperlink
- hyperlink to set, or null to clearpublic SComment getComment()
public void setComment(SComment comment)
public void deleteComment()
SCell
protected Ref getRef()
public java.lang.String toString()
toString
in class java.lang.Object
public void setFormulaResultValue(ValueEval value)
setFormulaResultValue
in class AbstractCellAdv
public FormulaExpression getFormulaExpression()
getFormulaExpression
in class AbstractCellAdv
@Internal public java.lang.Object getFromulaResultValue()
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.