public class CellStorage
extends java.lang.Object
| Constructor and Description |
|---|
CellStorage(Worksheet worksheet,
int column,
int row)
Initializes a new instance of the
CellStorage class. |
| Modifier and Type | Method and Description |
|---|---|
void |
evaluate(EvaluationContext context) |
Annotation |
getAnnotation() |
java.lang.Object |
getCalculatedValue() |
CellRef |
getCellRef()
Gets the address of this cell, as a
CellRef object. |
int |
getColumn() |
java.lang.Object |
getData()
Gets the data of this cell.
|
java.util.HashSet<CellRef> |
getDependencies(Workbook workbook) |
java.lang.String |
getErrorMessage()
Gets the error message of the cell evaluation, if the cell evaluated to an error, or an empty string.
|
java.lang.String |
getFormula()
Gets a culture-aware representation of the cell's formula, if any.
|
Hyperlink |
getHyperlink() |
java.util.List<java.lang.String> |
getIdentifiers() |
java.lang.Object |
getInvariantData()
Gets a culture-invariant representation of the cell's data.
|
boolean |
getIsCustom() |
boolean |
getIsDynamic() |
boolean |
getIsStale()
Gets a value indicating whether the value of this cell is out-of-date and needs to be recalculated.
|
boolean |
getIsVolatile() |
java.util.Locale |
getLocale()
Gets the locale used to format the cell value.
|
int |
getRow() |
java.lang.Object |
getTag() |
java.lang.Object |
getValue()
Gets the effective value of this cell.
|
Worksheet |
getWorksheet() |
boolean |
isEditable()
Gets if the cell is editable or not.
|
boolean |
isEmpty() |
boolean |
refactorReferences(java.util.function.Function<CellRef,CellRef> func)
Refactors all cell references in the cell expression using the specified function.
|
void |
refactorSheet(java.lang.String oldName,
java.lang.String newName)
Replaces all references to the sheet with the specified old name
in the cell expression to be the specified new name.
|
void |
removeAnnotation() |
void |
removeHyperlink() |
void |
setAnnotation(Annotation value) |
void |
setAnnotation(java.lang.String value) |
void |
setColumn(int value) |
void |
setData(java.lang.Object value) |
void |
setData(java.lang.Object value,
int dcolumn,
int drow) |
void |
setData(java.lang.Object value,
int dcolumn,
int drow,
boolean dontParse,
boolean isCultureInvariant) |
void |
setEditable(boolean value)
Sets if current cell is editable or not.
|
void |
setHyperlink(Hyperlink value) |
void |
setHyperlink(HyperlinkType type,
java.lang.String target,
java.lang.String subTarget) |
void |
setIsStale(boolean value)
Sets a value indicating whether the value of this cell is out-of-date and needs to be recalculated.
|
void |
setLocale(java.util.Locale value)
Sets the locale used to format the cell value.
|
void |
setRow(int value) |
void |
setTag(java.lang.Object value) |
void |
setValue(java.lang.Object value)
Sets the effective value of this cell.
|
<T> T |
valueAs(java.lang.Class<T> type) |
public CellStorage(Worksheet worksheet, int column, int row)
CellStorage class.public java.util.List<java.lang.String> getIdentifiers()
public void evaluate(EvaluationContext context)
public void refactorSheet(java.lang.String oldName,
java.lang.String newName)
public boolean refactorReferences(java.util.function.Function<CellRef,CellRef> func)
public Worksheet getWorksheet()
public CellRef getCellRef()
public int getColumn()
public void setColumn(int value)
public int getRow()
public void setRow(int value)
public void setEditable(boolean value)
If value is true the content of cell can be edited.
If value is false the input of new content or change
of already existing one is blocked. The formula bar input or change
for this cell is also blocked.
public boolean isEditable()
public java.lang.Object getInvariantData()
public java.lang.Object getData()
If the specified data is a string, starting with an equal sign (=), it is interpreted as a formula. To specify a string, starting with an equal sign, prefix the string with a single apostrophe (').
public void setData(java.lang.Object value)
public boolean isEmpty()
public void setData(java.lang.Object value,
int dcolumn,
int drow)
public void setData(java.lang.Object value,
int dcolumn,
int drow,
boolean dontParse,
boolean isCultureInvariant)
public java.lang.Object getValue()
This property should be set only by the underlying calc engine or during deserialization.
public <T> T valueAs(java.lang.Class<T> type)
public void setValue(java.lang.Object value)
This property should be set only by the underlying calc engine or during deserialization.
public java.lang.Object getCalculatedValue()
public Annotation getAnnotation()
public void setAnnotation(Annotation value)
public Hyperlink getHyperlink()
public void setHyperlink(Hyperlink value)
public void setAnnotation(java.lang.String value)
public void removeAnnotation()
public void setHyperlink(HyperlinkType type, java.lang.String target, java.lang.String subTarget)
public void removeHyperlink()
public java.lang.String getFormula()
public java.util.Locale getLocale()
public void setLocale(java.util.Locale value)
public boolean getIsStale()
public void setIsStale(boolean value)
public boolean getIsVolatile()
public boolean getIsDynamic()
public boolean getIsCustom()
public java.lang.Object getTag()
public void setTag(java.lang.Object value)
public java.lang.String getErrorMessage()