Package org.spdx.spreadsheetstore.ods
Class OdsCell
java.lang.Object
org.spdx.spreadsheetstore.ods.OdsCell
- All Implemented Interfaces:
org.apache.poi.ss.usermodel.Cell
Adapter for Apache POI
Cell over the SODS Range.
Provides mechanisms to read and write cell data, respecting SODS limitations.-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionorg.apache.poi.ss.util.CellAddressorg.apache.poi.ss.util.CellRangeAddressbooleanorg.apache.poi.ss.usermodel.CellTypeorg.apache.poi.ss.usermodel.Commentorg.apache.poi.ss.usermodel.CellStyleorg.apache.poi.ss.usermodel.CellTypeintbyteorg.apache.poi.ss.usermodel.Hyperlinkdoubleorg.apache.poi.ss.usermodel.RichTextStringorg.apache.poi.ss.usermodel.RowgetRow()intorg.apache.poi.ss.usermodel.SheetgetSheet()booleanvoidvoidvoidvoidvoidsetBlank()voidsetCellComment(org.apache.poi.ss.usermodel.Comment comment) voidsetCellErrorValue(byte value) voidsetCellFormula(String formula) voidsetCellStyle(org.apache.poi.ss.usermodel.CellStyle style) voidsetCellType(org.apache.poi.ss.usermodel.CellType cellType) voidsetCellValue(boolean value) voidsetCellValue(double value) voidsetCellValue(String value) voidsetCellValue(LocalDate value) voidsetCellValue(LocalDateTime value) voidsetCellValue(Calendar value) voidsetCellValue(Date value) voidsetCellValue(org.apache.poi.ss.usermodel.RichTextString value) voidsetHyperlink(org.apache.poi.ss.usermodel.Hyperlink hyperlink)
-
Constructor Details
-
OdsCell
Creates an ODS cell wrapper.- Parameters:
row- Parent ODS row adapter.columnIndex- Zero-based column index.range- Underlying SODS Range representing this cell.
-
-
Method Details
-
setCellValue
- Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellValue
public void setCellValue(double value) - Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellValue
- Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellType
public void setCellType(org.apache.poi.ss.usermodel.CellType cellType) - Specified by:
setCellTypein interfaceorg.apache.poi.ss.usermodel.Cell
-
getStringCellValue
- Specified by:
getStringCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
getNumericCellValue
public double getNumericCellValue()- Specified by:
getNumericCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
getDateCellValue
- Specified by:
getDateCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
getCellType
public org.apache.poi.ss.usermodel.CellType getCellType()- Specified by:
getCellTypein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellStyle
public void setCellStyle(org.apache.poi.ss.usermodel.CellStyle style) - Specified by:
setCellStylein interfaceorg.apache.poi.ss.usermodel.Cell
-
getCellStyle
public org.apache.poi.ss.usermodel.CellStyle getCellStyle()- Specified by:
getCellStylein interfaceorg.apache.poi.ss.usermodel.Cell
-
getColumnIndex
public int getColumnIndex()- Specified by:
getColumnIndexin interfaceorg.apache.poi.ss.usermodel.Cell
-
getRowIndex
public int getRowIndex()- Specified by:
getRowIndexin interfaceorg.apache.poi.ss.usermodel.Cell
-
getSheet
public org.apache.poi.ss.usermodel.Sheet getSheet()- Specified by:
getSheetin interfaceorg.apache.poi.ss.usermodel.Cell
-
getRow
public org.apache.poi.ss.usermodel.Row getRow()- Specified by:
getRowin interfaceorg.apache.poi.ss.usermodel.Cell
-
setBlank
public void setBlank()- Specified by:
setBlankin interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellFormula
- Specified by:
setCellFormulain interfaceorg.apache.poi.ss.usermodel.Cell
-
getCellFormula
- Specified by:
getCellFormulain interfaceorg.apache.poi.ss.usermodel.Cell
-
getBooleanCellValue
public boolean getBooleanCellValue()- Specified by:
getBooleanCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
getErrorCellValue
public byte getErrorCellValue()- Specified by:
getErrorCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellErrorValue
public void setCellErrorValue(byte value) - Specified by:
setCellErrorValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setAsActiveCell
public void setAsActiveCell()- Specified by:
setAsActiveCellin interfaceorg.apache.poi.ss.usermodel.Cell
-
getAddress
public org.apache.poi.ss.util.CellAddress getAddress()- Specified by:
getAddressin interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellValue
- Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellValue
public void setCellValue(org.apache.poi.ss.usermodel.RichTextString value) - Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellValue
public void setCellValue(boolean value) - Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
getRichStringCellValue
public org.apache.poi.ss.usermodel.RichTextString getRichStringCellValue()- Specified by:
getRichStringCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
removeCellComment
public void removeCellComment()- Specified by:
removeCellCommentin interfaceorg.apache.poi.ss.usermodel.Cell
-
getCellComment
public org.apache.poi.ss.usermodel.Comment getCellComment()- Specified by:
getCellCommentin interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellComment
public void setCellComment(org.apache.poi.ss.usermodel.Comment comment) - Specified by:
setCellCommentin interfaceorg.apache.poi.ss.usermodel.Cell
-
getHyperlink
public org.apache.poi.ss.usermodel.Hyperlink getHyperlink()- Specified by:
getHyperlinkin interfaceorg.apache.poi.ss.usermodel.Cell
-
setHyperlink
public void setHyperlink(org.apache.poi.ss.usermodel.Hyperlink hyperlink) - Specified by:
setHyperlinkin interfaceorg.apache.poi.ss.usermodel.Cell
-
getArrayFormulaRange
public org.apache.poi.ss.util.CellRangeAddress getArrayFormulaRange()- Specified by:
getArrayFormulaRangein interfaceorg.apache.poi.ss.usermodel.Cell
-
isPartOfArrayFormulaGroup
public boolean isPartOfArrayFormulaGroup()- Specified by:
isPartOfArrayFormulaGroupin interfaceorg.apache.poi.ss.usermodel.Cell
-
removeHyperlink
public void removeHyperlink()- Specified by:
removeHyperlinkin interfaceorg.apache.poi.ss.usermodel.Cell
-
getLocalDateTimeCellValue
- Specified by:
getLocalDateTimeCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellValue
- Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
setCellValue
- Specified by:
setCellValuein interfaceorg.apache.poi.ss.usermodel.Cell
-
removeFormula
public void removeFormula()- Specified by:
removeFormulain interfaceorg.apache.poi.ss.usermodel.Cell
-
getCachedFormulaResultType
public org.apache.poi.ss.usermodel.CellType getCachedFormulaResultType()- Specified by:
getCachedFormulaResultTypein interfaceorg.apache.poi.ss.usermodel.Cell
-