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.
GetHiddenCellValue	Gets the value of a programmatically hidden cell at 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.
SetHiddenCellValue	Sets a value in a hidden cell.
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
ActiveCellChanged	Occurs when the active cell is changed from the current one to a new one.
ActiveCellChanging	Occurs when the active cell is changing from the current one to a new one.
AutoFilteredColumn	Occurs when the client receives the filtering result from the server.
AutoFilteringColumn	Occurs when the user selects a filter item.
CallBackStart	Occurs just before the component makes a request to the ASPX page.
CallBackStopped	Occurs after the component gets the result from the callback request to the ASPX page.
CellClicked	Occurs when the user clicks on a cell.
CellDoubleClicked	Occurs when the user double-clicks a cell.
ColumnDragMove	Occurs when the user drops a column at the destination location.
ColumnDragMoveCompleted	Occurs after the Spread component completes moving the column.
ColWidthChanged	Occurs after the Spread component completes resizing the column.
ContextMenuClosed	Occurs when the menu is closed.
ContextMenuOpened	Occurs when the menu is shown.
ContextMenuOpening	Occurs when the menu is being shown.
CopyData	Occurs when the user copies data.
DataChanged	Occurs when the value of a cell is changed.
EditStart	Occurs when the user begins to edit a cell.
EditStopped	Occurs when cell editing is done.
ErrorMessageShown	Occurs when an error message is displayed client side.
LoadRowsStart	Occurs when rows start loading with the background load on demand.
LoadRowsStopped	Occurs when rows finish loading with the background load on demand.
MenuClicked	Occurs when an item on the menu is clicked.
RowHeightChanged	Occurs after the Spread component completes resizing the row.
Scroll	Occurs when the sheet is scrolled.
SelectionChanged	Occurs when the selection is finished changing.
TouchStripClosed	Occurs when the touch strip is closed.
TouchStripOpened	Occurs when the touch strip is opened.
TouchStripOpening	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.