# Methods

This topic lists the various client-side scripting methods available in Spread for ASP.NET

## Content

Here are the client-side scripting methods. The members are listed in alphabetical order by name.

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

For an introduction to scripting, refer to the [Scripting Overview](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-overview).