Uses of Enum Class
org.apache.poi.ss.SpreadsheetVersion
Packages that use SpreadsheetVersion
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains common internal POI code for manipulating formulas.
-
Uses of SpreadsheetVersion in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return SpreadsheetVersionModifier and TypeMethodDescriptionHSSFEvaluationWorkbook.getSpreadsheetVersion()
HSSFWorkbook.getSpreadsheetVersion()
Returns the spreadsheet version (EXCLE97) of this workbook -
Uses of SpreadsheetVersion in org.apache.poi.ss
Methods in org.apache.poi.ss that return SpreadsheetVersionModifier and TypeMethodDescriptionstatic SpreadsheetVersion
Returns the enum constant of this class with the specified name.static SpreadsheetVersion[]
SpreadsheetVersion.values()
Returns an array containing the constants of this enum class, in the order they are declared. -
Uses of SpreadsheetVersion in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return SpreadsheetVersionModifier and TypeMethodDescriptionEvaluationWorkbook.getSpreadsheetVersion()
FormulaParsingWorkbook.getSpreadsheetVersion()
Returns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)Methods in org.apache.poi.ss.formula with parameters of type SpreadsheetVersionModifier and TypeMethodDescriptionstatic FormulaShifter
FormulaShifter.createForColumnCopy
(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShifter
FormulaShifter.createForColumnShift
(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShifter
FormulaShifter.createForRowCopy
(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) static FormulaShifter
FormulaShifter.createForRowShift
(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) Constructors in org.apache.poi.ss.formula with parameters of type SpreadsheetVersion -
Uses of SpreadsheetVersion in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return SpreadsheetVersionModifier and TypeMethodDescriptionWorkbook.getSpreadsheetVersion()
Returns the spreadsheet version of this workbook -
Uses of SpreadsheetVersion in org.apache.poi.ss.util
Methods in org.apache.poi.ss.util with parameters of type SpreadsheetVersionModifier and TypeMethodDescriptionstatic boolean
CellReference.cellReferenceIsWithinRange
(String colStr, String rowStr, SpreadsheetVersion ssVersion) Used to decide whether a name of the form "[A-Z]*[0-9]*" that appears in a formula can be interpreted as a cell reference.static CellReference.NameType
CellReference.classifyCellReference
(String str, SpreadsheetVersion ssVersion) Classifies an identifier as either a simple (2D) cell reference or a named range namestatic AreaReference[]
AreaReference.generateContiguous
(SpreadsheetVersion version, String reference) Takes a non-contiguous area reference, and returns an array of contiguous area referencesstatic AreaReference
AreaReference.getWholeColumn
(SpreadsheetVersion version, String start, String end) static AreaReference
AreaReference.getWholeRow
(SpreadsheetVersion version, String start, String end) static boolean
CellReference.isColumnWithinRange
(String colStr, SpreadsheetVersion ssVersion) static boolean
CellReference.isRowWithinRange
(int rowNum, SpreadsheetVersion ssVersion) Determines whetherrow
is a valid row number for a given SpreadsheetVersion.static boolean
CellReference.isRowWithinRange
(String rowStr, SpreadsheetVersion ssVersion) Determines whetherrowStr
is a valid row number for a given SpreadsheetVersion.static boolean
AreaReference.isWholeColumnReference
(SpreadsheetVersion version, CellReference topLeft, CellReference botRight) Is the reference for a whole-column reference, such as C:C or D:G ?void
CellRangeAddressBase.validate
(SpreadsheetVersion ssVersion) Validate the range limits against the supplied version of ExcelConstructors in org.apache.poi.ss.util with parameters of type SpreadsheetVersionModifierConstructorDescriptionAreaReference
(String reference, SpreadsheetVersion version) Create an area ref from a string representation.AreaReference
(CellReference topLeft, CellReference botRight, SpreadsheetVersion version) Creates an area ref from a pair of Cell References. -
Uses of SpreadsheetVersion in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return SpreadsheetVersionModifier and TypeMethodDescriptionSXSSFWorkbook.getSpreadsheetVersion()
Returns the spreadsheet version (EXCLE2007) of this workbook -
Uses of SpreadsheetVersion in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return SpreadsheetVersionModifier and TypeMethodDescriptionBaseXSSFEvaluationWorkbook.getSpreadsheetVersion()
XSSFWorkbook.getSpreadsheetVersion()
Returns the spreadsheet version (EXCLE2007) of this workbook