Package | Description |
---|---|
io.keikai.client.api | |
io.keikai.client.api.ctrl | |
io.keikai.client.api.event | |
io.keikai.util |
Modifier and Type | Method and Description |
---|---|
Range |
Spreadsheet.getActiveCell()
Returns the active cell focus range from the UI client.
|
Range |
Range.getCell(int row,
int column)
Returns the range from the cell position.
|
Range |
Range.getColumns()
Return the column part of this range.
|
Range |
Range.getColumns(int index)
Returns a Range that is n-th column(0-based) related to the first area of
this range and in the range.
|
Range |
Range.getEntireColumn()
Returns a Range that represents the entire column (or columns)
that contains this range.
|
Range |
Range.getEntireRow()
Returns a Range that represents the entire row (or rows) that
contains this range.
|
Range |
DataValidationValue.getRange()
Returns the range associated to this data validation.
|
Range |
Workbook.getRange(int row,
int column)
Returns the range with the given row and column from the active worksheet.
|
Range |
Worksheet.getRange(int row,
int column)
Returns the range with the given row and column.
|
Range |
Spreadsheet.getRange(int row,
int column)
Returns the range with the given row and column for the active worksheet
of the active workbook.
|
Range |
Workbook.getRange(int sheetIndex,
int row,
int column)
Returns the range with the given row and column from the given sheet
index.
|
Range |
Workbook.getRange(int row,
int column,
int numRows,
int numColumns)
Returns the range with the given row and column with the given number
of the rows and columns from the active worksheet.
|
Range |
Worksheet.getRange(int row,
int column,
int numRows,
int numColumns)
Returns the range with the given row and column with the given number
of the rows and columns
|
Range |
Spreadsheet.getRange(int row,
int column,
int numRows,
int numColumns)
Returns the range with the given row and column with the given number
of the rows and columns from the active worksheet of the active workbook.
|
Range |
Workbook.getRange(int sheetIndex,
int row,
int column,
int numRows,
int numColumns)
Returns the range with the given row and column with the given number
of the rows and columns of the worksheet at the given sheet index.
|
Range |
Workbook.getRange(int sheetIndex,
String a1Notation)
Returns the range with the given A1 notation or R1C1 notation from the
given sheet index.
|
Range |
Workbook.getRange(String a1Notation)
Returns the range with the given A1 notation or R1C1 notation from the active
worksheet.
|
Range |
Worksheet.getRange(String a1Notation)
Returns the range with the given A1 notation or R1C1 notation.
|
Range |
Spreadsheet.getRange(String a1Notation)
Returns the range with the given A1 notation or R1C1 notation from the
active worksheet of the active workbook.
|
Range |
Workbook.getRange(String sheetNameOrSheetId,
int row,
int column)
Returns the range with the given row and column from the given sheet
name or id.
|
Range |
Spreadsheet.getRange(String bookName,
int sheetIndex,
int row,
int column)
Returns the range with the given row and column from the given book name and sheet index.
|
Range |
Workbook.getRange(String sheetNameOrSheetIndex,
int row,
int column,
int numRows,
int numColumns)
Returns the range with the given row and column with the given number
of the rows and columns of the worksheet with the given sheet name or id.
|
Range |
Spreadsheet.getRange(String bookName,
int sheetIndex,
int row,
int column,
int numRows,
int numColumns)
Returns the range with the given row and column with the given number
of the rows and columns from the given sheet index of the given book name.
|
Range |
Spreadsheet.getRange(String bookName,
int sheetIndex,
String a1Notation)
Returns the range with the given A1 notation or R1C1 notation from
the given book name with the given sheet index.
|
Range |
Workbook.getRange(String sheetNameOrSheetId,
String a1Notation)
Returns the range with the given A1 notation or R1C1 notation from the
given sheet name or id.
|
Range |
Spreadsheet.getRange(String bookName,
String sheetNameOrSheetId,
int row,
int column)
Returns the range with the given row and column from the given book name and sheet name or id.
|
Range |
Spreadsheet.getRange(String bookName,
String sheetNameOrSheetId,
int row,
int column,
int numRows,
int numColumns)
Returns the range with the given row and column with the given number
of the rows and columns from the given sheet name or id of the given book name.
|
Range |
Spreadsheet.getRange(String bookName,
String sheetNameOrSheetId,
String a1Notation)
Returns the range with the given A1 notation or R1C1 notation from
the given book name with the given sheet name or id.
|
Range |
Spreadsheet.getRangeByName(String name)
Returns the range with the given name from
the active worksheet.
|
Range |
Spreadsheet.getRangeByName(String sheetNameOrSheetId,
String name)
Returns the range with the given name from
the active book with the given sheet name or id.
|
Range |
Spreadsheet.getRangeByName(String bookName,
String sheetNameOrSheetId,
String name)
Returns the range with the given name from
the given book name with the given sheet name or id.
|
Range |
Range.getRows()
Returns the row port of this range.
|
Range |
Range.getRows(int index)
Returns a Range that is n-th row(0-based) related to the first area of
this range and in the range.
|
Modifier and Type | Method and Description |
---|---|
void |
Range.copyTo(Range dest)
Copies this range to the destination
|
void |
Range.cutTo(Range dest)
Cuts and pastes the range to the destination
|
void |
Range.pasteSpecial(Range dest,
Range.PasteType type,
Range.PasteSpecialOperation op,
boolean skipBlanks,
boolean transpose)
Pastes a range to the destination range
|
void |
Range.setAutoFill(Range dest,
Range.AutoFillType fillType)
According to current range, fills data to destination range automatically
|
void |
Range.sort(Range key1,
Range.SortOrder order1,
Range key2,
Range.SortOrder order2,
Range key3,
Range.SortOrder order3,
Range.YesNoGuess header,
boolean matchCase,
Range.SortOrientation orientation,
Range.SortDataOption dataOption1,
Range.SortDataOption dataOption2,
Range.SortDataOption dataOption3)
Sort values in this range with given options.
|
Modifier and Type | Method and Description |
---|---|
Range |
Scrollbar.getCellLink()
Returns the range of the cell link.
|
Range |
Dropdown.getCellLink()
Returns the range of the cell link.
|
Range |
Listbox.getCellLink()
Returns the range of the cell link.
|
Range |
Spinner.getCellLink()
Returns the range of the cell link.
|
Range |
Dropdown.getInputRange()
Returns the input range in which the data loaded from, if any.
|
Range |
Listbox.getInputRange()
Returns the input range in which the data loaded from, if any.
|
Modifier and Type | Method and Description |
---|---|
Range |
RangeSelectEvent.getActiveCell()
Returns the active cell of this range event.
|
Range |
AuxActionEvent.getActiveCell() |
Range |
RangeSelectEvent.getActiveSelection()
Returns the active selection of this range event.
|
Range |
ShapeChangeEvent.getCellLink()
Returns the range of the cell link.
|
Range |
ShapeSelectEvent.getCellLink()
Returns the range of the cell link.
|
Range |
ShapeSelectEvent.getInputRange()
Returns the input range in which the data loaded from, if any.
|
Range |
RangeEvent.getRange()
Returns the first range, if any.
|
Modifier and Type | Method and Description |
---|---|
Set<Range> |
RangeEvent.getRanges() |
Constructor and Description |
---|
AuxActionEvent(String name,
String action,
Range activeCell,
Set<Range> refs,
Object data) |
RangeSelectEvent(String name,
Set<Range> refs,
Range activeCell,
Range activeSelection,
Object data) |
ShapeChangeEvent(String name,
Set refs,
int targetX,
int targetY,
int targetWidth,
int targetHeight,
T target,
int value,
int min,
int max,
int step,
int pageSize,
Range cellLink,
Object data) |
ShapeSelectEvent(String name,
Set refs,
int targetX,
int targetY,
int targetWidth,
int targetHeight,
T target,
List selectedItems,
List<Integer> selectedIndexes,
Range inputRange,
Range cellLink,
Object data) |
Constructor and Description |
---|
AuxActionEvent(String name,
String action,
Range activeCell,
Set<Range> refs,
Object data) |
CellEditEvent(String name,
Set<Range> refs,
Object data) |
CellHyperlinkEvent(String name,
Set<Range> refs,
int keys,
int button,
int pageX,
int pageY,
int x,
int y,
String address,
String type,
int targetX,
int targetY,
int targetWidth,
int targetHeight,
Object data) |
CellMouseEvent(String name,
Set<Range> refs,
int keys,
int button,
int pageX,
int pageY,
int x,
int y,
int targetX,
int targetY,
int targetWidth,
int targetHeight,
Object data) |
RangeEvent(String name,
Set<Range> refs,
Object data) |
RangeKeyEvent(String name,
Set<Range> refs,
int keyCode,
int keys,
Object data) |
RangeSelectEvent(String name,
Set<Range> refs,
Range activeCell,
Range activeSelection,
Object data) |
ShapeEvent(String name,
Set<Range> refs,
int targetX,
int targetY,
int targetWidth,
int targetHeight,
T target,
Object data) |
ShapeMouseEvent(String name,
Set<Range> refs,
int keys,
int button,
int pageX,
int pageY,
int x,
int y,
int targetX,
int targetY,
int targetWidth,
int targetHeight,
T target,
Object data) |
Modifier and Type | Method and Description |
---|---|
static Range |
Converter.toRangeFromJSON(Spreadsheet spreadsheet,
String ref) |
Copyright © 2018. All rights reserved.