Uses of Class
org.apache.poi.ss.SpreadsheetVersion

Packages that use SpreadsheetVersion

Package	Description
org.apache.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.ss
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.usermodel
org.apache.poi.ss.util
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel

Uses of SpreadsheetVersion in org.apache.poi.hssf.usermodel

Methods in org.apache.poi.hssf.usermodel that return SpreadsheetVersion

Modifier and Type	Method and Description
SpreadsheetVersion	HSSFWorkbook.getSpreadsheetVersion() Returns the spreadsheet version (EXCLE97) of this workbook
SpreadsheetVersion	HSSFEvaluationWorkbook.getSpreadsheetVersion()

Uses of SpreadsheetVersion in org.apache.poi.ss

Methods in org.apache.poi.ss that return SpreadsheetVersion

Modifier and Type	Method and Description
static SpreadsheetVersion	SpreadsheetVersion.valueOf(java.lang.String name) Returns the enum constant of this type with the specified name.
static SpreadsheetVersion[]	SpreadsheetVersion.values() Returns an array containing the constants of this enum type, in the order they are declared.

Uses of SpreadsheetVersion in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula that return SpreadsheetVersion

Modifier and Type	Method and Description
SpreadsheetVersion	FormulaParsingWorkbook.getSpreadsheetVersion() Returns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)
SpreadsheetVersion	EvaluationWorkbook.getSpreadsheetVersion()

Methods in org.apache.poi.ss.formula with parameters of type SpreadsheetVersion

Modifier and Type	Method and Description
static FormulaShifter	FormulaShifter.createForColumnCopy(int externSheetIndex, java.lang.String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version)
static FormulaShifter	FormulaShifter.createForColumnShift(int externSheetIndex, java.lang.String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version)
static FormulaShifter	FormulaShifter.createForRowCopy(int externSheetIndex, java.lang.String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version)
static FormulaShifter	FormulaShifter.createForRowShift(int externSheetIndex, java.lang.String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version)

Constructors in org.apache.poi.ss.formula with parameters of type SpreadsheetVersion

Constructor and Description
SharedFormula(SpreadsheetVersion ssVersion)

Uses of SpreadsheetVersion in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel that return SpreadsheetVersion

Modifier and Type	Method and Description
SpreadsheetVersion	Workbook.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 SpreadsheetVersion

Modifier and Type	Method and Description
static boolean	CellReference.cellReferenceIsWithinRange(java.lang.String colStr, java.lang.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(java.lang.String str, SpreadsheetVersion ssVersion) Classifies an identifier as either a simple (2D) cell reference or a named range name
static AreaReference[]	AreaReference.generateContiguous(SpreadsheetVersion version, java.lang.String reference) Takes a non-contiguous area reference, and returns an array of contiguous area references
static AreaReference	AreaReference.getWholeColumn(SpreadsheetVersion version, java.lang.String start, java.lang.String end)
static AreaReference	AreaReference.getWholeRow(SpreadsheetVersion version, java.lang.String start, java.lang.String end)
static boolean	CellReference.isColumnWithinRange(java.lang.String colStr, SpreadsheetVersion ssVersion)
static boolean	CellReference.isRowWithinRange(int rowNum, SpreadsheetVersion ssVersion) Determines whether row is a valid row number for a given SpreadsheetVersion.
static boolean	CellReference.isRowWithinRange(java.lang.String rowStr, SpreadsheetVersion ssVersion) Determines whether rowStr 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 Excel

Constructors in org.apache.poi.ss.util with parameters of type SpreadsheetVersion

Constructor and Description
AreaReference(CellReference topLeft, CellReference botRight, SpreadsheetVersion version) Creates an area ref from a pair of Cell References.
AreaReference(java.lang.String reference, SpreadsheetVersion version) Create an area ref from a string representation.

Uses of SpreadsheetVersion in org.apache.poi.xssf.streaming

Methods in org.apache.poi.xssf.streaming that return SpreadsheetVersion

Modifier and Type	Method and Description
SpreadsheetVersion	SXSSFWorkbook.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 SpreadsheetVersion

Modifier and Type	Method and Description
SpreadsheetVersion	XSSFWorkbook.getSpreadsheetVersion() Returns the spreadsheet version (EXCLE2007) of this workbook
SpreadsheetVersion	BaseXSSFEvaluationWorkbook.getSpreadsheetVersion()