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 SheetRange. cloneSheet(String name)Clone this sheet; create a sheet and copy the contents of this sheet; then add it as the last sheet.SheetRange. cloneSheetFrom(String name, Sheet sheet)Clone from the specified source sheet to the owner book of this range.SheetRange. cloneSheetFrom(String name, Sheet sheet, boolean valueOnly)Clone from the specified source sheet to the owner book of this range.SheetRange. createSheet(String name)Creates a new sheet and appends it as the last sheet.SheetRange. getSheet()Gets the sheet of this rangeMethods in io.keikai.api with parameters of type Sheet Modifier and Type Method Description SheetRange. cloneSheetFrom(String name, Sheet sheet)Clone from the specified source sheet to the owner book of this range.SheetRange. 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 stringstatic List<String>Ranges. getNames(Sheet sheet)Returns a list of the defined names belong to the specifiedSheet;static RangeRanges. range(Sheet sheet)static RangeRanges. range(Sheet sheet, int row, int col)static RangeRanges. range(Sheet sheet, int tRow, int lCol, int bRow, int rCol)Returns the associatedXRangeof the specifiedXSheetand area.static RangeRanges. range(Sheet sheet, AreaRef selection)static RangeRanges. range(Sheet sheet, String areaReference)static 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 Sheet Modifier and Type Method Description SheetRangeImpl. cloneSheet(String name)SheetRangeImpl. cloneSheetFrom(String name, Sheet sheet)SheetRangeImpl. cloneSheetFrom(String name, Sheet sheet, boolean valueOnly)SheetRangeImpl. createSheet(String name)SheetRangeImpl. getSheet()Methods in io.keikai.api.impl with parameters of type Sheet Modifier and Type Method Description SheetRangeImpl. cloneSheetFrom(String name, Sheet sheet)SheetRangeImpl. 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 SheetBook. getSheet(String name)Gets sheet by sheet nameSheetBook. getSheetAt(int index)Gets sheet by indexMethods in io.keikai.api.model with parameters of type Sheet Modifier and Type Method Description intBook. 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 classSheetImplMethods in io.keikai.api.model.impl with parameters of type Sheet Modifier and Type Method Description intBookImpl. getSheetIndex(Sheet sheet) -
Uses of Sheet in io.keikai.ui
Methods in io.keikai.ui that return Sheet Modifier and Type Method Description SheetSpreadsheet. getSelectedSheet()Gets the selected sheet, the default selected sheet is first sheet.SheetUserActionContext.Clipboard. getSheet()SheetUserActionContext. getSheet()Methods in io.keikai.ui with parameters of type Sheet Modifier and Type Method Description booleanUserActionHandler. isEnabled(Book book, Sheet sheet)get 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 Sheet Modifier and Type Method Description static SheetAbstractCommand. getSheetByUuid(Book book, String uuid)Methods in io.keikai.ui.au.in with parameters of type Sheet Modifier and Type Method Description protected static StringAbstractCommand. 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 SheetSheetSelectEvent. getPreviousSheet()SheetAuxActionEvent. getSheet()SheetCellEvent. getSheet()get SheetSheetCellMouseEvent. getSheet()get SheetSheetCellMultipleSelectionEvent. getSheet()get SheetSheetGroupHeaderClickEvent. getSheet()Returns the current sheet.SheetSheetEvent. getSheet()SheetSyncFriendFocusEvent. getSheet()SheetWidgetKeyEvent. getSheet()SheetWidgetUpdateEvent. 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 SheetDefaultUserActionManagerCtrl.ClipboardImpl. getSheet()SheetDefaultUserActionManagerCtrl.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)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 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 booleanAbstractBookHandler. isEnabled(Book book, Sheet sheet)booleanAbstractCellHandler. isEnabled(Book book, Sheet sheet)booleanAbstractFilterHandler. isEnabled(Book book, Sheet sheet)booleanAbstractHandler. isEnabled(Book book, Sheet sheet)booleanAbstractProtectedHandler. isEnabled(Book book, Sheet sheet)booleanAbstractSheetHandler. isEnabled(Book book, Sheet sheet)booleanDeleteColumnHandler. isEnabled(Book book, Sheet sheet)booleanDeleteRowHandler. isEnabled(Book book, Sheet sheet)booleanDeleteSheetHandler. isEnabled(Book book, Sheet sheet)booleanHideHeaderHandler. isEnabled(Book book, Sheet sheet)booleanInsertColumnHandler. isEnabled(Book book, Sheet sheet)booleanInsertRowHandler. isEnabled(Book book, Sheet sheet)booleanMoveSheetHandler. isEnabled(Book book, Sheet sheet)booleanNilHandler. 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 SheetAbstract2DCellDataStyleAction. _destSheetprotected SheetPasteCellAction. _destSheetprotected SheetPasteSpecialCellAction. _destSheetprotected SheetAbstractUndoableAction. _sheetMethods in io.keikai.ui.impl.undo that return Sheet Modifier and Type Method Description SheetAbstract2DCellDataStyleAction. getRedoSheet()SheetAbstractUndoableAction. getRedoSheet()SheetAggregatedAction. getRedoSheet()SheetPasteCellAction. getRedoSheet()SheetPasteSpecialCellAction. getRedoSheet()protected SheetAbstract2DCellDataStyleAction. getReservedDestSheet()protected SheetAbstractCellDataStyleAction. getReservedSheet()protected SheetAbstractEditTextAction. getReservedSheet()protected SheetPasteCellAction. getReservedSheet()protected SheetPasteSpecialCellAction. getReservedSheet()protected SheetAbstract2DCellDataStyleAction. getReservedSrcSheet()SheetAbstract2DCellDataStyleAction. getUndoSheet()SheetAbstractUndoableAction. getUndoSheet()SheetAggregatedAction. getUndoSheet()SheetPasteCellAction. getUndoSheet()SheetPasteSpecialCellAction. getUndoSheet()Methods in io.keikai.ui.impl.undo with parameters of type Sheet Modifier and Type Method Description protected booleanAbstractUndoableAction. 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 SheetUndoableAction. getRedoSheet()SheetUndoableAction. 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 disabledbooleanSortHandler. isEnabled(Book book, Sheet sheet)List<Map<String,Object>>DataValidationHandler. 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 Sheet Modifier and Type Method Description booleanValidationHelper. 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 SheetCustomSortCtrl. sheetMethods in io.keikaiex.ui.dialog with parameters of type Sheet Modifier and Type Method Description static 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 Modifier and Type Method Description List<Map<String,Object>>DataValidationHandlerImpl. loadDataValidtionJASON(Sheet sheet)booleanDataValidationHandlerImpl. 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 booleanAbstractObjectHandler. isEnabled(Book book, Sheet sheet)booleanApplyFilterHandler. isEnabled(Book book, Sheet sheet)booleanAutoFillHandler. isEnabled(Book book, Sheet sheet)AutoFill is not disabled under sheet protection.booleanCleanFilterHandler. isEnabled(Book book, Sheet sheet)booleanCustomSortHandler. isEnabled(Book book, Sheet sheet)booleanDeleteCommentHandler. isEnabled(Book book, Sheet sheet)booleanEditCommentHandler. isEnabled(Book book, Sheet sheet)booleanHeaderSizeHandler. isEnabled(Book book, Sheet sheet)booleanHideSheetHandler. isEnabled(Book book, Sheet sheet)booleanHyperlinkHandler. isEnabled(Book book, Sheet sheet)booleanInsertCommentHandler. isEnabled(Book book, Sheet sheet)booleanReapplyFilterHandler. isEnabled(Book book, Sheet sheet)booleanUnhideSheetHandler. isEnabled(Book book, Sheet sheet)protected booleanHideSheetHandler. isHidden(Sheet sheet)protected 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 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)
-