Uses of Interface
io.keikai.api.model.Sheet
-
Packages that use Sheet Package Description io.keikai.api Keikai Spreadsheet API classes.io.keikai.api.impl Keikai Spreadsheet API implementation classes, internal use onlyio.keikai.api.model Keikai Spreadsheet Model API classes.io.keikai.api.model.impl Keikai Spreadsheet Model API implementation classes, Internal use onlyio.keikai.ui Defines UI Component class of Keikai Spreadsheetio.keikai.ui.au.in Keikai Spreadsheet UI Component Command (Client to Server).io.keikai.ui.event Events of Keikai Spreadsheet UI Component.io.keikai.ui.impl Classes for implementing Keikai Spreadsheet UI Components (implementation only).io.keikai.ui.impl.ua Classes that doing system user action control on Keikai Spreadsheet UI Components.io.keikai.ui.impl.undo Classes that doing system undoable action control on Keikai Spreadsheet UI Components.io.keikai.ui.sys Classes that doing system control on Keikai Spreadsheet UI Components.io.keikaiex.ui io.keikaiex.ui.dialog io.keikaiex.ui.impl io.keikaiex.ui.impl.ua Classes that doing system user action control on Keikai Spreadsheet UI Components.io.keikaiex.ui.impl.undo Classes that doing system undoable action control on Keikai Spreadsheet UI Components. -
-
Uses of Sheet in io.keikai.api
Methods in io.keikai.api that return Sheet Modifier and Type Method Description Sheet
Range. cloneSheet(String name)
Clone this sheet; create a sheet and copy the contents of this sheet; then add it as the last sheet.Sheet
Range. cloneSheetFrom(String name, Sheet sheet)
Clone from the specified source sheet to the owner book of this range.Sheet
Range. cloneSheetFrom(String name, Sheet sheet, boolean valueOnly)
Clone from the specified source sheet to the owner book of this range.Sheet
Range. createSheet(String name)
Creates a new sheet and appends it as the last sheet.Sheet
Range. getSheet()
Gets the sheet of this rangeMethods in io.keikai.api with parameters of type Sheet Modifier and Type Method Description Sheet
Range. cloneSheetFrom(String name, Sheet sheet)
Clone from the specified source sheet to the owner book of this range.Sheet
Range. cloneSheetFrom(String name, Sheet sheet, boolean valueOnly)
Clone from the specified source sheet to the owner book of this range.static String
Ranges. getAreaRefString(Sheet sheet, int tRow, int lCol, int bRow, int rCol)
Gets area reference expressionstatic String
Ranges. getAreaRefString(Sheet sheet, AreaRef area)
Gets area reference expressionstatic int
CellOperationUtil. getAutoFitHeight(Sheet sheet, int row, int col)
Calculate the autoFit cell height according its data size.static String
Ranges. getCellRefString(Sheet sheet, int row, int col)
Gets cell reference expression stringstatic List<String>
Ranges. getNames(Sheet sheet)
Returns a list of the defined names belong to the specifiedSheet
;static Range
Ranges. range(Sheet sheet)
static Range
Ranges. range(Sheet sheet, int row, int col)
static Range
Ranges. range(Sheet sheet, int tRow, int lCol, int bRow, int rCol)
Returns the associatedXRange
of the specifiedXSheet
and area.static Range
Ranges. range(Sheet sheet, AreaRef selection)
static Range
Ranges. range(Sheet sheet, String areaReference)
static Range
Ranges. rangeByName(Sheet sheet, String name)
Returns the associatedRange
of the specified name of a NamedRange (e.g.static SheetAnchor
SheetOperationUtil. toFilledAnchor(Sheet sheet, int row, int column, int widthPx, int heightPx)
return aSheetAnchor
based on a cell and a picture width and height -
Uses of Sheet in io.keikai.api.impl
Methods in io.keikai.api.impl that return Sheet Modifier and Type Method Description Sheet
RangeImpl. cloneSheet(String name)
Sheet
RangeImpl. cloneSheetFrom(String name, Sheet sheet)
Sheet
RangeImpl. cloneSheetFrom(String name, Sheet sheet, boolean valueOnly)
Sheet
RangeImpl. createSheet(String name)
Sheet
RangeImpl. getSheet()
Methods in io.keikai.api.impl with parameters of type Sheet Modifier and Type Method Description Sheet
RangeImpl. cloneSheetFrom(String name, Sheet sheet)
Sheet
RangeImpl. cloneSheetFrom(String name, Sheet sheet, boolean valueOnly)
Constructors in io.keikai.api.impl with parameters of type Sheet Constructor Description RangeImpl(SRange range, Sheet sheet)
-
Uses of Sheet in io.keikai.api.model
Methods in io.keikai.api.model that return Sheet Modifier and Type Method Description Sheet
Book. getSheet(String name)
Gets sheet by sheet nameSheet
Book. getSheetAt(int index)
Gets sheet by indexMethods in io.keikai.api.model with parameters of type Sheet Modifier and Type Method Description int
Book. getSheetIndex(Sheet sheet)
Gets the index of sheet -
Uses of Sheet in io.keikai.api.model.impl
Classes in io.keikai.api.model.impl that implement Sheet Modifier and Type Class Description class
SheetImpl
Methods in io.keikai.api.model.impl with parameters of type Sheet Modifier and Type Method Description int
BookImpl. getSheetIndex(Sheet sheet)
-
Uses of Sheet in io.keikai.ui
Methods in io.keikai.ui that return Sheet Modifier and Type Method Description Sheet
Spreadsheet. getSelectedSheet()
Gets the selected sheet, the default selected sheet is first sheet.Sheet
UserActionContext.Clipboard. getSheet()
Sheet
UserActionContext. getSheet()
Methods in io.keikai.ui with parameters of type Sheet Modifier and Type Method Description boolean
UserActionHandler. isEnabled(Book book, Sheet sheet)
get the enabled state of this actionvoid
UserActionContext. setClipboard(Sheet sheet, AreaRef selection, boolean cutMode, Object info)
void
Spreadsheet. traceDependents(Sheet sheet, CellRef cellRef)
Trace the dependents of the reference.void
Spreadsheet. tracePrecedents(Sheet sheet, CellRef cellRef)
Trace the precedent of the reference. -
Uses of Sheet in io.keikai.ui.au.in
Methods in io.keikai.ui.au.in that return Sheet Modifier and Type Method Description static Sheet
AbstractCommand. getSheetByUuid(Book book, String uuid)
Methods in io.keikai.ui.au.in with parameters of type Sheet Modifier and Type Method Description protected static String
AbstractCommand. getSheetUuid(Sheet sheet)
-
Uses of Sheet in io.keikai.ui.event
Methods in io.keikai.ui.event that return Sheet Modifier and Type Method Description Sheet
SheetSelectEvent. getPreviousSheet()
Sheet
AuxActionEvent. getSheet()
Sheet
CellEvent. getSheet()
get SheetSheet
CellMouseEvent. getSheet()
get SheetSheet
CellMultipleSelectionEvent. getSheet()
get SheetSheet
GroupHeaderClickEvent. getSheet()
Returns the current sheet.Sheet
SheetEvent. getSheet()
Sheet
SyncFriendFocusEvent. getSheet()
Sheet
WidgetKeyEvent. getSheet()
Sheet
WidgetUpdateEvent. getSheet()
Constructors in io.keikai.ui.event with parameters of type Sheet Constructor Description AuxActionEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, String action, AreaRef selection, Map data)
AuxActionEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, String action, Set<AreaRefWithType> selection, Map data)
constructor of AuxActionEvent (selection set)CellAreaEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int tRow, int lCol, int bRow, int rCol)
CellEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, Object data)
CellFilterEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, AreaRef filterArea, int field, int x, int y, int keys, int clientx, int clienty)
CellHyperlinkEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, String address, Hyperlink.HyperlinkType type, int x, int y, int pageX, int pageY, int keys)
CellMouseEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, int x, int y, int keys, int clientx, int clienty)
CellMultipleSelectionEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, Set<AreaRefWithType> selectionArea, Object data)
CellSelectionEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int tRow, int lCol, int bRow, int rCol, CellSelectionType type)
CellSelectionUpdateEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int tRow, int lCol, int bRow, int rCol, int otRow, int olCol, int obRow, int orCol, CellSelectionType type, CellSelectionAction action)
ClipboardPasteEvent(org.zkoss.zk.ui.Component target, Sheet sheet, int top, int left, int bottom, int right)
EditboxEditingEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, Object clientvalue)
GroupHeaderClickEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int level, String dir)
GroupOpenEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int startIndex, int endIndex, String dir, boolean open)
SheetEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet)
SheetSelectEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, Sheet previousSheet)
StartEditingEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, Object editingValue, Object clientvalue)
StopEditingEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, String editingValue)
SyncFriendFocusEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, Collection<Focus> inBook, Collection<Focus> inSheet)
WidgetKeyEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, Object data, int keyCode, boolean ctrlKey, boolean shiftKey, boolean altKey)
WidgetUpdateEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, WidgetAction action, Object widgetData, SheetAnchor anchor)
-
Uses of Sheet in io.keikai.ui.impl
Methods in io.keikai.ui.impl that return Sheet Modifier and Type Method Description Sheet
DefaultUserActionManagerCtrl.ClipboardImpl. getSheet()
Sheet
DefaultUserActionManagerCtrl.UserActionContextImpl. getSheet()
Methods in io.keikai.ui.impl with parameters of type Sheet Modifier and Type Method Description Set<String>
DefaultUserActionManagerCtrl. getSupportedUserAction(Sheet sheet)
List<Map<String,Object>>
DummyDataValidationHandler. loadDataValidtionJASON(Sheet sheet)
void
DefaultUserActionManagerCtrl.UserActionContextImpl. setClipboard(Sheet sheet, AreaRef selection, boolean cutMode, Object info)
protected void
DefaultUserActionManagerCtrl. updateClipboardEffect(Sheet sheet)
boolean
DummyDataValidationHandler. validate(Sheet sheet, int row, int col, String editText, org.zkoss.zk.ui.event.EventListener callback)
Constructors in io.keikai.ui.impl with parameters of type Sheet Constructor Description ClipboardImpl(Spreadsheet ss, Sheet sheet, AreaRef selection, boolean cutMode, Object info)
UserActionContextImpl(Spreadsheet ss, org.zkoss.zk.ui.event.Event event, Book book, Sheet sheet, AreaRef selection, CellSelectionType selectionType, Map<String,Object> data, String category, String action)
UserActionContextImpl(Spreadsheet ss, org.zkoss.zk.ui.event.Event event, Book book, Sheet sheet, Set<AreaRefWithType> selection, Map<String,Object> data, String category, String action)
-
Uses of Sheet in io.keikai.ui.impl.ua
Methods in io.keikai.ui.impl.ua with parameters of type Sheet Modifier and Type Method Description boolean
AbstractBookHandler. isEnabled(Book book, Sheet sheet)
boolean
AbstractCellHandler. isEnabled(Book book, Sheet sheet)
boolean
AbstractFilterHandler. isEnabled(Book book, Sheet sheet)
boolean
AbstractHandler. isEnabled(Book book, Sheet sheet)
boolean
AbstractProtectedHandler. isEnabled(Book book, Sheet sheet)
boolean
AbstractSheetHandler. isEnabled(Book book, Sheet sheet)
boolean
DeleteColumnHandler. isEnabled(Book book, Sheet sheet)
boolean
DeleteRowHandler. isEnabled(Book book, Sheet sheet)
boolean
DeleteSheetHandler. isEnabled(Book book, Sheet sheet)
boolean
HideHeaderHandler. isEnabled(Book book, Sheet sheet)
boolean
InsertColumnHandler. isEnabled(Book book, Sheet sheet)
boolean
InsertRowHandler. isEnabled(Book book, Sheet sheet)
boolean
MoveSheetHandler. isEnabled(Book book, Sheet sheet)
boolean
NilHandler. isEnabled(Book book, Sheet sheet)
-
Uses of Sheet in io.keikai.ui.impl.undo
Fields in io.keikai.ui.impl.undo declared as Sheet Modifier and Type Field Description protected Sheet
Abstract2DCellDataStyleAction. _destSheet
protected Sheet
PasteCellAction. _destSheet
protected Sheet
PasteSpecialCellAction. _destSheet
protected Sheet
AbstractUndoableAction. _sheet
Methods in io.keikai.ui.impl.undo that return Sheet Modifier and Type Method Description Sheet
Abstract2DCellDataStyleAction. getRedoSheet()
Sheet
AbstractUndoableAction. getRedoSheet()
Sheet
AggregatedAction. getRedoSheet()
Sheet
PasteCellAction. getRedoSheet()
Sheet
PasteSpecialCellAction. getRedoSheet()
protected Sheet
Abstract2DCellDataStyleAction. getReservedDestSheet()
protected Sheet
AbstractCellDataStyleAction. getReservedSheet()
protected Sheet
AbstractEditTextAction. getReservedSheet()
protected Sheet
PasteCellAction. getReservedSheet()
protected Sheet
PasteSpecialCellAction. getReservedSheet()
protected Sheet
Abstract2DCellDataStyleAction. getReservedSrcSheet()
Sheet
Abstract2DCellDataStyleAction. getUndoSheet()
Sheet
AbstractUndoableAction. getUndoSheet()
Sheet
AggregatedAction. getUndoSheet()
Sheet
PasteCellAction. getUndoSheet()
Sheet
PasteSpecialCellAction. getUndoSheet()
Methods in io.keikai.ui.impl.undo with parameters of type Sheet Modifier and Type Method Description protected boolean
AbstractUndoableAction. isAnyCellProtected(Sheet sheet, CellRegion cellRegion)
Constructors in io.keikai.ui.impl.undo with parameters of type Sheet Constructor Description Abstract2DCellDataStyleAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, boolean srcWholeColumn, boolean srcWholeRow, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, boolean destWholeColumn, boolean destWholeRow, int reserveType)
Abstract2DCellDataStyleAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, int reserveType)
AbstractCellDataStyleAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, boolean wholeColumn, boolean wholeRow, int reserveType)
AbstractCellDataStyleAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, int reserveType)
AbstractEditTextAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn)
AbstractUndoableAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn)
AbstractUndoableAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, boolean wholeColumn, boolean wholeRow)
AutoFillCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, Range.AutoFillType fillType)
CellBorderAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, Range.ApplyBorderType applyType, CellStyle.BorderType borderType, String htmlColor)
CellEditTextAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, String[][] editTexts)
CellEditTextAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, String[][] editTexts, boolean isPasteFromClipboard)
CellEditTextAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, String editText, boolean isArrayFormula)
CellRichTextAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, CellOperationUtil.CellStyleApplier applier)
CellRichTextAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, String editText)
CellStyleAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, CellOperationUtil.CellStyleApplier styleApplier)
ClearCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, ClearCellAction.Type type)
CutCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, boolean srcWholeColumn, boolean srcWholeRow, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, boolean destWholeColumn, boolean destWholeRow)
DeleteCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, Range.DeleteShift shift)
FontStyleAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, CellOperationUtil.CellStyleApplier styleApplier)
HideHeaderAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, HideHeaderAction.Type type, boolean hidden)
InsertCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, Range.InsertShift shift, Range.InsertCopyOrigin copyOrigin)
MergeCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, boolean accross)
PasteCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, boolean srcWholeColumn, boolean srcWholeRow, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, boolean destWholeColumn, boolean destWholeRow)
PasteSpecialCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, Range.PasteType pasteType, Range.PasteOperation pasteOperation, boolean skipBlank, boolean transpose)
ResizeHeaderAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, ResizeHeaderAction.Type type, int size, boolean isCustom)
ShiftCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, int rowNumber, int columnNumber)
SortCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, Range index1, boolean desc1)
SortCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, Range index1, boolean desc1, Range.SortDataOption dataOption1, Range index2, boolean desc2, Range.SortDataOption dataOption2, Range index3, boolean desc3, Range.SortDataOption dataOption3, boolean header, boolean matchCase, boolean sortByRows)
ToggleMergeCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn)
UnmergeCellAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn)
-
Uses of Sheet in io.keikai.ui.sys
Methods in io.keikai.ui.sys that return Sheet Modifier and Type Method Description Sheet
UndoableAction. getRedoSheet()
Sheet
UndoableAction. getUndoSheet()
Methods in io.keikai.ui.sys with parameters of type Sheet Modifier and Type Method Description Set<String>
UserActionManagerCtrl. getSupportedUserAction(Sheet sheet)
Returns the supported user action that should be disabledboolean
SortHandler. isEnabled(Book book, Sheet sheet)
List<Map<String,Object>>
DataValidationHandler. loadDataValidtionJASON(Sheet sheet)
boolean
DataValidationHandler. validate(Sheet sheet, int row, int col, String editText, org.zkoss.zk.ui.event.EventListener callback)
-
Uses of Sheet in io.keikaiex.ui
Methods in io.keikaiex.ui with parameters of type Sheet Modifier and Type Method Description boolean
ValidationHelper. validate(Sheet sheet, int row, int col, String editText, org.zkoss.zk.ui.event.EventListener callback)
To help you validate the cell edit text, it returns true if validation passed or no validation rule. You can also assign a callback listener if the cell is configured to show a error-box to ask user re-input the edit value again when validation fail. -
Uses of Sheet in io.keikaiex.ui.dialog
Fields in io.keikaiex.ui.dialog declared as Sheet Modifier and Type Field Description protected Sheet
CustomSortCtrl. sheet
Methods in io.keikaiex.ui.dialog with parameters of type Sheet Modifier and Type Method Description static void
CustomSortCtrl. show(org.zkoss.zk.ui.event.EventListener<DialogCallbackEvent> callback, Sheet sheet, AreaRef selection, Spreadsheet ss)
-
Uses of Sheet in io.keikaiex.ui.impl
Methods in io.keikaiex.ui.impl with parameters of type Sheet Modifier and Type Method Description List<Map<String,Object>>
DataValidationHandlerImpl. loadDataValidtionJASON(Sheet sheet)
boolean
DataValidationHandlerImpl. validate(Sheet sheet, int row, int col, String editText, org.zkoss.zk.ui.event.EventListener callback)
-
Uses of Sheet in io.keikaiex.ui.impl.ua
Methods in io.keikaiex.ui.impl.ua with parameters of type Sheet Modifier and Type Method Description boolean
AbstractObjectHandler. isEnabled(Book book, Sheet sheet)
boolean
ApplyFilterHandler. isEnabled(Book book, Sheet sheet)
boolean
AutoFillHandler. isEnabled(Book book, Sheet sheet)
AutoFill is not disabled under sheet protection.boolean
CleanFilterHandler. isEnabled(Book book, Sheet sheet)
boolean
CustomSortHandler. isEnabled(Book book, Sheet sheet)
boolean
DeleteCommentHandler. isEnabled(Book book, Sheet sheet)
boolean
EditCommentHandler. isEnabled(Book book, Sheet sheet)
boolean
HeaderSizeHandler. isEnabled(Book book, Sheet sheet)
boolean
HideSheetHandler. isEnabled(Book book, Sheet sheet)
boolean
HyperlinkHandler. isEnabled(Book book, Sheet sheet)
boolean
InsertCommentHandler. isEnabled(Book book, Sheet sheet)
boolean
ReapplyFilterHandler. isEnabled(Book book, Sheet sheet)
boolean
UnhideSheetHandler. isEnabled(Book book, Sheet sheet)
protected boolean
HideSheetHandler. isHidden(Sheet sheet)
protected void
DataValidationHandler. showValidationDialog(UserActionContext ctx, Sheet sheet, AreaRef selection, List<Validation> validations)
-
Uses of Sheet in io.keikaiex.ui.impl.undo
Constructors in io.keikaiex.ui.impl.undo with parameters of type Sheet Constructor Description CellCommentAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, String editText)
DataValidationAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, Validation.ValidationType validationType, boolean ignoreBlank, Validation.OperatorType operatorType, boolean inCellDropDown, String param1, String param2, boolean showInput, String inputTitle, String inputMessage, boolean showError, Validation.AlertStyle alertStyle, String errorTitle, String errorMessage)
-