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