Package com.storedobject.office.od.ods

Class Cell

java.lang.Object

com.storedobject.office.od.ods.Cell

All Implemented Interfaces:

org.apache.poi.ss.usermodel.Cell

public class Cell
extends Object
implements org.apache.poi.ss.usermodel.Cell

Method Summary

Modifier and Type	Method	Description
void	dispose()
org.apache.poi.ss.util.CellAddress	getAddress()
org.apache.poi.ss.util.CellRangeAddress	getArrayFormulaRange()
boolean	getBooleanCellValue()
org.apache.poi.ss.usermodel.CellType	getCachedFormulaResultType()
org.apache.poi.ss.usermodel.Comment	getCellComment()
String	getCellFormula()
org.apache.poi.ss.usermodel.CellStyle	getCellStyle()
org.apache.poi.ss.usermodel.CellType	getCellType()
int	getColumnIndex()
Date	getDateCellValue()
byte	getErrorCellValue()
org.apache.poi.ss.usermodel.Hyperlink	getHyperlink()
LocalDateTime	getLocalDateTimeCellValue()
double	getNumericCellValue()
org.apache.poi.ss.usermodel.RichTextString	getRichStringCellValue()
Row	getRow()
int	getRowIndex()
Sheet	getSheet()
String	getStringCellValue()
boolean	isPartOfArrayFormulaGroup()
void	removeCellComment()
void	removeFormula()
void	removeHyperlink()
void	setAsActiveCell()
void	setBlank()
void	setCellComment(org.apache.poi.ss.usermodel.Comment comment)
void	setCellErrorValue(byte b)
void	setCellFormula(String formula)
void	setCellStyle(org.apache.poi.ss.usermodel.CellStyle cellStyle)
void	setCellType(org.apache.poi.ss.usermodel.CellType cellType)	Deprecated.
void	setCellValue(boolean b)
void	setCellValue(double value)
void	setCellValue(String value)
void	setCellValue(LocalDateTime localDateTime)
void	setCellValue(Calendar calendar)
void	setCellValue(Date date)
void	setCellValue(org.apache.poi.ss.usermodel.RichTextString richTextString)
void	setHyperlink(org.apache.poi.ss.usermodel.Hyperlink hyperlink)
String	toString()

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.poi.ss.usermodel.Cell

setCellValue

Method Details

setCellType

@Deprecated
public void setCellType(org.apache.poi.ss.usermodel.CellType cellType)

Deprecated.

Specified by:

setCellType in interface org.apache.poi.ss.usermodel.Cell

setBlank

public void setBlank()

Specified by:

setBlank in interface org.apache.poi.ss.usermodel.Cell

getCellType

public org.apache.poi.ss.usermodel.CellType getCellType()

Specified by:

getCellType in interface org.apache.poi.ss.usermodel.Cell

getCachedFormulaResultType

public org.apache.poi.ss.usermodel.CellType getCachedFormulaResultType()

Specified by:

getCachedFormulaResultType in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(double value)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(Date date)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(LocalDateTime localDateTime)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(Calendar calendar)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(org.apache.poi.ss.usermodel.RichTextString richTextString)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(String value)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellFormula

public void setCellFormula(String formula)
                    throws org.apache.poi.ss.formula.FormulaParseException,
IllegalStateException

Specified by:

setCellFormula in interface org.apache.poi.ss.usermodel.Cell

Throws:

org.apache.poi.ss.formula.FormulaParseException

IllegalStateException

removeFormula

public void removeFormula()
                   throws IllegalStateException

Specified by:

removeFormula in interface org.apache.poi.ss.usermodel.Cell

Throws:

IllegalStateException

getCellFormula

public String getCellFormula()

Specified by:

getCellFormula in interface org.apache.poi.ss.usermodel.Cell

getNumericCellValue

public double getNumericCellValue()

Specified by:

getNumericCellValue in interface org.apache.poi.ss.usermodel.Cell

getDateCellValue

public Date getDateCellValue()

Specified by:

getDateCellValue in interface org.apache.poi.ss.usermodel.Cell

getLocalDateTimeCellValue

public LocalDateTime getLocalDateTimeCellValue()

Specified by:

getLocalDateTimeCellValue in interface org.apache.poi.ss.usermodel.Cell

getRichStringCellValue

public org.apache.poi.ss.usermodel.RichTextString getRichStringCellValue()

Specified by:

getRichStringCellValue in interface org.apache.poi.ss.usermodel.Cell

getStringCellValue

public String getStringCellValue()

Specified by:

getStringCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(boolean b)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellErrorValue

public void setCellErrorValue(byte b)

Specified by:

setCellErrorValue in interface org.apache.poi.ss.usermodel.Cell

getBooleanCellValue

public boolean getBooleanCellValue()

Specified by:

getBooleanCellValue in interface org.apache.poi.ss.usermodel.Cell

getErrorCellValue

public byte getErrorCellValue()

Specified by:

getErrorCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellStyle

public void setCellStyle(org.apache.poi.ss.usermodel.CellStyle cellStyle)

Specified by:

setCellStyle in interface org.apache.poi.ss.usermodel.Cell

getCellStyle

public org.apache.poi.ss.usermodel.CellStyle getCellStyle()

Specified by:

getCellStyle in interface org.apache.poi.ss.usermodel.Cell

setAsActiveCell

public void setAsActiveCell()

Specified by:

setAsActiveCell in interface org.apache.poi.ss.usermodel.Cell

getAddress

public org.apache.poi.ss.util.CellAddress getAddress()

Specified by:

getAddress in interface org.apache.poi.ss.usermodel.Cell

setCellComment

public void setCellComment(org.apache.poi.ss.usermodel.Comment comment)

Specified by:

setCellComment in interface org.apache.poi.ss.usermodel.Cell

getCellComment

public org.apache.poi.ss.usermodel.Comment getCellComment()

Specified by:

getCellComment in interface org.apache.poi.ss.usermodel.Cell

removeCellComment

public void removeCellComment()

Specified by:

removeCellComment in interface org.apache.poi.ss.usermodel.Cell

getHyperlink

public org.apache.poi.ss.usermodel.Hyperlink getHyperlink()

Specified by:

getHyperlink in interface org.apache.poi.ss.usermodel.Cell

setHyperlink

public void setHyperlink(org.apache.poi.ss.usermodel.Hyperlink hyperlink)

Specified by:

setHyperlink in interface org.apache.poi.ss.usermodel.Cell

removeHyperlink

public void removeHyperlink()

Specified by:

removeHyperlink in interface org.apache.poi.ss.usermodel.Cell

getArrayFormulaRange

public org.apache.poi.ss.util.CellRangeAddress getArrayFormulaRange()

Specified by:

getArrayFormulaRange in interface org.apache.poi.ss.usermodel.Cell

isPartOfArrayFormulaGroup

public boolean isPartOfArrayFormulaGroup()

Specified by:

isPartOfArrayFormulaGroup in interface org.apache.poi.ss.usermodel.Cell

getColumnIndex

public int getColumnIndex()

Specified by:

getColumnIndex in interface org.apache.poi.ss.usermodel.Cell

getRowIndex

public int getRowIndex()

Specified by:

getRowIndex in interface org.apache.poi.ss.usermodel.Cell

getSheet

public Sheet getSheet()

Specified by:

getSheet in interface org.apache.poi.ss.usermodel.Cell

getRow

public Row getRow()

Specified by:

getRow in interface org.apache.poi.ss.usermodel.Cell

dispose

public void dispose()

toString

public String toString()

Overrides:

toString in class Object