Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

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()`

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.