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.util |

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

Methods in org.apache.poi.hssf.usermodel that return SpreadsheetVersion
`SpreadsheetVersion` | `HSSFEvaluationWorkbook.getSpreadsheetVersion()`

Uses of SpreadsheetVersion in org.apache.poi.ss

Fields in org.apache.poi.ss declared as SpreadsheetVersion
`static SpreadsheetVersion` | `SpreadsheetVersion.EXCEL2007` Excel2007 The total number of available columns is 16K (2^14) The total number of available rows is 1M (2^20) The maximum number of arguments to a function is 255 Number of conditional format conditions on a cell is unlimited (actually limited by available memory in Excel) Length of text cell contents is 32767
`static SpreadsheetVersion` | `SpreadsheetVersion.EXCEL97` Excel97 format aka BIFF8 The total number of available columns is 256 (2^8) The total number of available rows is 64k (2^16) The maximum number of arguments to a function is 30 Number of conditional format conditions on a cell is 3 Length of text cell contents is 32767

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.)

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 boolean` | `CellReference.isColumnWithnRange(java.lang.String colStr, SpreadsheetVersion ssVersion)`
`static boolean` | `CellReference.isRowWithnRange(java.lang.String rowStr, SpreadsheetVersion ssVersion)`
`void` | `CellRangeAddressBase.validate(SpreadsheetVersion ssVersion)` Validate the range limits against the supplied version of Excel

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