Uses of Interface
io.keikai.api.model.Sheet
Packages that use Sheet
Package
Description
Keikai Spreadsheet API classes.
Keikai Spreadsheet API implementation classes, internal use only
Keikai Spreadsheet Model API classes.
Keikai Spreadsheet Model API implementation classes, Internal use only
Defines UI Component class of Keikai Spreadsheet
Keikai Spreadsheet UI Component Command (Client to Server).
Events of Keikai Spreadsheet UI Component.
Classes for implementing Keikai Spreadsheet UI Components (implementation only).
Classes that doing system user action control on Keikai Spreadsheet UI Components.
Classes that doing system undoable action control on Keikai Spreadsheet UI Components.
Classes that doing system control on Keikai Spreadsheet UI Components.
Classes that doing system user action control on Keikai Spreadsheet UI Components.
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 SheetModifier and TypeMethodDescriptionRange.cloneSheet(String name) Clone this sheet; create a sheet and copy the contents of this sheet; then add it as the last sheet.Range.cloneSheetFrom(String name, Sheet sheet) Clone from the specified source sheet to the owner book of this range.Range.cloneSheetFrom(String name, Sheet sheet, boolean valueOnly) Clone from the specified source sheet to the owner book of this range.Range.createSheet(String name) Creates a new sheet and appends it as the last sheet.Range.getSheet()Gets the sheet of this rangeMethods in io.keikai.api with parameters of type SheetModifier and TypeMethodDescriptionRange.cloneSheetFrom(String name, Sheet sheet) Clone from the specified source sheet to the owner book of this range.Range.cloneSheetFrom(String name, Sheet sheet, boolean valueOnly) Clone from the specified source sheet to the owner book of this range.static StringRanges.getAreaRefString(Sheet sheet, int tRow, int lCol, int bRow, int rCol) Gets area reference expressionstatic StringRanges.getAreaRefString(Sheet sheet, AreaRef area) Gets area reference expressionstatic intCellOperationUtil.getAutoFitHeight(Sheet sheet, int row, int col) Calculate the autoFit cell height according its data size.static StringRanges.getCellRefString(Sheet sheet, int row, int col) Gets cell reference expression stringReturns a list of the defined names belong to the specifiedSheet;static Rangestatic Rangestatic RangeReturns the associatedXRangeof the specifiedXSheetand area.static Rangestatic RangeRanges.range(Sheet sheet, CellRegion cellRegion) static Rangestatic RangeRanges.rangeByName(Sheet sheet, String name) Returns the associatedRangeof the specified name of a NamedRange (e.g.static SheetAnchorSheetOperationUtil.toFilledAnchor(Sheet sheet, int row, int column, int widthPx, int heightPx) return aSheetAnchorbased 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 SheetModifier and TypeMethodDescriptionRangeImpl.cloneSheet(String name) RangeImpl.cloneSheetFrom(String name, Sheet sheet) RangeImpl.cloneSheetFrom(String name, Sheet sheet, boolean valueOnly) RangeImpl.createSheet(String name) RangeImpl.getSheet()Methods in io.keikai.api.impl with parameters of type SheetModifier and TypeMethodDescriptionRangeImpl.cloneSheetFrom(String name, Sheet sheet) RangeImpl.cloneSheetFrom(String name, Sheet sheet, boolean valueOnly) Constructors in io.keikai.api.impl with parameters of type Sheet -
Uses of Sheet in io.keikai.api.model
Methods in io.keikai.api.model that return SheetModifier and TypeMethodDescriptionGets sheet by sheet nameBook.getSheetAt(int index) Gets sheet by indexMethods in io.keikai.api.model with parameters of type Sheet -
Uses of Sheet in io.keikai.api.model.impl
Classes in io.keikai.api.model.impl that implement SheetMethods in io.keikai.api.model.impl with parameters of type Sheet -
Uses of Sheet in io.keikai.ui
Methods in io.keikai.ui that return SheetModifier and TypeMethodDescriptionSpreadsheet.getSelectedSheet()Gets the selected sheet, the default selected sheet is first sheet.UserActionContext.Clipboard.getSheet()UserActionContext.getSheet()Methods in io.keikai.ui with parameters of type SheetModifier and TypeMethodDescriptionbooleanget the enabled state of this actionvoidUserActionContext.setClipboard(Sheet sheet, AreaRef selection, boolean cutMode, Object info) voidSpreadsheet.traceDependents(Sheet sheet, CellRef cellRef) Trace the dependents of the reference.voidSpreadsheet.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 SheetModifier and TypeMethodDescriptionstatic SheetAbstractCommand.getSheetByUuid(Book book, String uuid) Methods in io.keikai.ui.au.in with parameters of type SheetModifier and TypeMethodDescriptionprotected static StringAbstractCommand.getSheetUuid(Sheet sheet) -
Uses of Sheet in io.keikai.ui.event
Methods in io.keikai.ui.event that return SheetModifier and TypeMethodDescriptionSheetSelectEvent.getPreviousSheet()AuxActionEvent.getSheet()CellEvent.getSheet()get SheetCellMouseEvent.getSheet()get SheetCellMultipleSelectionEvent.getSheet()get SheetChartMouseEvent.getSheet()get SheetGroupHeaderClickEvent.getSheet()Returns the current sheet.SheetEvent.getSheet()SyncFriendFocusEvent.getSheet()WidgetKeyEvent.getSheet()WidgetUpdateEvent.getSheet()Constructors in io.keikai.ui.event with parameters of type SheetModifierConstructorDescriptionAuxActionEvent(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) ChartMouseEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, String chartName, int x, int y, int keys, int clientX, int clientY) 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 SheetModifier and TypeMethodDescriptionDefaultUserActionManagerCtrl.ClipboardImpl.getSheet()DefaultUserActionManagerCtrl.UserActionContextImpl.getSheet()Methods in io.keikai.ui.impl with parameters of type SheetModifier and TypeMethodDescriptionDefaultUserActionManagerCtrl.getSupportedUserAction(Sheet sheet) DummyDataValidationHandler.loadDataValidtionJASON(Sheet sheet) voidDefaultUserActionManagerCtrl.UserActionContextImpl.setClipboard(Sheet sheet, AreaRef selection, boolean cutMode, Object info) protected voidDefaultUserActionManagerCtrl.updateClipboardEffect(Sheet sheet) booleanDummyDataValidationHandler.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 SheetModifierConstructorDescriptionClipboardImpl(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 SheetModifier and TypeMethodDescriptionbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanboolean -
Uses of Sheet in io.keikai.ui.impl.undo
Fields in io.keikai.ui.impl.undo declared as SheetModifier and TypeFieldDescriptionprotected final SheetAbstract2DCellDataStyleAction._destSheetprotected final SheetPasteCellAction._destSheetprotected final SheetPasteSpecialCellAction._destSheetprotected final SheetAbstractUndoableAction._sheetMethods in io.keikai.ui.impl.undo that return SheetModifier and TypeMethodDescriptionAbstract2DCellDataStyleAction.getRedoSheet()AbstractUndoableAction.getRedoSheet()AggregatedAction.getRedoSheet()PasteCellAction.getRedoSheet()PasteSpecialCellAction.getRedoSheet()protected SheetAbstract2DCellDataStyleAction.getReservedDestSheet()protected SheetAbstractCellDataStyleAction.getReservedSheet()protected SheetAbstractEditTextAction.getReservedSheet()protected SheetPasteCellAction.getReservedSheet()protected SheetPasteSpecialCellAction.getReservedSheet()protected SheetAbstract2DCellDataStyleAction.getReservedSrcSheet()Abstract2DCellDataStyleAction.getUndoSheet()AbstractUndoableAction.getUndoSheet()AggregatedAction.getUndoSheet()PasteCellAction.getUndoSheet()PasteSpecialCellAction.getUndoSheet()Methods in io.keikai.ui.impl.undo with parameters of type SheetModifier and TypeMethodDescriptionprotected booleanAbstractUndoableAction.isAnyCellProtected(Sheet sheet, CellRegion cellRegion) Constructors in io.keikai.ui.impl.undo with parameters of type SheetModifierConstructorDescriptionAbstract2DCellDataStyleAction(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 SheetMethods in io.keikai.ui.sys with parameters of type SheetModifier and TypeMethodDescriptionUserActionManagerCtrl.getSupportedUserAction(Sheet sheet) Returns the supported user action that should be disabledbooleanDataValidationHandler.loadDataValidtionJASON(Sheet sheet) booleanDataValidationHandler.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 SheetModifier and TypeMethodDescriptionbooleanValidationHelper.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 SheetMethods in io.keikaiex.ui.dialog with parameters of type SheetModifier and TypeMethodDescriptionstatic voidCustomSortCtrl.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 -
Uses of Sheet in io.keikaiex.ui.impl.ua
Methods in io.keikaiex.ui.impl.ua with parameters of type SheetModifier and TypeMethodDescriptionbooleanbooleanbooleanAutoFill is not disabled under sheet protection.booleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanprotected booleanprotected voidDataValidationHandler.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 SheetModifierConstructorDescriptionCellCommentAction(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)