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

- Packages that use SpreadsheetVersion
  Package | Description
  --- | ---
  org.apache.poi.hssf.usermodel | The usermodel package maps HSSF low level structures 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
    `protected SpreadsheetVersion` | HSSFCell.`getSpreadsheetVersion()` Get the spreadsheet version for the given implementation.
    `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
    `protected abstract SpreadsheetVersion` | CellBase.`getSpreadsheetVersion()` Get the spreadsheet version for the given implementation.

  - ### 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
    --- | ---
    `protected SpreadsheetVersion` | SXSSFCell.`getSpreadsheetVersion()` Get the spreadsheet version for the given implementation.
    `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
    `protected SpreadsheetVersion` | XSSFCell.`getSpreadsheetVersion()` Get the spreadsheet version for the given implementation.
    `SpreadsheetVersion` | BaseXSSFEvaluationWorkbook.`getSpreadsheetVersion()`

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