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 only
io.keikai.api.model	Keikai Spreadsheet Model API classes.
io.keikai.api.model.impl	Keikai Spreadsheet Model API implementation classes, Internal use only
io.keikai.ui	Defines UI Component class of Keikai Spreadsheet
io.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 and Description
Sheet	Range.cloneSheet(String name) Clone this sheet; create a sheet and copy the contents of this sheet; then add to the end of the book.
Sheet	Range.cloneSheetFrom(String name, Sheet sheet) Clone from the specified source sheet to the owner book of this range.
Sheet	Range.createSheet(String name) Creates a new sheet
Sheet	Range.getSheet() Gets the sheet of this range

Methods in io.keikai.api with parameters of type Sheet

Modifier and Type	Method and Description
Sheet	Range.cloneSheetFrom(String name, Sheet sheet) Clone from the specified source sheet to the owner book of this range.
void	Exporter.export(Sheet sheet, AreaRef selection, OutputStream fos) Deprecated. since 3.5.0
void	Exporter.export(Sheet sheet, OutputStream fos) Deprecated. since 3.5.0
static String	Ranges.getAreaRefString(Sheet sheet, AreaRef area) Gets area reference expression
static String	Ranges.getAreaRefString(Sheet sheet, int tRow, int lCol, int bRow, int rCol) Gets area reference expression
static String	Ranges.getCellRefString(Sheet sheet, int row, int col) Gets cell reference expression string
static Range	Ranges.range(Sheet sheet) Returns the associated Range of the whole specified Sheet.
static Range	Ranges.range(Sheet sheet, AreaRef selection) Returns the associated Range of the specified Sheet and cell row and column.
static Range	Ranges.range(Sheet sheet, int row, int col) Returns the associated Range of the specified Sheet and cell row and column.
static Range	Ranges.range(Sheet sheet, int tRow, int lCol, int bRow, int rCol) Returns the associated XRange of the specified XSheet and area.
static Range	Ranges.range(Sheet sheet, String areaReference) Returns the associated Range of the specified Sheet and area reference string (e.g.
static Range	Ranges.rangeByName(Sheet sheet, String name) Returns the associated Range of the specified name of a NamedRange (e.g.
static SheetAnchor	SheetOperationUtil.toFilledAnchor(Sheet sheet, int row, int column, int widthPx, int heightPx) return a SheetAnchor 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 and Description
Sheet	RangeImpl.cloneSheet(String name)
Sheet	RangeImpl.cloneSheetFrom(String name, Sheet sheet)
Sheet	RangeImpl.createSheet(String name)
Sheet	RangeImpl.getSheet()

Methods in io.keikai.api.impl with parameters of type Sheet

Modifier and Type	Method and Description
Sheet	RangeImpl.cloneSheetFrom(String name, Sheet sheet)
void	ExporterImpl.export(Sheet sheet, AreaRef selection, OutputStream fos) Deprecated.
void	ExporterImpl.export(Sheet sheet, OutputStream fos) Deprecated.

Constructors in io.keikai.api.impl with parameters of type Sheet

Constructor and 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 and Description
Sheet	Book.getSheet(String name) Gets sheet by sheet name
Sheet	Book.getSheetAt(int index) Gets sheet by index

Methods in io.keikai.api.model with parameters of type Sheet

Modifier and Type	Method and 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 and Description
class	SheetImpl

Methods in io.keikai.api.model.impl with parameters of type Sheet

Modifier and Type	Method and 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 and Description
Sheet	Spreadsheet.getSelectedSheet() Gets the selected sheet, the default selected sheet is first sheet.
Sheet	UserActionContext.getSheet()
Sheet	UserActionContext.Clipboard.getSheet()

Methods in io.keikai.ui with parameters of type Sheet

Modifier and Type	Method and Description
boolean	UserActionHandler.isEnabled(Book book, Sheet sheet) get the enabled state of this action
void	UserActionContext.setClipboard(Sheet sheet, AreaRef selection, boolean cutMode, Object info)

Uses of Sheet in io.keikai.ui.au.in

Methods in io.keikai.ui.au.in that return Sheet

Modifier and Type	Method and 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 and 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 and Description
Sheet	SheetSelectEvent.getPreviousSheet()
Sheet	WidgetUpdateEvent.getSheet()
Sheet	WidgetKeyEvent.getSheet()
Sheet	SyncFriendFocusEvent.getSheet()
Sheet	SheetEvent.getSheet()
Sheet	CellMouseEvent.getSheet() get Sheet
Sheet	CellEvent.getSheet() get Sheet
Sheet	AuxActionEvent.getSheet()

Constructors in io.keikai.ui.event with parameters of type Sheet

Constructor and Description
AuxActionEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, String action, AreaRef selection, Map data)
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, int x, int y, int keys, Sheet sheet, int row, int col, int clientx, int clienty, int field) Deprecated.
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, int x, int y, int keys, Sheet sheet, int row, int col, int clientx, int clienty) Deprecated.
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)
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(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int top, int left, int bottom, int right, String pasteData)
EditboxEditingEvent(String name, org.zkoss.zk.ui.Component target, Sheet sheet, int row, int col, Object clientvalue)
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 and Description
Sheet	DefaultUserActionManagerCtrl.UserActionContextImpl.getSheet()
Sheet	DefaultUserActionManagerCtrl.ClipboardImpl.getSheet()

Methods in io.keikai.ui.impl with parameters of type Sheet

Modifier and Type	Method and 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 and 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)

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 and Description
boolean	NilHandler.isEnabled(Book book, Sheet sheet)
boolean	MoveSheetHandler.isEnabled(Book book, Sheet sheet)
boolean	InsertRowHandler.isEnabled(Book book, Sheet sheet)
boolean	InsertColumnHandler.isEnabled(Book book, Sheet sheet)
boolean	HideHeaderHandler.isEnabled(Book book, Sheet sheet)
boolean	DeleteSheetHandler.isEnabled(Book book, Sheet sheet)
boolean	DeleteRowHandler.isEnabled(Book book, Sheet sheet)
boolean	DeleteColumnHandler.isEnabled(Book book, Sheet sheet)
boolean	AbstractSheetHandler.isEnabled(Book book, Sheet sheet)
boolean	AbstractProtectedHandler.isEnabled(Book book, Sheet sheet)
boolean	AbstractHandler.isEnabled(Book book, Sheet sheet)
boolean	AbstractCellHandler.isEnabled(Book book, Sheet sheet)
boolean	AbstractBookHandler.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 and Description
protected Sheet	PasteSpecialCellAction._destSheet
protected Sheet	PasteCellAction._destSheet
protected Sheet	Abstract2DCellDataStyleAction._destSheet
protected Sheet	AbstractUndoableAction._sheet

Methods in io.keikai.ui.impl.undo that return Sheet

Modifier and Type	Method and Description
Sheet	PasteSpecialCellAction.getRedoSheet()
Sheet	PasteCellAction.getRedoSheet()
Sheet	AggregatedAction.getRedoSheet()
Sheet	AbstractUndoableAction.getRedoSheet()
Sheet	Abstract2DCellDataStyleAction.getRedoSheet()
protected Sheet	Abstract2DCellDataStyleAction.getReservedDestSheet()
protected Sheet	PasteSpecialCellAction.getReservedSheet()
protected Sheet	PasteCellAction.getReservedSheet()
protected Sheet	AbstractEditTextAction.getReservedSheet()
protected Sheet	AbstractCellDataStyleAction.getReservedSheet()
protected Sheet	Abstract2DCellDataStyleAction.getReservedSrcSheet()
Sheet	PasteSpecialCellAction.getUndoSheet()
Sheet	PasteCellAction.getUndoSheet()
Sheet	AggregatedAction.getUndoSheet()
Sheet	AbstractUndoableAction.getUndoSheet()
Sheet	Abstract2DCellDataStyleAction.getUndoSheet()

Methods in io.keikai.ui.impl.undo with parameters of type Sheet

Modifier and Type	Method and Description
protected boolean	AbstractUndoableAction.isAnyCellProtected(Sheet sheet, CellRegion cellRegion)

Constructors in io.keikai.ui.impl.undo with parameters of type Sheet

Constructor and 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, boolean srcWholeColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, boolean destWholeColumn, int reserveType) Deprecated.
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, boolean wholeColumn, int reserveType) Deprecated.
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) Deprecated.
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 editText)
CellEditTextAction(String label, Sheet sheet, int row, int column, int lastRow, int lastColumn, String[][] editTexts)
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)
CutCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, boolean srcWholeColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, boolean destWholeColumn) Deprecated.
CutCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn) Deprecated.
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)
PasteCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, boolean srcWholeColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn, boolean destWholeColumn) Deprecated.
PasteCellAction(String label, Sheet sheet, int srcRow, int srcColumn, int srcLastRow, int srcLastColumn, Sheet destSheet, int destRow, int destColumn, int destLastRow, int destLastColumn) Deprecated.
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, boolean desc) Deprecated.
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 and Description
Sheet	UndoableAction.getRedoSheet()
Sheet	UndoableAction.getUndoSheet()

Methods in io.keikai.ui.sys with parameters of type Sheet

Modifier and Type	Method and Description
Set<String>	UserActionManagerCtrl.getSupportedUserAction(Sheet sheet) Returns the supported user action that should be disabled
boolean	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 and 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 and Description
protected Sheet	CustomSortCtrl.sheet

Methods in io.keikaiex.ui.dialog with parameters of type Sheet

Modifier and Type	Method and 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 and 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 and Description
boolean	UnhideSheetHandler.isEnabled(Book book, Sheet sheet)
boolean	ReapplyFilterHandler.isEnabled(Book book, Sheet sheet)
boolean	InsertCommentHandler.isEnabled(Book book, Sheet sheet)
boolean	HyperlinkHandler.isEnabled(Book book, Sheet sheet)
boolean	HideSheetHandler.isEnabled(Book book, Sheet sheet)
boolean	HeaderSizeHandler.isEnabled(Book book, Sheet sheet)
boolean	EditCommentHandler.isEnabled(Book book, Sheet sheet)
boolean	DeleteCommentHandler.isEnabled(Book book, Sheet sheet)
boolean	CustomSortHandler.isEnabled(Book book, Sheet sheet)
boolean	CleanFilterHandler.isEnabled(Book book, Sheet sheet)
boolean	AutoFillHandler.isEnabled(Book book, Sheet sheet) AutoFill is not disabled under sheet protection.
boolean	ApplyFilterHandler.isEnabled(Book book, Sheet sheet)
boolean	AbstractObjectHandler.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 and 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)