Skip navigation links
A B C D E F G H I K L M N O P R S T U V W 

A

a1ToRef(String) - Static method in class io.keikai.util.Converter
 
abcToNum(String) - Static method in class io.keikai.util.Converter
Converts abc to number.
AbortedException - Exception in io.keikai.client.api
Exception indicating that the result of a task is being cancelled.
AbortedException() - Constructor for exception io.keikai.client.api.AbortedException
Constructs a AbortedException with no detail message.
AbortedException(String) - Constructor for exception io.keikai.client.api.AbortedException
Constructs a AbortedException with the specified detail message.
abortImporting(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
abortImporting(String) - Method in interface io.keikai.client.api.Spreadsheet
Aborts a importing job at remote server.
accept(T) - Method in interface io.keikai.util.Functions.ExceptionableConsumer
 
acceptWithException(T) - Method in interface io.keikai.util.Functions.ExceptionableConsumer
 
activate() - Method in class io.keikai.client.api.atomic.AtomicRange
 
activate() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
activate() - Method in interface io.keikai.client.api.Range
Select a cell or cells with this range.
activate() - Method in interface io.keikai.client.api.Worksheet
Activates the worksheet
add(UICommand) - Method in class io.keikai.client.api.ui.ToolbarSettings
Add toolbar button in the end of the toolbar
addAction(RangeEventListener<? extends ShapeMouseEvent<Button>>) - Method in interface io.keikai.client.api.ctrl.Button
Adds an action for this button.
addAction(RangeEventListener<? extends ShapeMouseEvent<Checkbox>>) - Method in interface io.keikai.client.api.ctrl.Checkbox
Adds an action for this checkbox.
addAction(RangeEventListener<? extends ShapeSelectEvent<Dropdown>>) - Method in interface io.keikai.client.api.ctrl.Dropdown
Adds an action for this dropdown.
addAction(RangeEventListener<? extends ShapeMouseEvent<OptionButton>>) - Method in interface io.keikai.client.api.ctrl.Groupbox
Adds an action for this Groupbox when option button has checked.
addAction(RangeEventListener<? extends ShapeSelectEvent<Listbox>>) - Method in interface io.keikai.client.api.ctrl.Listbox
Adds an action for this listbox.
addAction(RangeEventListener<? extends ShapeMouseEvent<OptionButton>>) - Method in interface io.keikai.client.api.ctrl.OptionButton
Adds an action for this option button.
addAction(RangeEventListener<? extends ShapeChangeEvent<Scrollbar>>) - Method in interface io.keikai.client.api.ctrl.Scrollbar
Adds an action for this scrollbar.
addAction(RangeEventListener<? extends ShapeChangeEvent<Spinner>>) - Method in interface io.keikai.client.api.ctrl.Spinner
Adds an action for this spinner.
addButton(String, String, RangeAnchor) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
addButton(String, String, RangeAnchor) - Method in interface io.keikai.client.api.Worksheet
Adds a button with the given range anchor on the worksheet.
addEventListener(String, RangeEventListener<? extends RangeEvent>) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
addEventListener(String, RangeEventListener<? extends RangeEvent>) - Method in interface io.keikai.client.api.Spreadsheet
Adds the event listener.
addExceptionHandler(Consumer<Throwable>) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
addExceptionHandler(Consumer<Throwable>) - Method in interface io.keikai.client.api.Spreadsheet
adds an exception handler to this spreadsheet.
addMeta(Object, Object) - Static method in class io.keikai.client.api.Keikai
Adds the specified key to the specified value in the global meta.
Alignment - Interface in io.keikai.client.api
An alignment interface
Alignment.Horizontal - Enum in io.keikai.client.api
Horizontal alignments that can be applied.
Alignment.ReadingOrder - Enum in io.keikai.client.api
ReadingOrder attributes that can be applied.
Alignment.Vertical - Enum in io.keikai.client.api
Vertical alignments that can be applied.
apply(T) - Method in interface io.keikai.util.Functions.ExceptionableFunction
 
applyWithException(T) - Method in interface io.keikai.util.Functions.ExceptionableFunction
 
areaToRef(int, int, int, int) - Static method in class io.keikai.util.Converter
 
ArgumentFunction(A) - Constructor for class io.keikai.util.Functions.ArgumentFunction
 
AtomicRange - Class in io.keikai.client.api.atomic
Provides atomic operations setters for Range API.
AtomicRange(Range) - Constructor for class io.keikai.client.api.atomic.AtomicRange
 
AtomicSpreadsheet - Class in io.keikai.client.api.atomic
Provides atomic operations setters for Spreadsheet API.
AtomicSpreadsheet(Spreadsheet) - Constructor for class io.keikai.client.api.atomic.AtomicSpreadsheet
 
AtomicWorkbook - Class in io.keikai.client.api.atomic
Provides atomic operations setters for Workbook API.
AtomicWorkbook(Workbook) - Constructor for class io.keikai.client.api.atomic.AtomicWorkbook
 
AtomicWorksheet - Class in io.keikai.client.api.atomic
Provides atomic operations setters for Worksheet API.
AtomicWorksheet(Worksheet) - Constructor for class io.keikai.client.api.atomic.AtomicWorksheet
 

B

Border - Interface in io.keikai.client.api
Represents the border of an object for Range or CellStyle to use.
Border.Style - Enum in io.keikai.client.api
Style attributes that can be applied.
Border.ThemeColor - Enum in io.keikai.client.api
ThemeColor attributes that can be applied.
Borders - Interface in io.keikai.client.api
A collection of borders that represent the four borders of a Range or CellStyle Object.
Borders.BorderIndex - Enum in io.keikai.client.api
BorderIndex attributes that can be applied.
build() - Method in class io.keikai.client.api.SheetProtection.Builder
Returns an instance of SheetProtection created from the fields set on this builder.
Builder() - Constructor for class io.keikai.client.api.SheetProtection.Builder
 
Button - Interface in io.keikai.client.api.ctrl
Form control button

C

CellEditEvent - Class in io.keikai.client.api.event
CellEditEvent that affected by editing
CellEditEvent(String, Set<Range>, Object) - Constructor for class io.keikai.client.api.event.CellEditEvent
 
CellHyperlinkEvent - Class in io.keikai.client.api.event
Event represents an user click on the hyperlink of a cell
CellHyperlinkEvent(String, Set<Range>, int, int, int, int, int, int, String, String, int, int, int, int, Object) - Constructor for class io.keikai.client.api.event.CellHyperlinkEvent
 
CellMouseEvent - Class in io.keikai.client.api.event
Event that carries mouse x,y information and cell row,column information on click
CellMouseEvent(String, Set<Range>, int, int, int, int, int, int, int, int, int, int, Object) - Constructor for class io.keikai.client.api.event.CellMouseEvent
 
CellStyle - Interface in io.keikai.client.api
The CellStyle object contains all style attributes (font, number format, alignment, and so on) as properties.
CellValue - Interface in io.keikai.client.api
A cell value object.
Checkbox - Interface in io.keikai.client.api.ctrl
Form control checkbox
clear() - Method in class io.keikai.client.api.atomic.AtomicRange
 
clear() - Method in interface io.keikai.client.api.Range
Clears the formulas/values/formats of this range.
clear() - Method in class io.keikai.client.api.SheetProtection.Builder
Resets the builder to its initial, empty state.
clearActions() - Method in interface io.keikai.client.api.ctrl.Button
Clear all actions for this button.
clearActions() - Method in interface io.keikai.client.api.ctrl.Checkbox
Clear all actions for this checkbox.
clearActions() - Method in interface io.keikai.client.api.ctrl.Dropdown
Clear all actions for this dropdown.
clearActions() - Method in interface io.keikai.client.api.ctrl.Groupbox
Clear all actions for this groupbox.
clearActions() - Method in interface io.keikai.client.api.ctrl.Listbox
Clear all actions for this listbox.
clearActions() - Method in interface io.keikai.client.api.ctrl.OptionButton
Clear all actions for this option button.
clearActions() - Method in interface io.keikai.client.api.ctrl.Scrollbar
Clear all actions for this scrollbar.
clearActions() - Method in interface io.keikai.client.api.ctrl.Spinner
Clear all actions for this spinner.
clearAutoFilter() - Method in class io.keikai.client.api.atomic.AtomicRange
 
clearAutoFilter() - Method in interface io.keikai.client.api.Range
Clears the auto filter
clearCellStyle() - Method in class io.keikai.client.api.atomic.AtomicRange
 
clearCellStyle() - Method in interface io.keikai.client.api.Range
Clears the cell style.
clearContents() - Method in class io.keikai.client.api.atomic.AtomicRange
 
clearContents() - Method in interface io.keikai.client.api.Range
Clears a formula/values of this range
clearDataValidation() - Method in class io.keikai.client.api.atomic.AtomicRange
 
clearDataValidation() - Method in interface io.keikai.client.api.Range
Clears the data validation
clearEventListeners() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
clearEventListeners() - Method in interface io.keikai.client.api.Spreadsheet
Removes all the event listeners.
clearHyperlinks() - Method in class io.keikai.client.api.atomic.AtomicRange
 
clearHyperlinks() - Method in interface io.keikai.client.api.Range
Clears the hyperlink from this range.
clone() - Method in class io.keikai.client.api.Settings
 
clone() - Method in class io.keikai.client.api.ui.ToolbarSettings
 
close() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
close() - Method in interface io.keikai.client.api.Spreadsheet
Closes this client.
Colors - Class in io.keikai.util
A Color utilities.
Colors() - Constructor for class io.keikai.util.Colors
 
commandMap - Static variable in enum io.keikai.client.api.ui.UICommand
 
contains(Settings.Key) - Method in class io.keikai.client.api.Settings
 
containsWorkbook(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
containsWorkbook(String) - Method in interface io.keikai.client.api.Spreadsheet
Returns true, if the remote server contains the given bookName.
Converter - Class in io.keikai.util
 
Converter() - Constructor for class io.keikai.util.Converter
 
convertTime(String) - Static method in class io.keikai.util.DateUtil
Converts a string of format "HH:MM" or "HH:MM:SS" to its (Excel) numeric equivalent
copyTo(Range) - Method in class io.keikai.client.api.atomic.AtomicRange
 
copyTo(String, String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
copyTo(int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
copyTo(String, String, int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
copyTo(Workbook, int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
copyTo(Range) - Method in interface io.keikai.client.api.Range
Copies this range to the destination
copyTo(String, String) - Method in interface io.keikai.client.api.Workbook
Copies this workbook to another app with the given newBookName.
copyTo(int) - Method in interface io.keikai.client.api.Worksheet
Copies this sheet to this workbook at the given index, with a default name.
copyTo(String, String, int) - Method in interface io.keikai.client.api.Worksheet
Copies this sheet to another workbook of another app at the given index, with a default name.
copyTo(Workbook, int) - Method in interface io.keikai.client.api.Worksheet
Copies this sheet to the workbook at the given index, with a default name.
copyToEnd() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
copyToEnd(String, String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
copyToEnd(Workbook) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
copyToEnd() - Method in interface io.keikai.client.api.Worksheet
Copies this sheet to the end of this workbook, with a default name.
copyToEnd(String, String) - Method in interface io.keikai.client.api.Worksheet
Copies this sheet to the end of another workbook of another app, with a default name.
copyToEnd(Workbook) - Method in interface io.keikai.client.api.Worksheet
Copies this sheet to the end of the workbook, with a default name.
createAlignment() - Method in interface io.keikai.client.api.CellStyle
Creates a alignment.
createBorder() - Method in interface io.keikai.client.api.CellStyle
Creates a border
createBorders(Borders.BorderIndex) - Method in class io.keikai.client.api.atomic.AtomicRange
 
createBorders() - Method in class io.keikai.client.api.atomic.AtomicRange
 
createBorders() - Method in interface io.keikai.client.api.CellStyle
createBorders(Borders.BorderIndex) - Method in interface io.keikai.client.api.Range
Creates the borders from the given border index.
createBorders() - Method in interface io.keikai.client.api.Range
createCellStyle() - Method in class io.keikai.client.api.atomic.AtomicRange
 
createCellStyle() - Method in interface io.keikai.client.api.Range
Creates a cell style object.
createDataValidation() - Method in class io.keikai.client.api.atomic.AtomicRange
 
createDataValidation() - Method in interface io.keikai.client.api.Range
Creates a data validation
createFont() - Method in class io.keikai.client.api.atomic.AtomicRange
 
createFont() - Method in interface io.keikai.client.api.CellStyle
Creates a font.
createFont() - Method in interface io.keikai.client.api.Range
Creates a font
createHyperlink() - Method in class io.keikai.client.api.atomic.AtomicRange
 
createHyperlink() - Method in interface io.keikai.client.api.Range
Creates a hyperlink.
createNumberFormat() - Method in interface io.keikai.client.api.CellStyle
Creates a number format
createPatternFill() - Method in class io.keikai.client.api.atomic.AtomicRange
 
createPatternFill() - Method in interface io.keikai.client.api.CellStyle
Creates a pattern fill.
createPatternFill() - Method in interface io.keikai.client.api.Range
Creates a pattern fill.
createProtection() - Method in interface io.keikai.client.api.CellStyle
Creates a protection
cutTo(Range) - Method in class io.keikai.client.api.atomic.AtomicRange
 
cutTo(Range) - Method in interface io.keikai.client.api.Range
Cuts and pastes the range to the destination

D

DataValidation - Interface in io.keikai.client.api
A data validation interface
DataValidation.AlertStyle - Enum in io.keikai.client.api
AlertStyle attributes that can be applied.
DataValidation.Operator - Enum in io.keikai.client.api
Operator attributes that can be applied.
DataValidation.Type - Enum in io.keikai.client.api
Type attributes that can be applied.
DataValidationValue - Interface in io.keikai.client.api
A data validation value (Immutable) to hold the range info and the data validation.
DateUtil - Class in io.keikai.util
Contains methods for dealing with Excel dates.
DAY_MILLISECONDS - Static variable in class io.keikai.util.DateUtil
 
DEFAULT - Static variable in class io.keikai.client.api.ui.ToolbarSettings
The default settings.
DEFAULT_SECURE_SETTINGS - Static variable in class io.keikai.client.api.Settings
The default secure settings for Keikai engine to run in secure mode.
DEFAULT_SETTINGS - Static variable in class io.keikai.client.api.Settings
The default settings.
delete(Range.DeleteShiftDirection) - Method in class io.keikai.client.api.atomic.AtomicRange
 
delete() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
delete(Range.DeleteShiftDirection) - Method in interface io.keikai.client.api.Range
Deletes cells of the range.
delete() - Method in interface io.keikai.client.api.Spreadsheet
Deletes the remote application and close this client.
deleteWorkbook(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
deleteWorkbook(String) - Method in interface io.keikai.client.api.Spreadsheet
Deletes the remote workbook with the given name, if any.
deleteWorksheet() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
deleteWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
deleteWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
deleteWorksheet() - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
deleteWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
deleteWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
deleteWorksheet() - Method in interface io.keikai.client.api.Spreadsheet
Deletes the active worksheet from the active workbook.
deleteWorksheet(String) - Method in interface io.keikai.client.api.Spreadsheet
Deletes the worksheet with the given name or id from the active workbook.
deleteWorksheet(int) - Method in interface io.keikai.client.api.Spreadsheet
Deletes the worksheet at the given sheet index from the active workbook.
deleteWorksheet() - Method in interface io.keikai.client.api.Workbook
Deletes the active worksheet
deleteWorksheet(String) - Method in interface io.keikai.client.api.Workbook
Deletes the worksheet from the given name
deleteWorksheet(int) - Method in interface io.keikai.client.api.Workbook
Deletes the worksheet in the workbook at the given index
Dropdown - Interface in io.keikai.client.api.ctrl
Form control dropdown
DuplicateNameException - Exception in io.keikai.client.api
The DuplicateNameException exception is thrown if a book name cannot be imported because a workbook with the same name already exists.
DuplicateNameException() - Constructor for exception io.keikai.client.api.DuplicateNameException
Constructs a DuplicateNameException with no detail message.
DuplicateNameException(String) - Constructor for exception io.keikai.client.api.DuplicateNameException
Constructs a DuplicateNameException with the specified detail message.

E

EMPTY_CONSUMER - Static variable in class io.keikai.util.Functions
 
Events - Class in io.keikai.client.api.event
Utilities to handle events.
Events() - Constructor for class io.keikai.client.api.event.Events
 
export(String, OutputStream) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
export(String, OutputStream, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
export(String, OutputStream) - Method in interface io.keikai.client.api.Spreadsheet
Exports the book from the given bookname to an output stream.
export(String, OutputStream, String) - Method in interface io.keikai.client.api.Spreadsheet
Exports the book from the given bookname to an output stream with the given format.

F

FileUploadEvent - Class in io.keikai.client.api.event
A file upload event represents an UI command that user triggers to upload a Xlsx file to import, or upload an image to insert.
FileUploadEvent(String, String, Range, Set<Range>, String, Throwable, Object) - Constructor for class io.keikai.client.api.event.FileUploadEvent
 
Fill - Interface in io.keikai.client.api
A fill interface for Pattern Fill and Gradient Fill
Fill.PatternFill - Interface in io.keikai.client.api
A Pattern Fill
Fill.PatternFill.PatternType - Enum in io.keikai.client.api
 
Filter - Interface in io.keikai.client.api
 
focus() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
focus() - Method in interface io.keikai.client.api.Spreadsheet
Retrieves the UI focus.
Font - Interface in io.keikai.client.api
A font interface
Font.Family - Enum in io.keikai.client.api
Family attributes that can be applied.
Font.Underline - Enum in io.keikai.client.api
Underline attributes that can be applied.
freezePanes() - Method in class io.keikai.client.api.atomic.AtomicRange
 
freezePanes(int, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
freezePanes() - Method in interface io.keikai.client.api.Range
freeze the panes from the given range.
freezePanes(int, int) - Method in interface io.keikai.client.api.Spreadsheet
freezes the panes for this active worksheet.
fromJSON(String, Class<T>) - Static method in class io.keikai.util.Converter
 
Functions - Class in io.keikai.util
A function utilities.
Functions() - Constructor for class io.keikai.util.Functions
 
Functions.ArgumentFunction<T,R,A> - Class in io.keikai.util
 
Functions.ExceptionableConsumer<T> - Interface in io.keikai.util
 
Functions.ExceptionableFunction<T,R> - Interface in io.keikai.util
 

G

get(Settings.Key) - Method in class io.keikai.client.api.Settings
 
getA1Notation() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getA1Notation() - Method in interface io.keikai.client.api.Range
Returns the A1 notation from this range, e.g.
getActiveCell() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getActiveCell() - Method in class io.keikai.client.api.event.RangeSelectEvent
Returns the active cell of this range event.
getActiveCell() - Method in class io.keikai.client.api.event.UICommandEvent
 
getActiveCell() - Method in interface io.keikai.client.api.Spreadsheet
Returns the active cell focus range from the UI client.
getActiveSelection() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getActiveSelection() - Method in class io.keikai.client.api.event.RangeSelectEvent
Returns the active selection of this range event.
getActiveSelection() - Method in interface io.keikai.client.api.Spreadsheet
Returns the active selection range from the UI client.
getAddress() - Method in class io.keikai.client.api.event.CellHyperlinkEvent
Returns the link address.
getAddress() - Method in interface io.keikai.client.api.Hyperlink
Returns the address of the target document.
getAlertStyle() - Method in interface io.keikai.client.api.DataValidation
Returns the alert style.
getAlignment() - Method in interface io.keikai.client.api.CellStyle
Returns the alignment
getAPIKey() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getAPIKey() - Method in interface io.keikai.client.api.Spreadsheet
Returns the API key
getAppId() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getAppId() - Method in interface io.keikai.client.api.Spreadsheet
Returns the id of the unique keikai's Application that the spreadsheet belongs to.
getArgument() - Method in class io.keikai.util.Functions.ArgumentFunction
 
getAutoFilterRange() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getAutoFilterRange() - Method in interface io.keikai.client.api.Worksheet
Returns a range in which auto filter applied.
getBackgroundColor() - Method in interface io.keikai.client.api.Fill.PatternFill
Returns the background color in hex code, e.g.
getBookName() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getBookName() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getBookName() - Method in class io.keikai.client.api.event.ShapeEvent
Returns book name
getBookName() - Method in class io.keikai.client.api.event.SheetEvent
Returns the workbook name that belongs to this event.
getBookName() - Method in interface io.keikai.client.api.Shape
Returns the book name
getBookName() - Method in interface io.keikai.client.api.Spreadsheet
Returns the book name of the active workbook from the remote server.
getBookName() - Method in interface io.keikai.client.api.Worksheet
Returns the workbook name
getBooleanValue() - Method in interface io.keikai.client.api.CellValue
Returns the boolean value of this cell.
getBorder(Borders.BorderIndex) - Method in interface io.keikai.client.api.Borders
Returns the border from the given border index.
getBorder(Borders.BorderIndex) - Method in interface io.keikai.client.api.CellStyle
Returns the single border from the given border index.
getBorderIndices() - Method in interface io.keikai.client.api.Borders
Returns the specified border indices.
getBorders() - Method in interface io.keikai.client.api.CellStyle
Returns the borders collection.
getBottom() - Method in class io.keikai.util.Ref
 
getButton(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getButton() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns a Number, representing which mouse button that was pressed when the mouse event occurred.
getButton() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns a Number, representing which mouse button that was pressed when the mouse event occurred.
getButton(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control button of the given name.
getButtons() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getButtons() - Method in interface io.keikai.client.api.Worksheet
Returns all control buttons
getBy(String) - Static method in enum io.keikai.client.api.ui.UICommand
 
getCause() - Method in class io.keikai.client.api.event.FileUploadEvent
Returns the error cause, if any.
getCell(int, int) - Method in class io.keikai.client.api.atomic.AtomicRange
 
getCell(int, int) - Method in interface io.keikai.client.api.Range
Returns the range from the cell position.
getCellEditEvent(String, Spreadsheet, JSONObject) - Static method in class io.keikai.client.api.event.CellEditEvent
 
getCellHyperlinkEvent(String, Spreadsheet, JSONObject) - Static method in class io.keikai.client.api.event.CellHyperlinkEvent
 
getCellLink() - Method in interface io.keikai.client.api.ctrl.Dropdown
Returns the range of the cell link.
getCellLink() - Method in interface io.keikai.client.api.ctrl.Listbox
Returns the range of the cell link.
getCellLink() - Method in interface io.keikai.client.api.ctrl.Scrollbar
Returns the range of the cell link.
getCellLink() - Method in interface io.keikai.client.api.ctrl.Spinner
Returns the range of the cell link.
getCellLink() - Method in class io.keikai.client.api.event.ShapeChangeEvent
Returns the range of the cell link.
getCellLink() - Method in class io.keikai.client.api.event.ShapeSelectEvent
Returns the range of the cell link.
getCellMouseEvent(String, Spreadsheet, JSONObject) - Static method in class io.keikai.client.api.event.CellMouseEvent
 
getCellStyle() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getCellStyle() - Method in interface io.keikai.client.api.Range
Returns the cell style.
getCellValue() - Method in interface io.keikai.client.api.RangeValue
Returns the cell value from this range.
getCharset() - Method in interface io.keikai.client.api.Font
Returns the charset
getCheckbox(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getCheckbox(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control checkbox of the given name.
getColor() - Method in interface io.keikai.client.api.Border
Returns the border color.
getColor() - Method in interface io.keikai.client.api.Borders
 
getColor() - Method in interface io.keikai.client.api.Font
Returns the color
getColorIndex() - Method in interface io.keikai.client.api.Border
Returns the border color index.
getColorIndex() - Method in interface io.keikai.client.api.Borders
 
getColumn() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getColumn() - Method in class io.keikai.client.api.event.RangeEvent
Returns the column position in the first range.
getColumn() - Method in interface io.keikai.client.api.Range
Returns the left-most column index of this range, 0-based.
getColumn() - Method in class io.keikai.client.api.RangeAnchor
Return the index of the column.
getColumnCount() - Method in class io.keikai.util.Ref
 
getColumnIndex() - Method in interface io.keikai.client.api.RangeValue
Returns the column index from this range.
getColumnOffset() - Method in class io.keikai.client.api.RangeAnchor
Returns the offset of the column.
getColumns() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getColumns(int) - Method in class io.keikai.client.api.atomic.AtomicRange
 
getColumns() - Method in interface io.keikai.client.api.Range
Return the column part of this range.
getColumns(int) - Method in interface io.keikai.client.api.Range
Returns a Range that is n-th column(0-based) related to the first area of this range and in the range.
getColumnWidth() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getColumnWidth() - Method in interface io.keikai.client.api.Range
Returns the column width of this range in character unit width.
getColumnWidthPx() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getColumnWidthPx() - Method in interface io.keikai.client.api.Range
Returns the column width of this range in pixels.
getCommand() - Method in class io.keikai.client.api.event.UICommandEvent
 
getCommand() - Method in enum io.keikai.client.api.ui.UICommand
 
getCount() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getCount() - Method in interface io.keikai.client.api.Range
Returns the count of cells of this range.
getCount() - Method in class io.keikai.util.Ref
 
getCriteria1() - Method in interface io.keikai.client.api.Filter
Returns the first filtered value for the column in this filter.
getCriteria2() - Method in interface io.keikai.client.api.Filter
Returns the second filtered value for the column in this filter.
getData() - Method in class io.keikai.client.api.event.RangeEvent
Returns the event data, if any.
getDataRegion() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getDataRegion() - Method in interface io.keikai.client.api.Worksheet
Returns the region which contains data(including all shapes, charts, pictures, and fills) in this sheet; return null if empty sheet.
getDataValidation() - Method in interface io.keikai.client.api.DataValidationValue
Returns the data validation.
getDataValidations() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getDataValidations() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getDataValidations() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getDataValidations() - Method in interface io.keikai.client.api.Range
Returns the data validations.
getDataValidations() - Method in interface io.keikai.client.api.Spreadsheet
Returns the data validations of the active worksheet from the remote server.
getDataValidations() - Method in interface io.keikai.client.api.Worksheet
Returns the data validations of this worksheet from the remote data server.
getDateValue() - Method in interface io.keikai.client.api.CellValue
Returns the date value of this cell.
getDoubleValue() - Method in interface io.keikai.client.api.CellValue
Returns the double value of this cell.
getDropdown(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getDropdown(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control dropdown of the given name.
getEntireColumn() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getEntireColumn() - Method in interface io.keikai.client.api.Range
Returns a Range that represents the entire column (or columns) that contains this range.
getEntireRow() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getEntireRow() - Method in interface io.keikai.client.api.Range
Returns a Range that represents the entire row (or rows) that contains this range.
getErrorMessage() - Method in interface io.keikai.client.api.DataValidation
Returns the error message.
getErrorTitle() - Method in interface io.keikai.client.api.DataValidation
Returns the title of the data validation error dialog box.
getExcelDate(Date) - Static method in class io.keikai.util.DateUtil
Given a Date, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900.
getExcelDate(Date, boolean) - Static method in class io.keikai.util.DateUtil
Given a Date, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900.
getExcelDate(Calendar, boolean) - Static method in class io.keikai.util.DateUtil
Given a Date in the form of a Calendar, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900.
getFamily() - Method in interface io.keikai.client.api.Font
Returns the family
getFile() - Method in class io.keikai.client.api.event.FileUploadEvent
Returns the file.
getFileName() - Method in class io.keikai.client.api.event.FileUploadEvent
Returns the file name
getFileUploadEvent(String, Spreadsheet, Map) - Static method in class io.keikai.client.api.event.FileUploadEvent
 
getFill() - Method in interface io.keikai.client.api.CellStyle
Returns the fill
getFilter(int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getFilter(int) - Method in interface io.keikai.client.api.Worksheet
Returns the filter in specified column.
getFirstColumn(int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getFirstColumn(int) - Method in interface io.keikai.client.api.Worksheet
Returns the first column of row which contains data
getFirstRow() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getFirstRow() - Method in interface io.keikai.client.api.Worksheet
Returns the first row which contains data of this sheet
getFont() - Method in interface io.keikai.client.api.CellStyle
Returns the font
getForegroundColor() - Method in interface io.keikai.client.api.Fill.PatternFill
Returns the foreground color in hex code, e.g.
getFormat() - Method in interface io.keikai.client.api.CellValue
Returns the format of this cell.
getFormat() - Method in interface io.keikai.client.api.NumberFormat
Returns the format
getFormattedText() - Method in interface io.keikai.client.api.CellValue
Returns the formatted text of this cell after being applied the number format.
getFormula() - Method in interface io.keikai.client.api.CellValue
Returns the formula of this cell or null if it contains no formula.
getFormula() - Method in interface io.keikai.client.api.RangeValue
Returns the formula value from this range, e.g.
getFormula1() - Method in interface io.keikai.client.api.DataValidation
Returns the formula1 expression.
getFormula2() - Method in interface io.keikai.client.api.DataValidation
Returns the formula2 expression.
getGroupbox(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getGroupbox() - Method in interface io.keikai.client.api.ctrl.OptionButton
Returns the groupbox which the option button belongs to, or null if not exists.
getGroupbox(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control groupbox of the given name.
getHorizontal() - Method in interface io.keikai.client.api.Alignment
Returns the horizontal alignment
getHyperlink() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getHyperlink() - Method in interface io.keikai.client.api.Range
Returns the hyperlink.
getIndent() - Method in interface io.keikai.client.api.Alignment
Returns the indent
getIndex() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getIndex() - Method in interface io.keikai.client.api.Shape
Returns the index of this shape.
getIndex() - Method in interface io.keikai.client.api.Worksheet
Returns the sheet index.
getInputMessage() - Method in interface io.keikai.client.api.DataValidation
Returns the input message.
getInputRange() - Method in interface io.keikai.client.api.ctrl.Dropdown
Returns the input range in which the data loaded from, if any.
getInputRange() - Method in interface io.keikai.client.api.ctrl.Listbox
Returns the input range in which the data loaded from, if any.
getInputRange() - Method in class io.keikai.client.api.event.ShapeSelectEvent
Returns the input range in which the data loaded from, if any.
getInputTitle() - Method in interface io.keikai.client.api.DataValidation
Returns the title of the data validation input dialog box.
getJavaCalendar(double, boolean) - Static method in class io.keikai.util.DateUtil
Get EXCEL date as Java Calendar (with default time zone).
getJavaCalendar(double, boolean, TimeZone) - Static method in class io.keikai.util.DateUtil
Get EXCEL date as Java Calendar with given time zone.
getJavaCalendarUTC(double, boolean) - Static method in class io.keikai.util.DateUtil
Get EXCEL date as Java Calendar with UTC time zone.
getJavaDate(double, TimeZone) - Static method in class io.keikai.util.DateUtil
Given an Excel date with using 1900 date windowing, and converts it to a java.util.Date.
getJavaDate(double) - Static method in class io.keikai.util.DateUtil
Given an Excel date with using 1900 date windowing, and converts it to a java.util.Date.
getJavaDate(double, boolean, TimeZone) - Static method in class io.keikai.util.DateUtil
Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.util.Date.
getJavaDate(double, boolean) - Static method in class io.keikai.util.DateUtil
Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.util.Date.
getKeyCode() - Method in class io.keikai.client.api.event.RangeKeyEvent
Returns the keyCode;
getLastColumn() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getLastColumn(int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getLastColumn() - Method in class io.keikai.client.api.event.RangeEvent
Returns the last column position in the first range.
getLastColumn() - Method in interface io.keikai.client.api.Range
Returns the right-most column index of this range, 0-based.
getLastColumn() - Method in class io.keikai.client.api.RangeAnchor
Returns the index of the last column.
getLastColumn(int) - Method in interface io.keikai.client.api.Worksheet
Returns the last column of row which contains data
getLastColumnOffset() - Method in class io.keikai.client.api.RangeAnchor
Returns the offset of the last column.
getLastRow() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getLastRow() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getLastRow() - Method in class io.keikai.client.api.event.RangeEvent
Returns the last row position in the first range.
getLastRow() - Method in interface io.keikai.client.api.Range
Returns the bottom row index of this range, 0-based.
getLastRow() - Method in class io.keikai.client.api.RangeAnchor
Returns the index of the last row.
getLastRow() - Method in interface io.keikai.client.api.Worksheet
Returns the last row which contains data of this sheet
getLastRowOffset() - Method in class io.keikai.client.api.RangeAnchor
Returns the offset of the last row.
getLeft() - Method in class io.keikai.util.Ref
 
getListbox(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getListbox(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control listbox of the given name.
getMax() - Method in interface io.keikai.client.api.ctrl.Scrollbar
Returns the maximum value of this scrollbar.
getMax() - Method in interface io.keikai.client.api.ctrl.Spinner
Returns the maximum value of this spinner.
getMax() - Method in class io.keikai.client.api.event.ShapeChangeEvent
Returns the maximum value of this event target
getMeta(Object) - Static method in class io.keikai.client.api.Keikai
Returns the value in the global meta from the given key.
getMin() - Method in interface io.keikai.client.api.ctrl.Scrollbar
Returns the minimum value of this scrollbar.
getMin() - Method in interface io.keikai.client.api.ctrl.Spinner
Returns the minimum value of this spinner.
getMin() - Method in class io.keikai.client.api.event.ShapeChangeEvent
Returns the minimum value of this event target
getName() - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getName() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getName() - Method in class io.keikai.client.api.event.RangeEvent
Returns the event name.
getName() - Method in interface io.keikai.client.api.Font
Returns the name
getName() - Method in interface io.keikai.client.api.Shape
Returns the name of this shape.
getName() - Method in interface io.keikai.client.api.Workbook
Returns the name of this workbook.
getName() - Method in interface io.keikai.client.api.Worksheet
Returns the sheet name.
getNumberFormat() - Method in interface io.keikai.client.api.CellStyle
Returns the number format.
getOperator() - Method in interface io.keikai.client.api.DataValidation
Returns the data validation operator
getOperator() - Method in interface io.keikai.client.api.Filter
Returns a value that represents the operator that associates the two criteria applied by this filter.
getOptionButton(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getOptionButton(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control option button of the given name.
getPageSize() - Method in interface io.keikai.client.api.ctrl.Scrollbar
Returns the number of steps per page of this scrollbar for incrementing and decrementing the page change.
getPageSize() - Method in class io.keikai.client.api.event.ShapeChangeEvent
Returns the page size of this event target for incrementing and decrementing the page change.
getPageX() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the horizontal coordinate of the mouse pointer relative to the whole document.
getPageX() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns the horizontal coordinate of the mouse pointer relative to the whole document.
getPageY() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the vertical coordinate of the mouse pointer relative to the whole document.
getPageY() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns the vertical coordinate of the mouse pointer relative to the whole document.
getPassword() - Method in class io.keikai.client.api.SheetProtection
Returns the password.
getPatternType() - Method in interface io.keikai.client.api.Fill.PatternFill
Returns pattern type.
getProtection() - Method in interface io.keikai.client.api.CellStyle
Returns the protection.
getRange(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(String, String, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(String, int, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(int, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(String, String, int, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(String, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(int, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(String, String, int, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(String, int, int, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRange(String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(String, String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(int, String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(int, int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(String, int, int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(int, int, int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(int, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(String, int, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(int, int, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getRange(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getRange(int, int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getRange(int, int, int, int) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getRange() - Method in interface io.keikai.client.api.DataValidationValue
Returns the range associated to this data validation.
getRange() - Method in class io.keikai.client.api.event.RangeEvent
Returns the first range, if any.
getRange(String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given A1 notation or R1C1 notation from the active worksheet of the active workbook.
getRange(String, String, String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given A1 notation or R1C1 notation from the given book name with the given sheet name or id.
getRange(String, int, String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given A1 notation or R1C1 notation from the given book name with the given sheet index.
getRange(int, int) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given row and column for the active worksheet of the active workbook.
getRange(String, String, int, int) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given row and column from the given book name and sheet name or id.
getRange(String, int, int, int) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given row and column from the given book name and sheet index.
getRange(int, int, int, int) - Method in interface io.keikai.client.api.Spreadsheet
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.
getRange(String, String, int, int, int, int) - Method in interface io.keikai.client.api.Spreadsheet
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.
getRange(String, int, int, int, int, int) - Method in interface io.keikai.client.api.Spreadsheet
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.
getRange(String) - Method in interface io.keikai.client.api.Workbook
Returns the range with the given A1 notation or R1C1 notation from the active worksheet.
getRange(String, String) - Method in interface io.keikai.client.api.Workbook
Returns the range with the given A1 notation or R1C1 notation from the given sheet name or id.
getRange(int, String) - Method in interface io.keikai.client.api.Workbook
Returns the range with the given A1 notation or R1C1 notation from the given sheet index.
getRange(int, int) - Method in interface io.keikai.client.api.Workbook
Returns the range with the given row and column from the active worksheet.
getRange(String, int, int) - Method in interface io.keikai.client.api.Workbook
Returns the range with the given row and column from the given sheet name or id.
getRange(int, int, int) - Method in interface io.keikai.client.api.Workbook
Returns the range with the given row and column from the given sheet index.
getRange(int, int, int, int) - Method in interface io.keikai.client.api.Workbook
Returns the range with the given row and column with the given number of the rows and columns from the active worksheet.
getRange(String, int, int, int, int) - Method in interface io.keikai.client.api.Workbook
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.
getRange(int, int, int, int, int) - Method in interface io.keikai.client.api.Workbook
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.
getRange(String) - Method in interface io.keikai.client.api.Worksheet
Returns the range with the given A1 notation or R1C1 notation.
getRange(int, int) - Method in interface io.keikai.client.api.Worksheet
Returns the range with the given row and column.
getRange(int, int, int, int) - Method in interface io.keikai.client.api.Worksheet
Returns the range with the given row and column with the given number of the rows and columns
getRangeByName(String, String, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRangeByName(String, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRangeByName(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getRangeByName(String, String, String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given name from the given book name with the given sheet name or id.
getRangeByName(String, String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given name from the active book with the given sheet name or id.
getRangeByName(String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the range with the given name from the active worksheet.
getRangeEvent(String, Spreadsheet, String) - Static method in class io.keikai.client.api.event.RangeEvent
 
getRangeEvent(String, Spreadsheet, String, Object) - Static method in class io.keikai.client.api.event.RangeEvent
 
getRangeKeyEvent(String, Spreadsheet, Map) - Static method in class io.keikai.client.api.event.RangeKeyEvent
 
getRanges() - Method in class io.keikai.client.api.event.RangeEvent
 
getRangeSelectEvent(String, Spreadsheet, Map) - Static method in class io.keikai.client.api.event.RangeSelectEvent
 
getRangeValue() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRangeValue() - Method in interface io.keikai.client.api.Range
Returns the first range value from this range.
getRangeValues() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRangeValues() - Method in interface io.keikai.client.api.Range
Returns the range values from this range as a List.
getRangeValuesMatrix() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRangeValuesMatrix() - Method in interface io.keikai.client.api.Range
Returns the range values from this range as a matrix(List of List, rows then columns).
getReadingOrder() - Method in interface io.keikai.client.api.Alignment
Returns the reading order.
getRegionRangeValuesMatrix() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRegionRangeValuesMatrix() - Method in interface io.keikai.client.api.Range
Returns the range values from the region, the minimum outline area that contains this range, as a matrix(List of List, rows then columns)
getRegionValuesMatrix() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRegionValuesMatrix() - Method in interface io.keikai.client.api.Range
Returns the values from the region, the minimum outline area that contains this range, as a matrix(List of List, rows then columns).
getRelativeIndent() - Method in interface io.keikai.client.api.Alignment
Returns the relative indent.
getRight() - Method in class io.keikai.util.Ref
 
getRow() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRow() - Method in class io.keikai.client.api.event.RangeEvent
Returns the row position in the first range.
getRow() - Method in interface io.keikai.client.api.Range
Returns the top row index of this range, 0-based.
getRow() - Method in class io.keikai.client.api.RangeAnchor
Returns the index of the row.
getRowCount() - Method in class io.keikai.util.Ref
 
getRowHeight() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRowHeight() - Method in interface io.keikai.client.api.Range
Returns the row height of this range in character unit height.
getRowHeightPx() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRowHeightPx() - Method in interface io.keikai.client.api.Range
Returns the row height of this range in pixels.
getRowIndex() - Method in interface io.keikai.client.api.RangeValue
Returns the row index from this range.
getRowOffset() - Method in class io.keikai.client.api.RangeAnchor
Returns the offset of the row.
getRows() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRows(int) - Method in class io.keikai.client.api.atomic.AtomicRange
 
getRows() - Method in interface io.keikai.client.api.Range
Returns the row port of this range.
getRows(int) - Method in interface io.keikai.client.api.Range
Returns a Range that is n-th row(0-based) related to the first area of this range and in the range.
getScheme() - Method in interface io.keikai.client.api.Font
Returns the scheme
getScrollbar(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getScrollbar(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control scrollbar of the given name.
getSecureURI(HttpServletRequest, HttpServletResponse, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getSecureURI(HttpServletRequest, HttpServletResponse, String, boolean) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getSecureURI(HttpServletRequest, HttpServletResponse, String) - Method in interface io.keikai.client.api.Spreadsheet
Return the remote secure access URI for this client.
getSecureURI(HttpServletRequest, HttpServletResponse, String, boolean) - Method in interface io.keikai.client.api.Spreadsheet
Return the remote secure access URI for this client.
getSelectedIndex() - Method in interface io.keikai.client.api.ctrl.Dropdown
Returns the selected index
getSelectedIndexes() - Method in interface io.keikai.client.api.ctrl.Listbox
Returns the selected indexes
getSelectedItem() - Method in interface io.keikai.client.api.ctrl.Dropdown
Returns the selected item
getSelectedItems() - Method in interface io.keikai.client.api.ctrl.Listbox
Returns the selected items
getSettings() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getSettings() - Method in interface io.keikai.client.api.Spreadsheet
Returns the settings of this spreadsheet
getShapeChangeEvent(String, Spreadsheet, JSONObject) - Static method in class io.keikai.client.api.event.ShapeChangeEvent
 
getShapeId() - Method in class io.keikai.client.api.event.ShapeEvent
Returns shapeId
getShapeId() - Method in interface io.keikai.client.api.Shape
Returns the shapeId of this shape.
getShapeMouseEvent(String, Spreadsheet, JSONObject) - Static method in class io.keikai.client.api.event.ShapeMouseEvent
 
getShapeSelectEvent(String, Spreadsheet, JSONObject) - Static method in class io.keikai.client.api.event.ShapeSelectEvent
 
getSheetCount() - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getSheetCount() - Method in interface io.keikai.client.api.Workbook
Returns the count of the worksheets in this workbook.
getSheetEvent(String, Spreadsheet, JSONObject) - Static method in class io.keikai.client.api.event.SheetEvent
 
getSheetId() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getSheetId() - Method in class io.keikai.client.api.event.ShapeEvent
Returns sheet id
getSheetId() - Method in interface io.keikai.client.api.Shape
Returns the sheet id
getSheetId() - Method in interface io.keikai.client.api.Worksheet
Returns the uuid of this worksheet.
getSheetName() - Method in class io.keikai.client.api.event.SheetEvent
Returns the worksheet name that belongs to this event.
getSheetOrder() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getSheetOrder() - Method in interface io.keikai.client.api.Range
Returns the sheet index of this range.
getSiblingSheetId() - Method in class io.keikai.client.api.event.SheetEvent
Returns the siblingSheetId
getSize() - Method in interface io.keikai.client.api.Borders
Returns the size of the specified borders.
getSize() - Method in interface io.keikai.client.api.Font
Returns the size
getSpinner(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getSpinner(String) - Method in interface io.keikai.client.api.Worksheet
Returns the control spinner of the given name.
getSplitColumn() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getSplitColumn() - Method in interface io.keikai.client.api.Worksheet
Returns the number of the frozen columns.
getSplitRow() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getSplitRow() - Method in interface io.keikai.client.api.Worksheet
Returns the number of the frozen rows.
getSpreadsheet() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getSpreadsheet() - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getSpreadsheet() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getSpreadsheet() - Method in interface io.keikai.client.api.Range
Returns the spreadsheet.
getSpreadsheet() - Method in interface io.keikai.client.api.Workbook
Returns the spreadsheet client which holds this workbook.
getSpreadsheet() - Method in interface io.keikai.client.api.Worksheet
Returns the spreadsheet which holds this worksheet.
getStep() - Method in interface io.keikai.client.api.ctrl.Scrollbar
Returns the step value of this scrollbar for incrementing and decrementing change.
getStep() - Method in interface io.keikai.client.api.ctrl.Spinner
Returns the step value of this spinner for incrementing and decrementing change.
getStep() - Method in class io.keikai.client.api.event.ShapeChangeEvent
Returns the step value of this event target for incrementing and decrementing change.
getStringValue() - Method in interface io.keikai.client.api.CellValue
Returns the string value of this cell.
getStyle() - Method in interface io.keikai.client.api.Border
Returns the border style.
getStyle() - Method in interface io.keikai.client.api.Borders
 
getTarget() - Method in class io.keikai.client.api.event.ShapeEvent
Returns the shape target
getTargetHeight() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the height of the target cell.
getTargetHeight() - Method in class io.keikai.client.api.event.ShapeEvent
Returns the height of the target cell.
getTargetWidth() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the width of the target cell.
getTargetWidth() - Method in class io.keikai.client.api.event.ShapeEvent
Returns the width of the target cell.
getTargetX() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the horizontal coordinate of the target cell relevant to the whole document.
getTargetX() - Method in class io.keikai.client.api.event.ShapeEvent
Returns the horizontal coordinate of the target cell relevant to the whole document.
getTargetY() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the vertical coordinate of the target cell relevant to the whole document.
getTargetY() - Method in class io.keikai.client.api.event.ShapeEvent
Returns the vertical coordinate of the target cell relevant to the whole document.
getText() - Method in interface io.keikai.client.api.ctrl.Button
Returns the text of this button.
getText() - Method in interface io.keikai.client.api.ctrl.Checkbox
Returns the text of this checkbox.
getText() - Method in interface io.keikai.client.api.ctrl.Groupbox
Returns the text of this Groupbox.
getText() - Method in interface io.keikai.client.api.ctrl.OptionButton
Returns the text of this option button.
getText() - Method in class io.keikai.client.api.event.CellEditEvent
Returns the text of the editing.
getTextRotation() - Method in interface io.keikai.client.api.Alignment
Returns the text rotation
getTextToDisplay() - Method in interface io.keikai.client.api.Hyperlink
Returns the text to be displayed for this hyperlink.
getThemeColor() - Method in interface io.keikai.client.api.Border
Returns the border theme color.
getThemeColor() - Method in interface io.keikai.client.api.Borders
 
getTooltip() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getTooltip() - Method in interface io.keikai.client.api.Worksheet
Returns tooltip text of the sheet tab UI.
getTop() - Method in class io.keikai.util.Ref
 
getType() - Method in interface io.keikai.client.api.DataValidation
Returns the data validation type
getType() - Method in class io.keikai.client.api.event.CellHyperlinkEvent
Returns the link type
getType() - Method in interface io.keikai.client.api.Hyperlink
Returns the hyperlink type.
getUICommandEvent(String, Spreadsheet, Map) - Static method in class io.keikai.client.api.event.UICommandEvent
 
getUIService() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getUIService() - Method in interface io.keikai.client.api.Spreadsheet
Returns a UI service control.
getUnderline() - Method in interface io.keikai.client.api.Font
Returns the underline
getURI(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getURI(String, boolean) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getURI(String) - Method in interface io.keikai.client.api.Spreadsheet
Return the remote access URI for this client.
getURI(String, boolean) - Method in interface io.keikai.client.api.Spreadsheet
Return the remote access URI for this client.
getValidator() - Method in interface io.keikai.client.api.DataValidation
Returns the data validator hook.
getValue() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getValue() - Method in interface io.keikai.client.api.CellValue
Returns the raw value, the value before applying a cell's number format, of this cell.
If you enter 123 into a cell, this method returns 123.
getValue() - Method in interface io.keikai.client.api.ctrl.Scrollbar
Returns the value of this scrollbar.
getValue() - Method in interface io.keikai.client.api.ctrl.Spinner
Returns the value of this spinner.
getValue() - Method in class io.keikai.client.api.event.ShapeChangeEvent
Returns the value of this event target
getValue() - Method in interface io.keikai.client.api.Range
Returns the first value from this range.
getValue() - Method in interface io.keikai.client.api.RangeValue
Returns the raw value from this range.
getValues() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getValues() - Method in interface io.keikai.client.api.Range
Returns the values from this range as a List.
getValuesMatrix() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getValuesMatrix() - Method in interface io.keikai.client.api.Range
Returns the values from this range as a matrix(List of List, rows then columns).
getVertical() - Method in interface io.keikai.client.api.Alignment
Returns the vertical alignment
getVisible() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getVisible() - Method in class io.keikai.client.api.event.SheetEvent
Returns the visibility of this worksheet that belongs to this event.
getVisible() - Method in interface io.keikai.client.api.Worksheet
Returns the visibility of this sheet.
getVisibleArea() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getVisibleArea() - Method in interface io.keikai.client.api.Worksheet
Returns the visible area.
getWinId() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWinId() - Method in interface io.keikai.client.api.Spreadsheet
Returns the id of the window view in the keikai's Application.
getWorkbook() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getWorkbook() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWorkbook(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWorkbook() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
getWorkbook() - Method in interface io.keikai.client.api.Range
Returns the workbook which holds this range.
getWorkbook() - Method in interface io.keikai.client.api.Spreadsheet
Returns the active workbook from the remote server.
getWorkbook(String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the workbook by the given name from the remote server.
getWorkbook() - Method in interface io.keikai.client.api.Worksheet
Returns the workbook which holds this worksheet.
getWorksheet() - Method in class io.keikai.client.api.atomic.AtomicRange
 
getWorksheet() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWorksheet(String, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWorksheet(String, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
getWorksheet() - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
getWorksheet() - Method in class io.keikai.client.api.event.RangeEvent
Returns the remote worksheet in the first range.
getWorksheet() - Method in class io.keikai.client.api.event.SheetEvent
Returns the worksheet that belongs to this event
getWorksheet() - Method in interface io.keikai.client.api.Range
Returns the worksheet which holds this range.
getWorksheet() - Method in interface io.keikai.client.api.Spreadsheet
Returns the active worksheet of the active workbook from the remote server.
getWorksheet(int) - Method in interface io.keikai.client.api.Spreadsheet
Returns the worksheet of the active workbook by the given sheet index from the remote server.
getWorksheet(String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the worksheet of the active workbook by the given sheet name or id from the remote server.
getWorksheet(String, String) - Method in interface io.keikai.client.api.Spreadsheet
Returns the worksheet of the given book name with the given sheet name or id from the remote server.
getWorksheet(String, int) - Method in interface io.keikai.client.api.Spreadsheet
Returns the worksheet of the given book name with the given sheet index from the remote server.
getWorksheet() - Method in interface io.keikai.client.api.Workbook
Returns the active worksheet from the remote server.
getWorksheet(int) - Method in interface io.keikai.client.api.Workbook
Returns the worksheet by the given index from the remote server.
getWorksheet(String) - Method in interface io.keikai.client.api.Workbook
Returns the worksheet by the given name from the remote server.
getX() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the horizontal coordinate of the mouse pointer relevant to the spreadsheet.
getX() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns the horizontal coordinate of the mouse pointer relevant to the spreadsheet.
getY() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns the vertical coordinate of the mouse pointer relevant to the spreadsheet.
getY() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns the vertical coordinate of the mouse pointer relevant to the spreadsheet.
Groupbox - Interface in io.keikai.client.api.ctrl
Form control groupbox

H

HOURS_PER_DAY - Static variable in class io.keikai.util.DateUtil
 
Hyperlink - Interface in io.keikai.client.api
Hyperlink for a worksheet
Hyperlink.HyperlinkType - Enum in io.keikai.client.api
HyperlinkType attributes, that can be applied.

I

importAndReplace(String, InputStream) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
importAndReplace(String, File) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
importAndReplace(String, URL) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
importAndReplace(String, InputStream) - Method in interface io.keikai.client.api.Spreadsheet
Imports and replaces with the given workbook to the spreadsheet.
importAndReplace(String, File) - Method in interface io.keikai.client.api.Spreadsheet
Imports and replaces with the given workbook to the spreadsheet.
importAndReplace(String, URL) - Method in interface io.keikai.client.api.Spreadsheet
Imports and replaces with the given workbook to the spreadsheet * This method will delete the previous workbook at remote server.
imports(String, InputStream) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
imports(String, File) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
imports(String, URL) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
imports(String, InputStream) - Method in interface io.keikai.client.api.Spreadsheet
Imports the given workbook to the spreadsheet.
imports(String, File) - Method in interface io.keikai.client.api.Spreadsheet
Imports the given workbook to the spreadsheet.
imports(String, URL) - Method in interface io.keikai.client.api.Spreadsheet
Imports the given workbook to the spreadsheet.
insert(Range.InsertShiftDirection, Range.InsertFormatOrigin) - Method in class io.keikai.client.api.atomic.AtomicRange
 
insert(Range.InsertShiftDirection, Range.InsertFormatOrigin) - Method in interface io.keikai.client.api.Range
Insert cells to the range
insertWorksheet() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
insertWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
insertWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
insertWorksheet() - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
insertWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
insertWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
insertWorksheet() - Method in interface io.keikai.client.api.Spreadsheet
Inserts a new sheet before the active sheet in the active workbook, with a default name.
insertWorksheet(String) - Method in interface io.keikai.client.api.Spreadsheet
Inserts a new sheet before the active sheet in the active workbook, with a given name.
insertWorksheet(int) - Method in interface io.keikai.client.api.Spreadsheet
Inserts a new sheet at the given index in the active workbook, with a default name.
insertWorksheet() - Method in interface io.keikai.client.api.Workbook
Inserts a new sheet in the workbook, with a default name.
insertWorksheet(String) - Method in interface io.keikai.client.api.Workbook
Inserts a new sheet in the workbook, with a given name.
insertWorksheet(int) - Method in interface io.keikai.client.api.Workbook
Inserts a new sheet in the workbook at the given index, with a default name.
io.keikai.client - package io.keikai.client
 
io.keikai.client.api - package io.keikai.client.api
 
io.keikai.client.api.atomic - package io.keikai.client.api.atomic
 
io.keikai.client.api.ctrl - package io.keikai.client.api.ctrl
 
io.keikai.client.api.event - package io.keikai.client.api.event
 
io.keikai.client.api.ui - package io.keikai.client.api.ui
 
io.keikai.util - package io.keikai.util
 
isADateFormat(int, String) - Static method in class io.keikai.util.DateUtil
Given a format ID and its format String, will check to see if the format represents a date format or not.
isAllowDeletingColumns() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to delete columns on the protected sheet.
isAllowDeletingRows() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to delete rows on the protected sheet.
isAllowFiltering() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to set filters on the protected sheet.
isAllowFormattingCells() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to format any cell on the protected sheet.
isAllowFormattingColumns() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to format any columns on the protected sheet.
isAllowFormattingRows() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to format any rows on the protected sheet.
isAllowInsertingColumns() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to insert columns on the protected sheet.
isAllowInsertingHyperlinks() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to insert hyperlinks on the protected sheet.
isAllowInsertingRows() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to insert rows on the protected sheet.
isAllowSelectLockedCells() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow select locked cells.
isAllowSelectUnlockedCells() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow select unlocked cells.
isAllowSorting() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to sort on the protected sheet.
isAllowUsingPivotTables() - Method in class io.keikai.client.api.SheetProtection
Returns whether to allow user to use pivot table reports on the protected sheet.
isAltKey() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns whether the alt key has pressed.
isAltKey() - Method in class io.keikai.client.api.event.RangeKeyEvent
Returns whether the alt key has pressed.
isAltKey() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns whether the alt key has pressed.
isAutoFilterEnabled() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
isAutoFilterEnabled() - Method in interface io.keikai.client.api.Worksheet
 
isBlank() - Method in interface io.keikai.client.api.CellValue
Returns whether it's a blank cell.
isBold() - Method in interface io.keikai.client.api.Font
Returns whether enable the bold or not
isCell() - Method in class io.keikai.util.Ref
 
isChecked() - Method in interface io.keikai.client.api.ctrl.Checkbox
Returns whether the checkbox has checked or not.
isChecked() - Method in interface io.keikai.client.api.ctrl.OptionButton
Returns whether the option button has checked or not.
isClosed() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
isClosed() - Method in interface io.keikai.client.api.Spreadsheet
Returns whether the client is connected or not.
isCondense() - Method in interface io.keikai.client.api.Font
Returns whether enable the condense or not
isCtrlKey() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns whether the ctrl key has pressed.
isCtrlKey() - Method in class io.keikai.client.api.event.RangeKeyEvent
Returns whether the ctrl key has pressed.
isCtrlKey() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns whether the ctrl key has pressed.
isDisplaySheetGridlines() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
isDisplaySheetGridlines() - Method in interface io.keikai.client.api.Spreadsheet
Checks whether enables or disables the display sheet grid lines of the active worksheet.
isDrawingObjects() - Method in class io.keikai.client.api.SheetProtection
Returns whether to protect objects.
isError() - Method in interface io.keikai.client.api.CellValue
Returns whether it's an error value.
isExtend() - Method in interface io.keikai.client.api.Font
Returns whether enable the extend or not
isFormula() - Method in interface io.keikai.client.api.CellValue
Returns whether it's a formula cell.
isHidden() - Method in class io.keikai.client.api.atomic.AtomicRange
 
isHidden() - Method in interface io.keikai.client.api.Protection
Returns whether is hidden or not.
isHidden() - Method in interface io.keikai.client.api.Range
Returns whether rows/columns is hidden; note this range must be either rows or columns.
isIgnoreBlank() - Method in interface io.keikai.client.api.DataValidation
Returns whether to ignore the blank
isImporting(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
isImporting(String) - Method in interface io.keikai.client.api.Spreadsheet
Returns whether the book name is importing or not.
isInCellDropdown() - Method in interface io.keikai.client.api.DataValidation
Returns whether to display a drop-down list that contains acceptable values
isInternalDateFormat(int) - Static method in class io.keikai.util.DateUtil
Given a format ID this will check whether the format represents an internal excel date format or not.
isItalic() - Method in interface io.keikai.client.api.Font
Returns whether enable the italic or not
isJustifyLastLine() - Method in interface io.keikai.client.api.Alignment
Returns whether enable the justify last line or not
isLocked() - Method in interface io.keikai.client.api.Protection
Returns whether is locked or not.
isMetaKey() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns whether the meta key has pressed.
isMetaKey() - Method in class io.keikai.client.api.event.RangeKeyEvent
Returns whether the meta key has pressed.
isMetaKey() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns whether the meta key has pressed.
isMultiple() - Method in interface io.keikai.client.api.ctrl.Listbox
Returns whether the selection is multiple mode or not.
isNumber() - Method in interface io.keikai.client.api.CellValue
Returns whether it's a number value.
isOn() - Method in interface io.keikai.client.api.Filter
Returns true if this filter is on.
isOutline() - Method in interface io.keikai.client.api.Font
Returns whether enable the outline or not
isProtected() - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
isProtected() - Method in interface io.keikai.client.api.Worksheet
Returns true if the sheet is protected.
isScenarios() - Method in class io.keikai.client.api.SheetProtection
Returns whether to protect scenarios.
isShadow() - Method in interface io.keikai.client.api.Font
Returns whether enable the shadow or not
isShiftKey() - Method in class io.keikai.client.api.event.CellMouseEvent
Returns whether the shift key has pressed.
isShiftKey() - Method in class io.keikai.client.api.event.RangeKeyEvent
Returns whether the shift key has pressed.
isShiftKey() - Method in class io.keikai.client.api.event.ShapeMouseEvent
Returns whether the shift key has pressed.
isShowError() - Method in interface io.keikai.client.api.DataValidation
Returns whether to show the error message message whenever the user enters invalid data.
isShowInput() - Method in interface io.keikai.client.api.DataValidation
Returns whether to show the input message whenever the user selects a cell in the data validation range.
isShrinkToFit() - Method in interface io.keikai.client.api.Alignment
Returns whether enable the shrink to fit
isStrike() - Method in interface io.keikai.client.api.Font
Returns whether enable the strike or not
isSubscript() - Method in interface io.keikai.client.api.Font
Returns whether enable the subscript or not
isSuperscript() - Method in interface io.keikai.client.api.Font
Returns whether enable the superscript or not
isText() - Method in interface io.keikai.client.api.CellValue
Return whether it's a string value.
isUserInterfaceOnly() - Method in class io.keikai.client.api.SheetProtection
Returns whether to forbid user to modify this the through UI.
isValidExcelDate(double) - Static method in class io.keikai.util.DateUtil
Given a double, checks if it is a valid Excel date.
isVisible() - Method in interface io.keikai.client.api.Shape
Returns whether the button is visible or not.
isWrapText() - Method in interface io.keikai.client.api.Alignment
Returns whether enable the wrap text or not

K

Keikai - Class in io.keikai.client.api
Utilities to access Spreadsheet.
Keikai() - Constructor for class io.keikai.client.api.Keikai
 

L

Listbox - Interface in io.keikai.client.api.ctrl
Form control listbox

M

Maps - Class in io.keikai.util
A Map utilities.
Maps() - Constructor for class io.keikai.util.Maps
 
MAX_COL - Static variable in interface io.keikai.client.api.Range
The maximum column size.
MAX_ROW - Static variable in interface io.keikai.client.api.Range
The maximum row size.
merge(boolean) - Method in class io.keikai.client.api.atomic.AtomicRange
 
merge(boolean) - Method in interface io.keikai.client.api.Range
Merges the range
MINUTES_PER_HOUR - Static variable in class io.keikai.util.DateUtil
 

N

newClient(String) - Static method in class io.keikai.client.api.Keikai
Creates a spreadsheet client from the given address
newClient(String, Settings) - Static method in class io.keikai.client.api.Keikai
Creates a spreadsheet client from the given address and settings.
newClient(String, String) - Static method in class io.keikai.client.api.Keikai
Creates a spreadsheet client from the given address and app id.
newClient(String, String, Settings) - Static method in class io.keikai.client.api.Keikai
Create a spreadsheet client from the given address, app id, and settings.
newDataClient(String) - Static method in class io.keikai.client.api.Keikai
Creates a data spreadsheet client from the given address.
newDataClient(String, String, Settings) - Static method in class io.keikai.client.api.Keikai
Create a data spreadsheet client from the given address, app id, and settings.
newHostClient(String) - Static method in class io.keikai.client.api.Keikai
Creates a host spreadsheet client from the given address.
newHostClient(String, String, String, Settings) - Static method in class io.keikai.client.api.Keikai
Creates a host spreadsheet client from the given address, appId, winId, and settings.
NULL_INTEGER - Static variable in class io.keikai.client.api.Settings
The null integer value for current keikai system.
NumberFormat - Interface in io.keikai.client.api
A number format interface
numToAbc(int) - Static method in class io.keikai.util.Converter
Converts 0-based index to abc.

O

ON_CELL_CLICK - Static variable in class io.keikai.client.api.event.Events
 
ON_CELL_DOUBLE_CLICK - Static variable in class io.keikai.client.api.event.Events
 
ON_CELL_MOUSE_ENTER - Static variable in class io.keikai.client.api.event.Events
 
ON_CELL_MOUSE_LEAVE - Static variable in class io.keikai.client.api.event.Events
 
ON_CELL_RIGHT_CLICK - Static variable in class io.keikai.client.api.event.Events
 
ON_CLIENT_UNBIND - Static variable in class io.keikai.client.api.event.Events
 
ON_EDIT_CANCEL - Static variable in class io.keikai.client.api.event.Events
 
ON_EDIT_SAVE - Static variable in class io.keikai.client.api.event.Events
 
ON_EDIT_START - Static variable in class io.keikai.client.api.event.Events
 
ON_EDIT_STOP - Static variable in class io.keikai.client.api.event.Events
 
ON_FILE_UPLOAD - Static variable in class io.keikai.client.api.event.Events
 
ON_HYPERLINK_CLICK - Static variable in class io.keikai.client.api.event.Events
 
ON_KEY_DOWN - Static variable in class io.keikai.client.api.event.Events
 
ON_KEY_PRESS - Static variable in class io.keikai.client.api.event.Events
 
ON_KEY_UP - Static variable in class io.keikai.client.api.event.Events
 
ON_MOVE_FOCUS - Static variable in class io.keikai.client.api.event.Events
 
ON_SELECTION_CHANGE - Static variable in class io.keikai.client.api.event.Events
 
ON_SHAPE_ACTION - Static variable in class io.keikai.client.api.event.Events
 
ON_SHAPE_CLICK - Static variable in class io.keikai.client.api.event.Events
 
ON_SHEET_ACTIVATE - Static variable in class io.keikai.client.api.event.Events
 
ON_SHEET_ADD - Static variable in class io.keikai.client.api.event.Events
 
ON_SHEET_DELETE - Static variable in class io.keikai.client.api.event.Events
 
ON_SHEET_MOVE - Static variable in class io.keikai.client.api.event.Events
 
ON_SHEET_PROTECT - Static variable in class io.keikai.client.api.event.Events
 
ON_SHEET_RENAME - Static variable in class io.keikai.client.api.event.Events
 
ON_SHEET_VISIBLE - Static variable in class io.keikai.client.api.event.Events
 
ON_UI_COMMAND - Static variable in class io.keikai.client.api.event.Events
 
onConnect() - Method in interface io.keikai.client.api.ui.UIActivity
Calls when the UI client has connected.
onDisconnect() - Method in interface io.keikai.client.api.ui.UIActivity
Calls when the UI client had disconnected.
onEvent(T) - Method in interface io.keikai.client.api.event.RangeEventListener
 
OptionButton - Interface in io.keikai.client.api.ctrl
Form control option button

P

parseYYYYMMDDDate(String) - Static method in class io.keikai.util.DateUtil
Converts a string of format "YYYY/MM/DD" to its (Excel) numeric equivalent
pasteSpecial(Range, Range.PasteType, Range.PasteSpecialOperation, boolean, boolean) - Method in class io.keikai.client.api.atomic.AtomicRange
 
pasteSpecial(Range, Range.PasteType, Range.PasteSpecialOperation, boolean, boolean) - Method in interface io.keikai.client.api.Range
Pastes a range to the destination range
protect(String, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
protect(SheetProtection) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
protect(String, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean) - Method in interface io.keikai.client.api.Worksheet
Protects this sheet so that it cannot be modified.
protect(SheetProtection) - Method in interface io.keikai.client.api.Worksheet
Protects this sheet so that it cannot be modified.
Protection - Interface in io.keikai.client.api
A protection object to represents a locked and hidden states for a CellStyle.

R

Range - Interface in io.keikai.client.api
A range can be a single cell or a range of cells in a worksheet.
Range.AutoFillType - Enum in io.keikai.client.api
AutoFillType attributes, that can be applied.
Range.AutoFilterOperator - Enum in io.keikai.client.api
AutoFilterOperator attributes, that can be applied.
Range.DeleteShiftDirection - Enum in io.keikai.client.api
DeleteShiftDirection attributes, that can be applied.
Range.InsertFormatOrigin - Enum in io.keikai.client.api
InsertFormatOrigin attributes, that can be applied.
Range.InsertShiftDirection - Enum in io.keikai.client.api
InsertShiftDirection attributes, that can be applied.
Range.PasteSpecialOperation - Enum in io.keikai.client.api
PasteSpecialOperation attributes, that can be applied.
Range.PasteType - Enum in io.keikai.client.api
PasteType attributes, that can be applied.
Range.SortDataOption - Enum in io.keikai.client.api
SortDataOption attributes, that can be applied.
Range.SortOrder - Enum in io.keikai.client.api
SortOrder attributes, that can be applied.
Range.SortOrientation - Enum in io.keikai.client.api
SortOrientation attributes, that can be applied.
Range.YesNoGuess - Enum in io.keikai.client.api
YesNoGuess attributes, that can be applied.
RangeAnchor - Class in io.keikai.client.api
A range anchor represents a position in a sheet for objects.
RangeAnchor(int, int, int, int) - Constructor for class io.keikai.client.api.RangeAnchor
Constructs a range anchor with given row, column, lastRow, and lastColumn.
RangeAnchor(String) - Constructor for class io.keikai.client.api.RangeAnchor
Constructs a range anchor with given a1Notation.
RangeAnchor(String, int, int, int, int) - Constructor for class io.keikai.client.api.RangeAnchor
Constructs a range anchor with given a1Notation and its offsets.
RangeAnchor(int, int, int, int, int, int, int, int) - Constructor for class io.keikai.client.api.RangeAnchor
Constructs a range anchor with given row, column, lastRow, lastColumn, and its offsets.
RangeEvent - Class in io.keikai.client.api.event
A range event is sent when a user interacts with the UI
RangeEvent(String, Set<Range>, Object) - Constructor for class io.keikai.client.api.event.RangeEvent
 
RangeEventListener<T extends RangeEvent> - Interface in io.keikai.client.api.event
 
RangeKeyEvent - Class in io.keikai.client.api.event
A key event sent when a user press a key on the UI client.
RangeKeyEvent(String, Set<Range>, int, int, Object) - Constructor for class io.keikai.client.api.event.RangeKeyEvent
 
RangeSelectEvent - Class in io.keikai.client.api.event
A selection event sent when a user select a range on the UI client.
RangeSelectEvent(String, Set<Range>, Range, Range, Object) - Constructor for class io.keikai.client.api.event.RangeSelectEvent
 
rangeToA1(int, int) - Static method in class io.keikai.util.Converter
Converts a range to A1 notation.
rangeToRef(int, int) - Static method in class io.keikai.util.Converter
 
RangeValue<T> - Interface in io.keikai.client.api
A range value (Immutable)
Ref - Class in io.keikai.util
Ref is a reference for cell or range with 4 value : top(top row), left(left column), bottom(last row) and right(last column).
refToA1(Ref) - Static method in class io.keikai.util.Converter
 
remove(Settings.Key) - Method in class io.keikai.client.api.Settings
 
remove(UICommand) - Method in class io.keikai.client.api.ui.ToolbarSettings
Remove toolbar button from the toolbar
removeAction(RangeEventListener<? extends ShapeMouseEvent<Button>>) - Method in interface io.keikai.client.api.ctrl.Button
Removes an action for this button.
removeAction(RangeEventListener<? extends ShapeMouseEvent<Checkbox>>) - Method in interface io.keikai.client.api.ctrl.Checkbox
Removes an action for this checkbox.
removeAction(RangeEventListener<? extends ShapeSelectEvent<Dropdown>>) - Method in interface io.keikai.client.api.ctrl.Dropdown
Removes an action for this dropdown.
removeAction(RangeEventListener<? extends ShapeMouseEvent<OptionButton>>) - Method in interface io.keikai.client.api.ctrl.Groupbox
Removes an action for this Groupbox when option button has checked.
removeAction(RangeEventListener<? extends ShapeSelectEvent<Listbox>>) - Method in interface io.keikai.client.api.ctrl.Listbox
Removes an action for this listbox.
removeAction(RangeEventListener<? extends ShapeMouseEvent<OptionButton>>) - Method in interface io.keikai.client.api.ctrl.OptionButton
Removes an action for this option button.
removeAction(RangeEventListener<? extends ShapeChangeEvent<Scrollbar>>) - Method in interface io.keikai.client.api.ctrl.Scrollbar
Removes an action for this scrollbar.
removeAction(RangeEventListener<? extends ShapeChangeEvent<Spinner>>) - Method in interface io.keikai.client.api.ctrl.Spinner
Removes an action for this spinner.
removeButton(Button) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
removeButton(Button) - Method in interface io.keikai.client.api.Worksheet
Remove the control button.
removeEventListener(String, RangeEventListener<? extends RangeEvent>) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
removeEventListener(String, RangeEventListener<? extends RangeEvent>) - Method in interface io.keikai.client.api.Spreadsheet
Removes the event listener
removeExceptionHandler(Consumer<Throwable>) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
removeExceptionHandler(Consumer<Throwable>) - Method in interface io.keikai.client.api.Spreadsheet
Removes the given exception handler from this spreadsheet.
removeMeta(Object) - Static method in class io.keikai.client.api.Keikai
Removes the value in the meta from the given key.
rename(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
rename(String) - Method in interface io.keikai.client.api.Worksheet
Renames the sheet name.

S

Scrollbar - Interface in io.keikai.client.api.ctrl
Form control scrollbar
SECONDS_PER_DAY - Static variable in class io.keikai.util.DateUtil
 
SECONDS_PER_MINUTE - Static variable in class io.keikai.util.DateUtil
 
set(Settings.Key, Object) - Method in class io.keikai.client.api.Settings
 
setActiveWorkbook(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setActiveWorkbook(String) - Method in interface io.keikai.client.api.Spreadsheet
Makes the active workbook from the given name.
setActiveWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setActiveWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setActiveWorksheet(String, String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setActiveWorksheet(String, int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setActiveWorksheet(String) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
setActiveWorksheet(int) - Method in class io.keikai.client.api.atomic.AtomicWorkbook
 
setActiveWorksheet(int) - Method in interface io.keikai.client.api.Spreadsheet
Sets the active worksheet of the active workbook with the given index.
setActiveWorksheet(String) - Method in interface io.keikai.client.api.Spreadsheet
Sets the active worksheet of the active workbook with the given sheet name or id.
setActiveWorksheet(String, String) - Method in interface io.keikai.client.api.Spreadsheet
Sets the active worksheet of the given book name with the given sheet name or id.
setActiveWorksheet(String, int) - Method in interface io.keikai.client.api.Spreadsheet
Sets the active worksheet of the given book name with the given sheet index.
setActiveWorksheet(String) - Method in interface io.keikai.client.api.Workbook
Makes the active worksheet from the given name.
setActiveWorksheet(int) - Method in interface io.keikai.client.api.Workbook
Makes the active worksheet from the given sheet index.
setAddress(String) - Method in interface io.keikai.client.api.Hyperlink
Sets the address.
setAlertStyle(DataValidation.AlertStyle) - Method in interface io.keikai.client.api.DataValidation
Sets the alert style.
setAlignment(Alignment) - Method in interface io.keikai.client.api.CellStyle
Sets the alignment
setAllowDeletingColumns(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to delete columns on the protected sheet.
setAllowDeletingRows(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to delete rows on the protected sheet.
setAllowFiltering(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to set filters on the protected sheet
setAllowFormattingCells(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to format any cell on the protected sheet.
setAllowFormattingColumns(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to format any columns on the protected sheet.
setAllowFormattingRows(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to format any rows on the protected sheet.
setAllowInsertingColumns(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to insert columns on the protected sheet.
setAllowInsertingHyperlinks(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to insert hyperlinks on the protected sheet.
setAllowInsertingRows(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to insert rows on the protected sheet.
setAllowSelectLockedCells(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow select locked cells.
setAllowSelectUnlockedCells(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow select unlocked cells
setAllowSorting(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to sort on the protected sheet.
setAllowUsingPivotTables(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to allow user to use pivot table reports on the protected sheet.
setAutoFill(Range, Range.AutoFillType) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setAutoFill(Range, Range.AutoFillType) - Method in interface io.keikai.client.api.Range
According to current range, fills data to destination range automatically
setAutoFilter(int, Object, Range.AutoFilterOperator, Object, boolean) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setAutoFilter(int, Object, Range.AutoFilterOperator, Object, boolean) - Method in interface io.keikai.client.api.Range
Activate the auto filter in this range.
setBackgroundColor(String) - Method in interface io.keikai.client.api.Fill.PatternFill
Sets background color in hex code, e.g.
setBold(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the bold or not
setBorder(Borders.BorderIndex, Border) - Method in interface io.keikai.client.api.Borders
Sets the border to the given border index.
setBorder(Borders.BorderIndex, Border) - Method in interface io.keikai.client.api.CellStyle
Sets the single border with the given border index
setBorders(Borders) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setBorders(Borders) - Method in interface io.keikai.client.api.CellStyle
Sets the borders collection, this will replace the existing borders, if any.
setBorders(Borders) - Method in interface io.keikai.client.api.Range
Sets the borders for this range.
setCalendar(Calendar, int, int, boolean) - Static method in class io.keikai.util.DateUtil
 
setCellStyle(CellStyle) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setCellStyle(CellStyle) - Method in interface io.keikai.client.api.Range
Sets the cell style.
setCharset(int) - Method in interface io.keikai.client.api.Font
Sets the charset
setColor(String) - Method in interface io.keikai.client.api.Border
Sets the border color.
setColor(int) - Method in interface io.keikai.client.api.Border
Sets the border color index
setColor(String) - Method in interface io.keikai.client.api.Borders
Sets the border color.
setColor(int) - Method in interface io.keikai.client.api.Borders
Sets the border color index.
setColor(String) - Method in interface io.keikai.client.api.Font
Sets the color
setColor(String) - Method in interface io.keikai.client.api.Stop
 
setColumnWidth(double) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setColumnWidth(double) - Method in interface io.keikai.client.api.Range
Sets the column width of this range in character unit width.
setColumnWidthPx(int) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setColumnWidthPx(int) - Method in interface io.keikai.client.api.Range
Sets the column width of this range in pixels.
setCondense(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the condense or not
setDataValidation(DataValidation) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setDataValidation(DataValidation) - Method in interface io.keikai.client.api.Range
Sets the data dataValidation
setDisplaySheetGridlines(boolean) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setDisplaySheetGridlines(boolean) - Method in interface io.keikai.client.api.Spreadsheet
Sets to enable or disable the display sheet grid lines of the active worksheet.
setDrawingObjects(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets the drawingObjects to true to protect objects.
setErrorMessage(String) - Method in interface io.keikai.client.api.DataValidation
Sets the error message.
setErrorTitle(String) - Method in interface io.keikai.client.api.DataValidation
Sets the title of the data validation error dialog box.
setExtend(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the extend or not
setFamily(int) - Method in interface io.keikai.client.api.Font
Sets the family
setFamily(Font.Family) - Method in interface io.keikai.client.api.Font
Sets the family
setFill(Fill) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setFill(Fill) - Method in interface io.keikai.client.api.CellStyle
Sets the fill
setFill(Fill) - Method in interface io.keikai.client.api.Range
Sets the fill to this range.
setFont(Font) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setFont(Font) - Method in interface io.keikai.client.api.CellStyle
Sets the font
setFont(Font) - Method in interface io.keikai.client.api.Range
Sets the font to this range.
setForegroundColor(String) - Method in interface io.keikai.client.api.Fill.PatternFill
Sets foreground color in hex code, e.g.
setFormat(String) - Method in interface io.keikai.client.api.NumberFormat
Sets the format
setFormula1(String) - Method in interface io.keikai.client.api.DataValidation
Sets the formula1 expression.
setFormula2(String) - Method in interface io.keikai.client.api.DataValidation
Sets the formula2 expression.
setHidden(boolean) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setHidden(boolean) - Method in interface io.keikai.client.api.Protection
Sets to be hidden or not.
setHidden(boolean) - Method in interface io.keikai.client.api.Range
Sets whether rows/columns is hidden; note this range must be either rows or columns.
setHorizontal(Alignment.Horizontal) - Method in interface io.keikai.client.api.Alignment
Sets the horizontal alignment
setHorizontalAlignment(Alignment.Horizontal) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setHorizontalAlignment(Alignment.Horizontal) - Method in interface io.keikai.client.api.Range
Sets the horizontal alignment for the given range.
setHyperlink(Hyperlink) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setHyperlink(Hyperlink) - Method in interface io.keikai.client.api.Range
Sets the given hyperlink to this range.
setIgnoreBlank(boolean) - Method in interface io.keikai.client.api.DataValidation
Sets to ignore the blank
setInCellDropdown(boolean) - Method in interface io.keikai.client.api.DataValidation
Sets to display a drop-down list that contains acceptable values
setIndent(int) - Method in interface io.keikai.client.api.Alignment
Sets the indent, starting from 0
setInputMessage(String) - Method in interface io.keikai.client.api.DataValidation
Sets the input message.
setInputTitle(String) - Method in interface io.keikai.client.api.DataValidation
Sets the title of the data validation input dialog box.
setItalic(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the italic or not
setJustifyLastLine(boolean) - Method in interface io.keikai.client.api.Alignment
Sets to enable/disable the justify last line
setLeftheadWidth(int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setLeftheadWidth(int) - Method in interface io.keikai.client.api.Spreadsheet
Sets the left head panel width, must large then 0.
setLocked(boolean) - Method in interface io.keikai.client.api.Protection
Sets to be locked or not.
setName(String) - Method in interface io.keikai.client.api.Font
Sets the name
setNumberFormat(String) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setNumberFormat(NumberFormat) - Method in interface io.keikai.client.api.CellStyle
Sets the number format.
setNumberFormat(String) - Method in interface io.keikai.client.api.Range
Sets the number format to this range.
setOperator(DataValidation.Operator) - Method in interface io.keikai.client.api.DataValidation
Sets the data validation operator
setOptions(UICommand, String) - Method in class io.keikai.client.api.ui.ToolbarSettings
Specifies button properties, for example: "enabled=false,maxSize=-1"
setOutline(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the outline or not
setPassword(String) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets the case-sensitive password for the sheet; null or empty string means protect the sheet without password.
setPatternType(Fill.PatternFill.PatternType) - Method in interface io.keikai.client.api.Fill.PatternFill
Sets pattern type
setPivotButton(boolean) - Method in interface io.keikai.client.api.CellStyle
Sets to enable or disable the pivot button
setPosition(int) - Method in interface io.keikai.client.api.Stop
 
setProtectedSheetWarningEnabled(boolean) - Method in interface io.keikai.client.api.UIService
Sets to enable or disable to show warning when user try to change data in a protected sheet
setProtection(Protection) - Method in interface io.keikai.client.api.CellStyle
Sets the protection.
setQuotePrefix(boolean) - Method in interface io.keikai.client.api.CellStyle
Sets to enable or disable the quote prefix.
setReadingOrder(Alignment.ReadingOrder) - Method in interface io.keikai.client.api.Alignment
Sets the reading order.
setRelativeIndent(int) - Method in interface io.keikai.client.api.Alignment
Sets the relative indent.
setRowHeight(double) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setRowHeight(double) - Method in interface io.keikai.client.api.Range
Sets the row height of this range in character unit height.
setRowHeightPx(int) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setRowHeightPx(int) - Method in interface io.keikai.client.api.Range
Sets the row height of this range in pixels.
setScenarios(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to protect scenarios.
setScheme(String) - Method in interface io.keikai.client.api.Font
Sets the scheme
setShadow(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the shadow or not
setSheetOrder(int) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setSheetOrder(int) - Method in interface io.keikai.client.api.Range
Applies the sheet order to the given index.
setSheetVisible(String) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setSheetVisible(String) - Method in interface io.keikai.client.api.Spreadsheet
Sets the visibility of this active worksheet.
setShowError(boolean) - Method in interface io.keikai.client.api.DataValidation
Sets to show the error message message whenever the user enters invalid data.
setShowInput(boolean) - Method in interface io.keikai.client.api.DataValidation
Sets to show the input message whenever the user selects a cell in the data validation range.
setShrinkToFit(boolean) - Method in interface io.keikai.client.api.Alignment
Sets to enable/disable the shrink to fit
setSize(int) - Method in interface io.keikai.client.api.Font
Sets the size
setStrike(boolean) - Method in interface io.keikai.client.api.Font
sets to enable the strike or not
setStyle(Border.Style) - Method in interface io.keikai.client.api.Border
Sets the border style.
setStyle(Border.Style) - Method in interface io.keikai.client.api.Borders
Sets the border style.
setSubscript(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the subscript or not
setSuperscript(boolean) - Method in interface io.keikai.client.api.Font
Sets to enable the superscript or not
setText(String) - Method in interface io.keikai.client.api.ctrl.Button
Sets the text of this button.
setText(String) - Method in interface io.keikai.client.api.ctrl.Checkbox
Sets the text of this checkbox.
setText(String) - Method in interface io.keikai.client.api.ctrl.Groupbox
Sets the text of this Groupbox.
setText(String) - Method in interface io.keikai.client.api.ctrl.OptionButton
Sets the text of this option button.
setTextRotation(int) - Method in interface io.keikai.client.api.Alignment
Sets the text rotation in degree, e.g setTextRotation(90) means to rotate a text in 90 degrees clockwise.
setTextToDisplay(String) - Method in interface io.keikai.client.api.Hyperlink
Sets the text to be displayed for this hyperlink.
setThemeColor(Border.ThemeColor) - Method in interface io.keikai.client.api.Border
Sets the border theme color.
setThemeColor(Border.ThemeColor) - Method in interface io.keikai.client.api.Borders
Sets the border theme color.
Settings - Class in io.keikai.client.api
A Keikai Spreadsheet client settings
Settings() - Constructor for class io.keikai.client.api.Settings
 
Settings(EnumMap) - Constructor for class io.keikai.client.api.Settings
 
Settings.Key - Enum in io.keikai.client.api
The setting keys
setTooltip(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
setTooltip(String) - Method in interface io.keikai.client.api.Worksheet
Sets tooltip text of the sheet tab UI.
setTopheadHeight(int) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setTopheadHeight(int) - Method in interface io.keikai.client.api.Spreadsheet
Sets the top head panel height, must large then 0.
setType(DataValidation.Type) - Method in interface io.keikai.client.api.DataValidation
Sets the data validation type
setUIActivityCallback(UIActivity) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setUIActivityCallback(UIActivity) - Method in interface io.keikai.client.api.Spreadsheet
Sets a callback for UI client's activity.
setUICommandEnabled(UICommand, boolean) - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
setUICommandEnabled(UICommand, boolean) - Method in interface io.keikai.client.api.Spreadsheet
Sets to enable or disable the given UI command.
setUnderline(Font.Underline) - Method in interface io.keikai.client.api.Font
Sets the underline
setUserInterfaceOnly(boolean) - Method in class io.keikai.client.api.SheetProtection.Builder
Sets true to forbid user to modify this the through UI e.g.
setValidator(Predicate<CellValue>) - Method in interface io.keikai.client.api.DataValidation
Sets the data validator hook.
setValue(T) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setValue(T) - Method in interface io.keikai.client.api.Range
Sets the range value.
setValues(T...) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setValues(T...) - Method in interface io.keikai.client.api.Range
Sets the range values.
setVertical(Alignment.Vertical) - Method in interface io.keikai.client.api.Alignment
Sets the vertical alignment
setVerticalAlignment(Alignment.Vertical) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setVerticalAlignment(Alignment.Vertical) - Method in interface io.keikai.client.api.Range
Sets the vertical alignment.
setVisible(Worksheet.Visibility) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
setVisible(boolean) - Method in interface io.keikai.client.api.Shape
Sets to show or hide the shape.
setVisible(Worksheet.Visibility) - Method in interface io.keikai.client.api.Worksheet
Sets the visibility of this sheet.
setVisibleArea(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
setVisibleArea(String) - Method in interface io.keikai.client.api.Worksheet
Sets visible area for this worksheet.
setWrapText(boolean) - Method in interface io.keikai.client.api.Alignment
enable/disable the wrapped text
setWrapText(boolean) - Method in class io.keikai.client.api.atomic.AtomicRange
 
setWrapText(boolean) - Method in interface io.keikai.client.api.Range
Sets to enable or disable the wrap text.
Shape - Interface in io.keikai.client.api
A shape interface
ShapeChangeEvent<T extends Shape> - Class in io.keikai.client.api.event
Event that carries shape information on value changed, like spinner or scrollbar for form-control.
ShapeChangeEvent(String, Set, int, int, int, int, T, int, int, int, int, int, Range, Object) - Constructor for class io.keikai.client.api.event.ShapeChangeEvent
 
ShapeEvent<T extends Shape> - Class in io.keikai.client.api.event
A shape event is sent when a user interacts with the shape UI.
ShapeEvent(String, Set<Range>, int, int, int, int, T, Object) - Constructor for class io.keikai.client.api.event.ShapeEvent
 
ShapeMouseEvent<T extends Shape> - Class in io.keikai.client.api.event
Event that carries mouse x,y information and shape information on click
ShapeMouseEvent(String, Set<Range>, int, int, int, int, int, int, int, int, int, int, T, Object) - Constructor for class io.keikai.client.api.event.ShapeMouseEvent
 
ShapeSelectEvent<T extends Shape> - Class in io.keikai.client.api.event
Event that carries shape information on selection changed, like dropdown and listbox for form-control.
ShapeSelectEvent(String, Set, int, int, int, int, T, List, List<Integer>, Range, Range, Object) - Constructor for class io.keikai.client.api.event.ShapeSelectEvent
 
SheetEvent - Class in io.keikai.client.api.event
SheetEvent that affected the whole sheet.
SheetEvent(String, KSpreadsheet, String, String, String, String, String, int, Object) - Constructor for class io.keikai.client.api.event.SheetEvent
 
SheetProtection - Class in io.keikai.client.api
SheetProtection values config.
SheetProtection.Builder - Class in io.keikai.client.api
Builder is used to build instances of SheetProtection from values configured by the setters
showContextMenu(boolean) - Method in interface io.keikai.client.api.UIService
Sets to enable or disable the context menu.
showFormulaBar(boolean) - Method in interface io.keikai.client.api.UIService
Sets to enable or disable the formula bar.
showModalDialog(String, String) - Method in interface io.keikai.client.api.UIService
Shows modal dialog with the given title and message on "info" type.
showModalDialog(String, String, String) - Method in interface io.keikai.client.api.UIService
Shows modal dialog with the given title and message on the given type.
showSheetControls(boolean) - Method in interface io.keikai.client.api.UIService
Sets to enable or disable the sheet controls including add sheet button and context menu in sheet tabs
showSheetTabs(boolean) - Method in interface io.keikai.client.api.UIService
Sets to enable or disable the sheet tabs.
showToolbar(boolean) - Method in interface io.keikai.client.api.UIService
Sets to enable or disable the toolbar.
sort(Range, Range.SortOrder, Range, Range.SortOrder, Range, Range.SortOrder, Range.YesNoGuess, boolean, Range.SortOrientation, Range.SortDataOption, Range.SortDataOption, Range.SortDataOption) - Method in class io.keikai.client.api.atomic.AtomicRange
 
sort(Range, Range.SortOrder, Range, Range.SortOrder, Range, Range.SortOrder, Range.YesNoGuess, boolean, Range.SortOrientation, Range.SortDataOption, Range.SortDataOption, Range.SortDataOption) - Method in interface io.keikai.client.api.Range
Sort values in this range with given options.
Spinner - Interface in io.keikai.client.api.ctrl
Form control spinner
Spreadsheet - Interface in io.keikai.client.api
A Keikai Spreadsheet client interface.
Stop - Interface in io.keikai.client.api
 
SystemException - Exception in io.keikai.client.api
Indicates a system exception.
SystemException(String) - Constructor for exception io.keikai.client.api.SystemException
 
SystemException(String, Throwable) - Constructor for exception io.keikai.client.api.SystemException
 
SystemException(Throwable) - Constructor for exception io.keikai.client.api.SystemException
 
SystemException(String, Throwable, boolean, boolean) - Constructor for exception io.keikai.client.api.SystemException
 

T

toJSON(Object) - Static method in class io.keikai.util.Converter
 
toJSONString() - Method in enum io.keikai.client.api.Alignment.Horizontal
 
toJSONString() - Method in enum io.keikai.client.api.Alignment.ReadingOrder
 
toJSONString() - Method in enum io.keikai.client.api.Alignment.Vertical
 
toJSONString() - Method in enum io.keikai.client.api.Border.Style
 
toJSONString() - Method in enum io.keikai.client.api.Border.ThemeColor
 
toJSONString() - Method in enum io.keikai.client.api.Borders.BorderIndex
 
toJSONString() - Method in enum io.keikai.client.api.DataValidation.AlertStyle
 
toJSONString() - Method in enum io.keikai.client.api.DataValidation.Operator
 
toJSONString() - Method in enum io.keikai.client.api.DataValidation.Type
 
toJSONString() - Method in enum io.keikai.client.api.Fill.PatternFill.PatternType
 
toJSONString() - Method in enum io.keikai.client.api.Font.Family
 
toJSONString() - Method in enum io.keikai.client.api.Font.Underline
 
toJSONString() - Method in enum io.keikai.client.api.Hyperlink.HyperlinkType
 
toJSONString() - Method in enum io.keikai.client.api.Range.AutoFillType
 
toJSONString() - Method in enum io.keikai.client.api.Range.AutoFilterOperator
 
toJSONString() - Method in enum io.keikai.client.api.Range.DeleteShiftDirection
 
toJSONString() - Method in enum io.keikai.client.api.Range.InsertFormatOrigin
 
toJSONString() - Method in enum io.keikai.client.api.Range.InsertShiftDirection
 
toJSONString() - Method in enum io.keikai.client.api.Range.PasteSpecialOperation
 
toJSONString() - Method in enum io.keikai.client.api.Range.PasteType
 
toJSONString() - Method in enum io.keikai.client.api.Range.SortDataOption
 
toJSONString() - Method in enum io.keikai.client.api.Range.SortOrder
 
toJSONString() - Method in enum io.keikai.client.api.Range.SortOrientation
 
toJSONString() - Method in enum io.keikai.client.api.Range.YesNoGuess
 
toJSONString() - Method in class io.keikai.client.api.RangeAnchor
 
toJSONString() - Method in class io.keikai.client.api.ui.ToolbarSettings
 
toJSONString() - Method in enum io.keikai.client.api.Worksheet.Visibility
 
toMap(Object...) - Static method in class io.keikai.util.Maps
 
ToolbarSettings - Class in io.keikai.client.api.ui
Settings for toolbar customization, modify it to add/remove button or specify button properties.
ToolbarSettings() - Constructor for class io.keikai.client.api.ui.ToolbarSettings
 
ToolbarSettings(List<UICommand>) - Constructor for class io.keikai.client.api.ui.ToolbarSettings
 
toRangeFromJSON(Spreadsheet, String) - Static method in class io.keikai.util.Converter
 
toRGBString(String) - Static method in class io.keikai.util.Colors
Converts from ARGB(Keikai) to RGB(Java) color string (and converts to upper case).
toString() - Method in class io.keikai.client.api.event.RangeEvent
 
toString() - Method in class io.keikai.client.api.event.SheetEvent
 
toString() - Method in class io.keikai.client.api.RangeAnchor
 
toString() - Method in enum io.keikai.client.api.ui.UICommand
 
toString() - Method in class io.keikai.util.Ref
 

U

UIActivity - Interface in io.keikai.client.api.ui
Used to receive the activity status of Dart UI client
UICommand - Enum in io.keikai.client.api.ui
 
UICommandEvent - Class in io.keikai.client.api.event
 
UICommandEvent(String, String, Range, Set<Range>, Object) - Constructor for class io.keikai.client.api.event.UICommandEvent
 
UID - Static variable in class io.keikai.client.Version
 
UIService - Interface in io.keikai.client.api
A UI service control to interact with the UI client for the current spreadsheet instance.
unfreezePanes() - Method in class io.keikai.client.api.atomic.AtomicRange
 
unfreezePanes() - Method in class io.keikai.client.api.atomic.AtomicSpreadsheet
 
unfreezePanes() - Method in interface io.keikai.client.api.Range
un-freeze the panes.
unfreezePanes() - Method in interface io.keikai.client.api.Spreadsheet
un-freezes the panes of the active worksheet.
unmerge() - Method in class io.keikai.client.api.atomic.AtomicRange
 
unmerge() - Method in interface io.keikai.client.api.Range
Unmerge the range.
unprotect(String) - Method in class io.keikai.client.api.atomic.AtomicWorksheet
 
unprotect(String) - Method in interface io.keikai.client.api.Worksheet
Removes protection to this sheet.

V

valueOf(String) - Static method in enum io.keikai.client.api.Alignment.Horizontal
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Alignment.ReadingOrder
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Alignment.Vertical
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Border.Style
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Border.ThemeColor
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Borders.BorderIndex
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.DataValidation.AlertStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.DataValidation.Operator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.DataValidation.Type
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Fill.PatternFill.PatternType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Font.Family
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Font.Underline
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Hyperlink.HyperlinkType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.AutoFillType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.AutoFilterOperator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.DeleteShiftDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.InsertFormatOrigin
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.InsertShiftDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.PasteSpecialOperation
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.PasteType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.SortDataOption
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.SortOrder
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.SortOrientation
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Range.YesNoGuess
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Settings.Key
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.ui.UICommand
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum io.keikai.client.api.Worksheet.Visibility
Returns the enum constant of this type with the specified name.
values() - Static method in enum io.keikai.client.api.Alignment.Horizontal
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Alignment.ReadingOrder
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Alignment.Vertical
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Border.Style
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Border.ThemeColor
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Borders.BorderIndex
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.DataValidation.AlertStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.DataValidation.Operator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.DataValidation.Type
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Fill.PatternFill.PatternType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Font.Family
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Font.Underline
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Hyperlink.HyperlinkType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.AutoFillType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.AutoFilterOperator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.DeleteShiftDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.InsertFormatOrigin
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.InsertShiftDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.PasteSpecialOperation
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.PasteType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.SortDataOption
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.SortOrder
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.SortOrientation
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Range.YesNoGuess
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Settings.Key
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.ui.UICommand
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum io.keikai.client.api.Worksheet.Visibility
Returns an array containing the constants of this enum type, in the order they are declared.
Version - Class in io.keikai.client
 
Version() - Constructor for class io.keikai.client.Version
 

W

Workbook - Interface in io.keikai.client.api
A workbook represents a book in a spreadsheet.
Worksheet - Interface in io.keikai.client.api
A worksheet represents a sheet in a workbook.
Worksheet.Visibility - Enum in io.keikai.client.api
Visibility attributes that can be applied.
A B C D E F G H I K L M N O P R S T U V W 
Skip navigation links

Copyright © 2019. All rights reserved.