Uses of Class
org.apache.poi.ss.usermodel.CellType
-
Packages that use CellType Package Description org.apache.poi.hssf.usermodel usermodel package maps HSSF low level strutures to familiar workbook/sheet modelorg.apache.poi.ss.format This package contains classes that implement cell formattingorg.apache.poi.ss.formula This package contains common internal POI code for manipulating formulas.org.apache.poi.ss.usermodel org.apache.poi.xssf.streaming org.apache.poi.xssf.usermodel -
-
Uses of CellType in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return CellType Modifier and Type Method Description CellType
HSSFCell. getCachedFormulaResultType()
Only valid for formula cellsCellType
HSSFCell. getCachedFormulaResultTypeEnum()
Deprecated.usegetCachedFormulaResultType
Will be deleted when we make the CellType enum transition.CellType
HSSFCell. getCellType()
get the cells type (numeric, formula or string)CellType
HSSFCell. getCellTypeEnum()
Deprecated.Methods in org.apache.poi.hssf.usermodel with parameters of type CellType Modifier and Type Method Description HSSFCell
HSSFRow. createCell(int columnIndex, CellType type)
Use this to create new cells within the row and return it.void
HSSFCell. setCellType(CellType cellType)
Set the cells type (numeric, formula or string).Constructors in org.apache.poi.hssf.usermodel with parameters of type CellType Constructor Description HSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col, CellType type)
Creates new Cell - Should only be called by HSSFRow. -
Uses of CellType in org.apache.poi.ss.format
Methods in org.apache.poi.ss.format that return CellType Modifier and Type Method Description static CellType
CellFormat. ultimateType(Cell cell)
Returns the ultimate cell type, following the results of formulas.static CellType
CellFormat. ultimateTypeEnum(Cell cell)
Deprecated.useultimateType
instead -
Uses of CellType in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return CellType Modifier and Type Method Description CellType
BaseFormulaEvaluator. evaluateFormulaCell(Cell cell)
If cell contains formula, it evaluates the formula, and saves the result of the formula.CellType
BaseFormulaEvaluator. evaluateFormulaCellEnum(Cell cell)
Deprecated.useevaluateFormulaCell(cell)
insteadCellType
EvaluationCell. getCachedFormulaResultType()
CellType
EvaluationCell. getCachedFormulaResultTypeEnum()
Deprecated.POI 3.15 beta 3.CellType
EvaluationCell. getCellType()
CellType
EvaluationCell. getCellTypeEnum()
Deprecated.POI 3.15 beta 3.Methods in org.apache.poi.ss.formula with parameters of type CellType Modifier and Type Method Description static boolean
DataValidationEvaluator. isType(Cell cell, CellType type)
Note that this assumes the cell cached value is up to date and in sync with data editsprotected void
BaseFormulaEvaluator. setCellType(Cell cell, CellType cellType)
Override if a different variation is needed, e.g. -
Uses of CellType in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return CellType Modifier and Type Method Description CellType
FormulaEvaluator. evaluateFormulaCell(Cell cell)
If cell contains formula, it evaluates the formula, and saves the result of the formula.CellType
FormulaEvaluator. evaluateFormulaCellEnum(Cell cell)
Deprecated.useevaluateFormulaCell(cell)
static CellType
CellType. forInt(int code)
Deprecated.POI 3.15 beta 3.CellType
Cell. getCachedFormulaResultType()
Only valid for formula cells Will returnCellType
in a future version of POI.CellType
Cell. getCachedFormulaResultTypeEnum()
Deprecated.CellType
Cell. getCellType()
Return the cell type.CellType
CellValue. getCellType()
Return the cell type.CellType
Cell. getCellTypeEnum()
Deprecated.CellType
CellValue. getCellTypeEnum()
Deprecated.usegetCellType
insteadstatic CellType
CellType. valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name.static CellType[]
CellType. values()
Returns an array containing the constants of this enum type, in the order they are declared.Methods in org.apache.poi.ss.usermodel with parameters of type CellType Modifier and Type Method Description Cell
Row. createCell(int column, CellType type)
Use this to create new cells within the row and return it.void
Cell. setCellType(CellType cellType)
Set the cells type (numeric, formula or string). -
Uses of CellType in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return CellType Modifier and Type Method Description CellType
SXSSFCell. getCachedFormulaResultType()
Only valid for formula cellsCellType
SXSSFCell. getCachedFormulaResultTypeEnum()
Deprecated.usegetCachedFormulaResultType
insteadCellType
SXSSFCell. getCellType()
Return the cell type.CellType
SXSSFCell. getCellTypeEnum()
Deprecated.usegetCellType
insteadMethods in org.apache.poi.xssf.streaming with parameters of type CellType Modifier and Type Method Description SXSSFCell
SXSSFRow. createCell(int column, CellType type)
Use this to create new cells within the row and return it.void
SXSSFCell. setCellType(CellType cellType)
Set the cells type (numeric, formula or string)Constructors in org.apache.poi.xssf.streaming with parameters of type CellType Constructor Description SXSSFCell(SXSSFRow row, CellType cellType)
-
Uses of CellType in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return CellType Modifier and Type Method Description CellType
XSSFCell. getCachedFormulaResultType()
Only valid for formula cellsCellType
XSSFCell. getCachedFormulaResultTypeEnum()
Deprecated.usegetCachedFormulaResultType
instead Will be deleted when we make the CellType enum transition.CellType
XSSFCell. getCellType()
Return the cell type.CellType
XSSFCell. getCellTypeEnum()
Deprecated.usegetCellType
insteadMethods in org.apache.poi.xssf.usermodel with parameters of type CellType Modifier and Type Method Description XSSFCell
XSSFRow. createCell(int columnIndex, CellType type)
Use this to create new cells within the row and return it.protected void
BaseXSSFFormulaEvaluator. setCellType(Cell cell, CellType cellType)
void
XSSFCell. setCellType(CellType cellType)
Set the cells type (numeric, formula or string)protected void
XSSFCell. setCellType(CellType cellType, BaseXSSFEvaluationWorkbook evalWb)
Needed by bug #62834, which points out getCellFormula() expects an evaluation context or creates a new one, so if there is one in use, it needs to be carried on through.
-