The following tables list the members exposed by SpreadsheetModel.
| Name | Description | |
|---|---|---|
 | SpreadsheetModel Constructor | Create Spreadsheet |
| Name | Description | |
|---|---|---|
 | ActiveCell | Gets sets the A1 format address of the current active cell within the selected worksheet. |
| AllowAddWorksheet | Gets sets a boolean indicating whether the spreadsheet allows adding worksheets. |
| AllowDeleteWorksheet | Gets sets a boolean indicating whether the spreadsheet allows deleting worksheets. |
| AreGridlinesVisible | Gets sets a boolean indicating if the grid lines are displayed in the selected worksheets. |
| AreHeadersVisible | Gets sets a boolean indicating if the row and column headers are displayed for the selected worksheets. |
| ClientEvents | Set implementations of client events raised by a widget. Event handler assumes 2 parameters: 1st parameter has name "evt" and 2nd parameter has name "ui". To get information about member variables available for "ui" parameter, please consult documentation of a widget and its events. Examples: 1. Full implementation: new Dictionary<string, string> { { "dropDownOpening", "function(evt,ui){alert('drop:'+ui.owner);}" } } 2. Content of inline function: new Dictionary<string, string> { { "dropDownOpening", "alert('drop:'+ui.owner);" } } 3. Name of global function: new Dictionary<string, string> { { "dropDownOpening", "nameOfGlobalFunction" } } Note: Instead of explicit key-strings, which represent name of event exposed by a widget, the event-constants defined by a particular control can be used. Example: new Dictionary<string, string> { { ComboClientEvents.DropDownOpening, "nameOfGlobalFunction" } } (Inherited from Infragistics.Web.Mvc.ModelWidgetBase) |
| EnterKeyNavigationDirection | Returns or sets an enumeration indicating the direction of the cell adjacent to the activeCell that should be activated when the enter key is pressed. This property is only used if the isEnterKeyNavigationEnabled is set to true. Also, the reverse direction is navigated when Shift + Enter are pressed. |
| FixedDecimalPlaceCount | Gets sets the number of decimal places by which a whole number typed in during edit mode should be adjusted when isFixedDecimalEnabled is true. |
| Height | Gets sets height of Spreadsheet. |
| HtmlAttributes | Sets custom attributes of the div on which the spreadsheet widget will be created. |
| ID | Sets the ID of the Spreadsheet. |
| IsEnterKeyNavigationEnabled | Gets sets a boolean indicating whether the adjacent cell indicated by the enterKeyNavigationDirection should be navigated to when the enter key is pressed. |
| IsFixedDecimalEnabled | Gets sets a boolean indicating if the formula bar is displayed within the Spreadsheet. |
| IsFormulaBarVisible | Gets sets a boolean indicating if the formula bar is displayed within the Spreadsheet. |
| IsInEndMode | Gets sets a boolean indicating whether the control is in "End mode". End mode is a mode that affects certain keyboard navigation such as navigating with the arrow keys. For example when in end mode and one presses the right arrow, the activeCell will be changed to be the first cell to the right of the current ActiveCell that has a value(even if the value is ""). If there were no cells to the right with a value then it would activate the right most cell in that row. End mode will end automatically such as when one presses an arrow key. |
| IsScrollLocked | Gets sets a boolean indicating whether the scroll lock key is toggled. This property is used when certain keys are pressed while the control has focus. For example if an arrow key is pressed while the scroll lock is enabled the cell area will be scrolled rather than changing the active cell. Note: This property is not maintained/changed by the control. It is just queried when performing actions that consider whether the scroll lock is enabled. |
| IsUndoEnabled | Gets sets a boolean indicating whether undo is enabled for the control. |
| NameBoxWidth | Gets sets the width of the name box within the formula bar. |
| SelectionMode | Gets sets a value indicating how the selection is updated when interacting with the cells via the mouse or keyboard. |
| ValidationInputMessagePosition | Returns or sets the position of the screen tip used to display the input message for the data validation rule associated with the active cell. |
| Width | Gets sets width of Spreadsheet. |
| WorkbookURL | Returns or sets the URL of the workbook whose information is displayed in the control. |
| ZoomLevel | Gets sets the magnification of the selected worksheets. |
| Name | Description | |
|---|---|---|
 | Store | Return the store with all of the options (Inherited from Infragistics.Web.Mvc.ModelBase) |
| Name | Description | |
|---|---|---|
 | AddClientEvent | Adds javascript function to process client event of widget. (Inherited from Infragistics.Web.Mvc.ModelWidgetBase) |
| ToJson | Serializes the object to JSON. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| Name | Description | |
|---|---|---|
 | Camelize | Converts the provided string to camel case. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| EnsureClientEvents | Adds client events to Serializes the internal model store into json. (Inherited from Infragistics.Web.Mvc.ModelWidgetBase) |
| GetBool | Gets the value of a bool property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetChar | Sets the value of a char property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetDateTime | Gets the value of a DateTime property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetDouble | Gets the value of a double property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetIEnumerable<T> | Gets the value of an IEnumerable property of the model. If the value is null a new IEnumerable of type T will be created. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetInt | Gets the value of an int property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetJSLiteral | Sets the value of a literal property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetLong | Gets the value of a long property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetModel<T> | Gets the value of an IModel property of the model. If the value is null a new model of type T will be created. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetString | Gets the value of a string property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetStringEnum<T> | Gets the value of a string property whose values are the lowercase values of an Enum. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetValue<T> | Gets a property value of arbitrary type. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| GetValueModel<T> | Gets the value of an IModel property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromBool | Serializes a bool object into json. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromDateTime | Serializes a DateTime object into json Date object. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromDouble | Serializes a double object into json. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromFloat | Serializes a float object into json. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromIDictionary | Serializes an IDictionary of objects into json. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromIEnumerable | Serializes an IEnumerable object into json. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromInt | Serializes an int object into json. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromModelStore | Serializes the internal model store into json. (Inherited from Infragistics.Web.Mvc.ModelWidgetBase) |
| JsonFromObject | Serializes an arbitrary object in json using the typed serialization methods. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| JsonFromString | Serializes a string object into json string, escaping all single quotes. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetBool | Sets a value to a bool property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetBrush | (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetCamelizedStringEnum<T> | Sets the value of a string property whose values are the lowercase values of an Enum. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetChar | Gets the value of a char property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetDateTime | Sets a value to a DateTime property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetDouble | Sets a value to a double property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetIEnumerable<T> | Sets a value to an IEnumerable property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetInt | Sets a value to an int property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetJSLiteral | Gets the value of a literal property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetLong | Sets a value to a long property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetModel<T> | Sets a value to an IModel property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetString | Sets a value to a string property of the model. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetStringEnum<T> | Sets the value of a string property whose values are the lowercase values of an Enum. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| SetValue<T> | Sets a property value of arbitrary type. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| TransformData | Transforms the data. (Inherited from Infragistics.Web.Mvc.ModelBase) |
| ValidValueType<T> | Checks type for value of existing property. Returns false as well if non existing property. (Inherited from Infragistics.Web.Mvc.ModelBase) |
View on GitHub