Spread for ASP.NET 9.0 Product Documentation
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  
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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback