|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use SpreadsheetVersion | |
|---|---|
| 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 | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
SharedFormula(SpreadsheetVersion ssVersion)
|
|
| Uses of SpreadsheetVersion in org.apache.poi.ss.usermodel |
|---|
| Methods in org.apache.poi.ss.usermodel that return SpreadsheetVersion | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
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 | |
|---|---|
SpreadsheetVersion |
XSSFWorkbook.getSpreadsheetVersion()
Returns the spreadsheet version (EXCLE2007) of this workbook |
SpreadsheetVersion |
BaseXSSFEvaluationWorkbook.getSpreadsheetVersion()
|
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||