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

Packages that use SpreadsheetVersion

Package	Description
io.keikai.model.impl.sys.formula	Keikai Spreadsheet Internal Book Model Implementation classes.
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.zkoss.poi.ss
org.zkoss.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.zkoss.poi.ss.formula.ptg	formula package contains binary PTG structures used in Formulas
org.zkoss.poi.ss.util
org.zkoss.poi.xssf.usermodel

Uses of SpreadsheetVersion in io.keikai.model.impl.sys.formula

Methods in io.keikai.model.impl.sys.formula that return SpreadsheetVersion

Modifier and Type	Method and Description
SpreadsheetVersion	ParsingBook.getSpreadsheetVersion()
SpreadsheetVersion	EvalBook.getSpreadsheetVersion()

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

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

Modifier and Type	Method and Description
SpreadsheetVersion	HSSFEvaluationWorkbook.getSpreadsheetVersion()

Uses of SpreadsheetVersion in org.zkoss.poi.ss

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

Modifier and Type	Method and Description
static SpreadsheetVersion	SpreadsheetVersion.valueOf(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.zkoss.poi.ss.formula

Methods in org.zkoss.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.)

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

Modifier and Type	Method and Description
static Ptg[]	Formula.getTokens(Formula formula, SpreadsheetVersion version)
Ptg[]	Formula.getTokens(SpreadsheetVersion version)

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

Constructor and Description
PtgShifter(int externSheetIndex, int firstRow, int lastRow, int rowAmount, int firstCol, int lastCol, int colAmount, SpreadsheetVersion ver)
SharedFormula(SpreadsheetVersion ssVersion)

Uses of SpreadsheetVersion in org.zkoss.poi.ss.formula.ptg

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

Modifier and Type	Method and Description
static Ptg	Ptg.createPtg(LittleEndianInput in, SpreadsheetVersion version)
static int	Ptg.getEncodedSize(Ptg[] ptgs, SpreadsheetVersion version) This method will return the same result as Ptg.getEncodedSizeWithoutArrayData(Ptg[]) if there are no array tokens present.
static int	Ptg.getEncodedSizeWithoutArrayData(Ptg[] ptgs, SpreadsheetVersion version)
int	ValueOperatorPtg.getSize(SpreadsheetVersion version)
int	UnknownPtg.getSize(SpreadsheetVersion version)
int	UnionPtg.getSize(SpreadsheetVersion version)
int	TblPtg.getSize(SpreadsheetVersion version)
int	TablePtg.getSize(SpreadsheetVersion version)
int	StringPtg.getSize(SpreadsheetVersion version)
int	RefErrorPtg.getSize(SpreadsheetVersion version)
int	Ref3DPtg.getSize(SpreadsheetVersion version)
int	RangePtg.getSize(SpreadsheetVersion version)
abstract int	Ptg.getSize(SpreadsheetVersion version)
int	ParenthesisPtg.getSize(SpreadsheetVersion version)
int	Parenthesis2Ptg.getSize(SpreadsheetVersion version)
int	NumberPtg.getSize(SpreadsheetVersion version)
int	NameXPtg.getSize(SpreadsheetVersion version)
int	NamePtg.getSize(SpreadsheetVersion version)
int	MultiplyPtg.getSize(SpreadsheetVersion version)
int	MissingArgPtg.getSize(SpreadsheetVersion version)
int	MemFuncPtg.getSize(SpreadsheetVersion version)
int	MemErrPtg.getSize(SpreadsheetVersion version)
int	MemAreaPtg.getSize(SpreadsheetVersion version)
int	IntersectionPtg.getSize(SpreadsheetVersion version)
int	IntPtg.getSize(SpreadsheetVersion version)
int	FuncVarPtg.getSize(SpreadsheetVersion version)
int	FuncPtg.getSize(SpreadsheetVersion version)
int	ExpPtg.getSize(SpreadsheetVersion version)
int	ErrPtg.getSize(SpreadsheetVersion version)
int	DeletedRef3DPtg.getSize(SpreadsheetVersion version)
int	DeletedArea3DPtg.getSize(SpreadsheetVersion version)
int	DeferredNamePtg.getSize(SpreadsheetVersion version)
int	BoolPtg.getSize(SpreadsheetVersion version)
int	AttrPtg.getSize(SpreadsheetVersion version)
int	ArrayPtg.getSize(SpreadsheetVersion version)
int	AreaErrPtg.getSize(SpreadsheetVersion version)
int	Area3DPtg.getSize(SpreadsheetVersion version)
int	Area2DPtgBase.getSize(SpreadsheetVersion version)
protected void	RefPtgBase.readCoordinates(LittleEndianInput in, SpreadsheetVersion version)
protected void	AreaPtgBase.readCoordinates(LittleEndianInput in, SpreadsheetVersion version)
static Ptg[]	Ptg.readTokens(int size, LittleEndianInput in, SpreadsheetVersion version)
static int	Ptg.serializePtgs(Ptg[] ptgs, byte[] array, int offset, SpreadsheetVersion version)
void	ValueOperatorPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	UnknownPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	UnionPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	TblPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	TablePtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	StringPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	RefErrorPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	Ref3DPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	RangePtg.write(LittleEndianOutput out, SpreadsheetVersion version)
abstract void	Ptg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	ParenthesisPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	Parenthesis2Ptg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	NumberPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	NameXPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	NamePtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	MultiplyPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	MissingArgPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	MemFuncPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	MemErrPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	MemAreaPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	IntersectionPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	IntPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	FuncVarPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	FuncPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	ExpPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	ErrPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	DeletedRef3DPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	DeletedArea3DPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	DeferredNamePtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	BoolPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	AttrPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	ArrayPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	AreaErrPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	Area3DPtg.write(LittleEndianOutput out, SpreadsheetVersion version)
void	Area2DPtgBase.write(LittleEndianOutput out, SpreadsheetVersion version)
protected void	RefPtgBase.writeCoordinates(LittleEndianOutput out, SpreadsheetVersion version)
protected void	AreaPtgBase.writeCoordinates(LittleEndianOutput out, SpreadsheetVersion version)

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

Constructor and Description
Area2DPtgBase(LittleEndianInput in, SpreadsheetVersion version)
Area3DPtg(LittleEndianInput in, SpreadsheetVersion version)
AreaNPtg(LittleEndianInput in, SpreadsheetVersion version)
AreaPtg(LittleEndianInput in, SpreadsheetVersion version)
MultiplyPtg(LittleEndianInput in, SpreadsheetVersion version)
Ref3DPtg(LittleEndianInput in, SpreadsheetVersion version)
RefNPtg(LittleEndianInput in, SpreadsheetVersion version)
RefPtg(LittleEndianInput in, SpreadsheetVersion version)

Uses of SpreadsheetVersion in org.zkoss.poi.ss.util

Fields in org.zkoss.poi.ss.util declared as SpreadsheetVersion

Modifier and Type	Field and Description
protected SpreadsheetVersion	AreaReference.version

Methods in org.zkoss.poi.ss.util with parameters of type SpreadsheetVersion

Modifier and Type	Method and Description
static boolean	CellReference.cellReferenceIsWithinRange(String colStr, 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(String str, SpreadsheetVersion ssVersion) Classifies an identifier as either a simple (2D) cell reference or a named range name
static AreaReference	AreaReference.getWholeColumn(SpreadsheetVersion version, String start, String end)
static AreaReference	AreaReference.getWholeRow(SpreadsheetVersion version, String start, String end)
static boolean	CellReference.isColumnWithnRange(String colStr, SpreadsheetVersion ssVersion)
static boolean	CellReference.isRowWithnRange(String rowStr, SpreadsheetVersion ssVersion)
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 ?
static boolean	AreaReference.isWholeRowReference(SpreadsheetVersion version, CellReference topLeft, CellReference botRight)
void	CellRangeAddressBase.validate(SpreadsheetVersion ssVersion) Validate the range limits against the supplied version of Excel

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

Constructor and Description
AreaReference(String reference, SpreadsheetVersion version)

Uses of SpreadsheetVersion in org.zkoss.poi.xssf.usermodel

Methods in org.zkoss.poi.xssf.usermodel that return SpreadsheetVersion

Modifier and Type	Method and Description
SpreadsheetVersion	XSSFEvaluationWorkbook.getSpreadsheetVersion()