Uses of Class
org.apache.poi.ss.SpreadsheetVersion
-
Packages that use SpreadsheetVersion Package Description io.keikai.model.impl.sys.formula Keikai Spreadsheet Internal Book Model Implementation classes.org.apache.poi.hssf.usermodel The usermodel package maps HSSF low level structures to familiar workbook/sheet modelorg.apache.poi.ss org.apache.poi.ss.formula This package contains common internal POI code for manipulating formulas.org.apache.poi.ss.formula.ptg The formula package contains binary PTG structures used in Formulasorg.apache.poi.ss.usermodel org.apache.poi.ss.util -
-
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 Description SpreadsheetVersionEvalBook. getSpreadsheetVersion()SpreadsheetVersionParsingBook. getSpreadsheetVersion() -
Uses of SpreadsheetVersion in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return SpreadsheetVersion Modifier and Type Method Description protected SpreadsheetVersionHSSFCell. getSpreadsheetVersion()SpreadsheetVersionHSSFEvaluationWorkbook. getSpreadsheetVersion()SpreadsheetVersionHSSFWorkbook. getSpreadsheetVersion()Returns the spreadsheet version (EXCEL97) of this workbook -
Uses of SpreadsheetVersion in org.apache.poi.ss
Methods in org.apache.poi.ss that return SpreadsheetVersion Modifier and Type Method Description static SpreadsheetVersionSpreadsheetVersion. 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.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return SpreadsheetVersion Modifier and Type Method Description SpreadsheetVersionEvaluationWorkbook. getSpreadsheetVersion()SpreadsheetVersionFormulaParsingWorkbook. 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.apache.poi.ss.formula with parameters of type SpreadsheetVersion Modifier and Type Method Description static FormulaShifterFormulaShifter. createForColumnCopy(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version)static FormulaShifterFormulaShifter. createForColumnShift(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version)static FormulaShifterFormulaShifter. createForRowCopy(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version)static FormulaShifterFormulaShifter. createForRowShift(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version)static Ptg[]Formula. getTokens(Formula formula, SpreadsheetVersion version)Ptg[]Formula. getTokens(SpreadsheetVersion version)Constructors in org.apache.poi.ss.formula with parameters of type SpreadsheetVersion Constructor 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.apache.poi.ss.formula.ptg
Constructors in org.apache.poi.ss.formula.ptg with parameters of type SpreadsheetVersion Constructor 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.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return SpreadsheetVersion Modifier and Type Method Description protected abstract SpreadsheetVersionCellBase. getSpreadsheetVersion()Get the spreadsheet version for the given implementation.SpreadsheetVersionWorkbook. 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 Modifier and Type Method Description static booleanCellReference. 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.NameTypeCellReference. classifyCellReference(String str, SpreadsheetVersion ssVersion)Classifies an identifier as either a simple (2D) cell reference or a named range namestatic AreaReference[]AreaReference. generateContiguous(SpreadsheetVersion version, String reference)Takes a non-contiguous area reference, and returns an array of contiguous area referencesstatic AreaReferenceAreaReference. getWholeColumn(SpreadsheetVersion version, String start, String end)Construct an AreaReference which spans one more columns.static AreaReferenceAreaReference. getWholeRow(SpreadsheetVersion version, String start, String end)Construct an AreaReference which spans one more rowsstatic booleanCellReference. isColumnWithinRange(String colStr, SpreadsheetVersion ssVersion)static booleanCellReference. isRowWithinRange(int rowNum, SpreadsheetVersion ssVersion)Determines whetherrowis a valid row number for a given SpreadsheetVersion.static booleanCellReference. isRowWithinRange(String rowStr, SpreadsheetVersion ssVersion)Determines whetherrowStris a valid row number for a given SpreadsheetVersion.static booleanAreaReference. isWholeColumnReference(SpreadsheetVersion version, CellReference topLeft, CellReference botRight)Is the reference for a whole-column reference, such as C:C or D:G ?static booleanAreaReference. isWholeRowReference(SpreadsheetVersion version, CellReference topLeft, CellReference botRight)voidCellRangeAddressBase. validate(SpreadsheetVersion ssVersion)Validate the range limits against the supplied version of ExcelConstructors in org.apache.poi.ss.util with parameters of type SpreadsheetVersion Constructor Description AreaReference(String reference, SpreadsheetVersion version)Create an area ref from a string representation.AreaReference(CellReference topLeft, CellReference botRight, SpreadsheetVersion version)Creates an area ref from a pair of Cell References.
-