Spread for ASP.NET 11 Product Documentation
Scripting Members
Spread for ASP.NET 11 Product Documentation > Client-Side Scripting Reference > 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.
RowDragMove

Occurs when the user drops a row at the destination location.

RowDragMoveCompleted Occurs after the Spread component completes moving the row.
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.