Scripting Members

Here is the reference for client-side scripting properties, methods, events, and touch support classes that are made available. The members are listed in this table organized by member type, but are presented in alphabetical order by name.

Properties

Member	Summary
Properties
ActiveCol	Gets or sets the index of the column of the active cell.
ActiveRow	Gets or sets the index of the row of the active cell.
TapToAddSelection	Gets or sets whether to allow adding a selection by tapping

Methods

Member	Summary
Methods
Add	Inserts a new row at the end of the sheet.
AddKeyMap	Adds a key map.
AddSelection	Adds a selection.
CallBack	Calls back to the ASPX page.
Cancel	Cancels the changes since the most recent postback.
Cells	Represents a cell on the client side.
Clear	Clears the contents of the selected cells.
ClearSelection	Clears all the selections in the display.
Columns	Represents a column on the client side.
Copy	Copies the contents of the selected cells to the Clipboard.
CopyLikeExcel	Copies the contents of the selected cells to the Clipboard.
CutLikeExcel	Cuts the contents of the selected cells to the Clipboard.
Delete	Deletes the row with the active cell.
Edit	Starts editing one row.
EndEdit	Ends edit mode for the cell being edited.
ExpandRow	Expands or collapses the specified row.
GetActiveChart	Gets the active chart.
GetActiveChildSheetView	Gets the child Spread object of the active sheet.
GetActiveCol	Gets the index of the column of the active cell.
GetActiveRow	Gets the index of the row of the active cell.
GetCellByRowCol	Gets the table cell for the specified row and column.
GetChildSpread	Gets the child Spread object of the specified relation at the specified row.
GetChildSpreads	Gets an array of child Spread objects of the displayed page.
GetColByKey	Gets the index number of the column for the specified key.
GetColCount	Gets the number of columns in the displayed page.
GetColKeyFromCol	Gets the column key index for the specified column.
GetCurrentPageIndex	Gets the current page index.
GetFormula	Gets the formula in the cell of the specified row and column.
GetHiddenValue	Gets the value of a programmatically hidden cell at the specified row and column.
GetLeftColIndex	Gets the column index of the top, left cell.
GetLocked	Gets whether the cell at the specified row and column is locked.
GetPageCount	Gets the number of pages.
GetParentRowIndex	Gets the row index of the parent Spread object of the displayed Spread object.
GetParentSpread	Gets the parent Spread object of the displayed Spread object.
GetRowByKey	Gets the index number of the row for the specified key.
GetRowCount	Gets the number of rows in the displayed page.
GetRowKeyFromRow	Gets the row key index number for the specified row.
GetSelectedRange	Gets the range of cells that are selected on the displayed page.
GetSelectedRanges	Gets the ranges of cells that are selected on the displayed page.
GetSheetColIndex	Gets the SheetView column index for the specified column of the displayed Spread object.
GetSheetRowIndex	Gets the SheetView row index for the specified row of the displayed Spread object.
GetSpread	Gets the Spread object with the specified HTML element.
GetTitleInfo	Gets the title for the Spread component.
GetTopRowIndex	Gets the row index of the top, left cell.
GetTotalRowCount	Gets the row count for the active sheet.
GetValue	Gets the value of a cell in the specified row and column.
HideMessage	Hides the message from the ShowMessage method.
Insert	Inserts a new row before the row with the active cell.
IsValid	Returns whether the last value the user typed is valid.
LoadData	Loads the data in the background.
MoveToFirstColumn	Moves the active cell to the first column.
MoveToLastColumn	Moves the active cell to the last column.
MoveToNextCell	Moves the active cell to the next cell.
MoveToNextRow	Moves the active cell to the next row.
MoveToPrevCell	Moves the active cell to the previous cell.
MoveToPrevRow	Moves the active cell to the previous row.
Next	Changes the display to show the next page.
Paste	Pastes the Clipboard contents to the cells.
PasteLikeExcel	Pastes the Clipboard contents to the cells.
Prev	Changes the display to show the previous page.
Print	Prints the sheet.
PrintPDF	Prints the sheet to a PDF document.
RemoveKeyMap	Removes the assigned action from the mapped key.
ResumeLayout	Resumes the layout.
Rows	Sets or returns the height of the row.
ScrollTo	Moves the specified cell to the top, left corner of the view area.
SetActiveCell	Sets the active cell to the cell at the specified row and column.
SetActiveChart	Sets the active chart.
SetBackColor	Sets the backcolor of the cell at the specified row and column.
SetColWidth	Sets a column to a specified width.
SetForeColor	Sets the forecolor of the cell at the specified row and column.
SetFormula	Sets the formula in a cell at the specified row and column.
SetHiddenValue	Sets a value in a hidden cell.
SetLocked	Sets whether the cell at the specified row and column is locked.
SetSelectedRange	Sets the specified range of cells as selected.
SetValue	Sets a value of the cell at the specified row and column.
ShowMessage	Shows an error message.
SizeToFit	Sets the size of the column width to the maximum text width for each column.
SortColumn	Sorts the specified column.
StartEdit	Puts a cell into edit mode to allow editing the cell.
SuspendLayout	Temporarily suspends the layout.
Update	Saves the changes to the Spread object back to the server.
UpdatePostBackData	Saves the changes to the postback data.

Events

Member	Summary
Events
onActiveCellChanged	Occurs when the active cell is changed from the current one to a new one.
onActiveCellChanging	Occurs when the active cell is changing from the current one to a new one.
onAutoFilteredColumn	Occurs when the client receives the filtering result from the server.
onAutoFilteringColumn	Occurs when the user selects a filter item.
onCallBackStart	Occurs just before the component makes a request to the ASPX page.
onCallBackStopped	Occurs after the component gets the result from the callback request to the ASPX page.
onColumnDragMove	Occurs when the user drops a column at the destination location.
onColumnDragMoveCompleted	Occurs after the Spread component completes moving the column.
onColWidthChanged	Occurs after the Spread component completes resizing the column.
onContextMenuClosed	Occurs when the menu is closed.
onContextMenuOpened	Occurs when the menu is shown.
onContextMenuOpening	Occurs when the menu is being shown.
onCopyData	Occurs when the user copies data.
onDataChanged	Occurs when the value of a cell is changed.
onEditStart	Occurs when the user begins to edit a cell.
onEditStopped	Occurs when cell editing is done.
onErrorMessageShown	Occurs when an error message is displayed client side.
onLoadRowsStart	Occurs when rows start loading with the background load on demand.
onLoadRowsStopped	Occurs when rows finish loading with the background load on demand.
onMenuClicked	Occurs when an item on the menu is clicked.
onRowHeightChanged	Occurs after the Spread component completes resizing the row.
onScroll	Occurs when the sheet is scrolled.
onSelectionChanged	Occurs when the selection is finished changing.
onTouchStripClosed	Occurs when the touch strip is closed.
onTouchStripOpened	Occurs when the touch strip is opened.
onTouchStripOpening	Occurs when the touch strip is being opened.

Classes

Class	Summary
MenuItem	Creates menu items.
TouchStrip	Creates the touch strip.
TouchStripItem	Creates touch strip menu items.