Uses of Interface
org.zkoss.zss.model.Range

Packages that use Range

org.zkoss.zss.model	The major package for developer to access/configure/control the ZK Spreadsheet.
org.zkoss.zss.model.impl	Classes used to implement ZK Spreadsheet book model(implementation only).
org.zkoss.zss.ui.impl	Classes for implementing ZK Spreadsheet UI Components (implementation only).

Uses of Range in org.zkoss.zss.model

Fields in org.zkoss.zss.model declared as Range

static Range

Ranges.EMPTY_RANGE

Methods in org.zkoss.zss.model that return Range

Range	Range.copy(Range dstRange) Copy data from this range to the specified destination range.
Range	Range.getCells(int row, int col) Return the range that contains the cell specified in row, col (relative to this Range).
Range	Range.getColumns() Returns a Range that represent all columns of the 1st selected area of this Range.
Range	Range.getCurrentRegion() Returns a Range that bounds current Left-top cell of this Range with a combination of blank Rows and Columns.
Range	Range.getDependents() Returns a Range that represent all dependents of the left-top cell of the 1st selected area of this Range.
Range	Range.getDirectDependents() Returns a Range that represent all direct dependents of the left-top cell of the 1st selected area of this Range.
Range	Range.getDirectPrecedents() Returns a Range that represent all direct precedents of the left-top cell of the 1st selected area of this Range.
Range	Areas.getItem() Returns a single object from this collection.
Range	Range.getOffset(int rowOffset, int colOffset) Returns a Range that represents a range that offset from this Range.
Range	Range.getPrecedents() Returns a Range that represent all precedents of the left-top cell of the 1st selected area of this Range.
Range	Range.getRows() Returns a Range that represent all rows of the 1st selected area of this Range.
Range	Range.pasteSpecial(int pasteType, int pasteOp, boolean SkipBlanks, boolean transpose) Pastes a Range from the Clipboard into this range.
Range	Range.pasteSpecial(Range dstRange, int pasteType, int pasteOp, boolean skipBlanks, boolean transpose) Pastes to a destination Range from this range.
static Range	Ranges.range(Worksheet sheet) Returns the associated Range of the whole specified Worksheet.
static Range	Ranges.range(Worksheet sheet, org.zkoss.poi.ss.util.AreaReference ref) Returns the associated Range of the specified Worksheet and AreaReference. note that if AreaReference contains sheet name, the returned range will refer to the named sheet.
static Range	Ranges.range(Worksheet sheet, int row, int col) Returns the associated Range of the specified Worksheet and cell row and column.
static Range	Ranges.range(Worksheet sheet, int tRow, int lCol, int bRow, int rCol) Returns the associated Range of the specified Worksheet and area.
static Range	Ranges.range(Worksheet sheet, java.lang.String reference) Returns the associated Range of the specified Worksheet and area reference string (e.g.
static Range	Ranges.range(Worksheet firstSheet, Worksheet lastSheet, int row, int col) Returns the associated three dimension Range of the specified Worksheets and cell row and column.
static Range	Ranges.range(Worksheet firstSheet, Worksheet lastSheet, int tRow, int lCol, int bRow, int rCol) Returns the associated three dimension Range of the specified Worksheets and area.

Methods in org.zkoss.zss.model with parameters of type Range

void	Range.autoFill(Range dstRange, int fillType) Perform an auto fill on the specified destination Range.
Range	Range.copy(Range dstRange) Copy data from this range to the specified destination range.
Range	Range.pasteSpecial(Range dstRange, int pasteType, int pasteOp, boolean skipBlanks, boolean transpose) Pastes to a destination Range from this range.
void	Range.sort(Range rng1, boolean desc1, Range rng2, int type, boolean desc2, Range rng3, boolean desc3, int header, int orderCustom, boolean matchCase, boolean sortByRows, int sortMethod, int dataOption1, int dataOption2, int dataOption3) Sort this Range per the specified parameters

Uses of Range in org.zkoss.zss.model.impl

Classes in org.zkoss.zss.model.impl that implement Range

class	EmptyRange Class to represent an empty Range.
class	RangeImpl Implementation of Range which plays a facade to operate on the spreadsheet data models and maintain the reference dependency.

Methods in org.zkoss.zss.model.impl that return Range

Range	RangeImpl.copy(Range dstRange)
Range	EmptyRange.copy(Range dstRange)
Range	RangeImpl.getCells(int row, int col)
Range	EmptyRange.getCells(int row, int col)
Range	RangeImpl.getColumns()
Range	EmptyRange.getColumns()
Range	RangeImpl.getCurrentRegion()
Range	EmptyRange.getCurrentRegion()
Range	RangeImpl.getDependents()
Range	EmptyRange.getDependents()
Range	RangeImpl.getDirectDependents()
Range	EmptyRange.getDirectDependents()
Range	RangeImpl.getDirectPrecedents()
Range	EmptyRange.getDirectPrecedents()
Range	AreasImpl.getItem()
Range	RangeImpl.getOffset(int rowOffset, int colOffset)
Range	EmptyRange.getOffset(int rowOffset, int colOffset)
Range	RangeImpl.getPrecedents()
Range	EmptyRange.getPrecedents()
Range	RangeImpl.getRows()
Range	EmptyRange.getRows()
Range	RangeImpl.pasteSpecial(int pasteType, int operation, boolean SkipBlanks, boolean transpose)
Range	EmptyRange.pasteSpecial(int pasteType, int operation, boolean SkipBlanks, boolean transpose)
Range	RangeImpl.pasteSpecial(Range dstRange, int pasteType, int pasteOp, boolean skipBlanks, boolean transpose)
Range	EmptyRange.pasteSpecial(Range dstRange, int pasteType, int pasteOp, boolean skipBlanks, boolean transpose)

Methods in org.zkoss.zss.model.impl that return types with arguments of type Range

java.util.Iterator<Range>

AreasImpl.iterator()

Methods in org.zkoss.zss.model.impl with parameters of type Range

void	RangeImpl.autoFill(Range dstRange, int fillType)
void	EmptyRange.autoFill(Range dstRange, int fillType)
Range	RangeImpl.copy(Range dstRange)
Range	EmptyRange.copy(Range dstRange)
Range	RangeImpl.pasteSpecial(Range dstRange, int pasteType, int pasteOp, boolean skipBlanks, boolean transpose)
Range	EmptyRange.pasteSpecial(Range dstRange, int pasteType, int pasteOp, boolean skipBlanks, boolean transpose)
static void	BookHelper.removeDataValidtionOfRange(Range range)
static void	BookHelper.setDataValidationToRange(Range range, Range ref)
static void	BookHelper.setDataValidationToRange(Range range, java.lang.String[] list)
void	RangeImpl.sort(Range rng1, boolean desc1, Range rng2, int type, boolean desc2, Range rng3, boolean desc3, int header, int orderCustom, boolean matchCase, boolean sortByRows, int sortMethod, int dataOption1, int dataOption2, int dataOption3)
void	EmptyRange.sort(Range rng1, boolean desc1, Range rng2, int type, boolean desc2, Range rng3, boolean desc3, int header, int orderCustom, boolean matchCase, boolean sortByRows, int sortMethod, int dataOption1, int dataOption2, int dataOption3)

Uses of Range in org.zkoss.zss.ui.impl

Methods in org.zkoss.zss.ui.impl that return Range

Range	CellVisitorContext.getRange() Returns the range
static Range	Utils.getRange(Worksheet sheet, int row, int col) Return a cell Range per the given sheet, row index, and column index.
static Range	Utils.getRange(Worksheet sheet, int tRow, int lCol, int bRow, int rCol) Returns a area Range per the given sheet, top row index, left column index, bottom row index, and right column index.
static Range	Utils.getRange(Worksheet firstSheet, Worksheet lastSheet, int row, int col) Return a 3D cell Range per the given sheet, row index, and column index.
static Range	Utils.getRange(Worksheet firstSheet, Worksheet lastSheet, int tRow, int lCol, int bRow, int rCol) Return a 3D area Range per the given sheet, top row index, left column index, bottom row index, and right column index.
static Range	Utils.pasteSpecial(Worksheet srcSheet, Rect srcRect, Worksheet dstSheet, int tRow, int lCol, int bRow, int rCol, int pasteType, int pasteOp, boolean skipBlanks, boolean transpose) Pastes to a destination from source Rect