Version 20.1

SpreadsheetModel Class Properties

For a list of all members of this type, see SpreadsheetModel members.

Public Properties
 NameDescription
Public PropertyActiveCellGets sets the A1 format address of the current active cell within the selected worksheet.  
Public PropertyAllowAddWorksheetGets sets a boolean indicating whether the spreadsheet allows adding worksheets.  
Public PropertyAllowDeleteWorksheetGets sets a boolean indicating whether the spreadsheet allows deleting worksheets.  
Public PropertyAreGridlinesVisibleGets sets a boolean indicating if the grid lines are displayed in the selected worksheets.  
Public PropertyAreHeadersVisibleGets sets a boolean indicating if the row and column headers are displayed for the selected worksheets.  
Public PropertyClientEventsSet 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)
Public PropertyEnterKeyNavigationDirectionReturns 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.  
Public PropertyFixedDecimalPlaceCountGets sets the number of decimal places by which a whole number typed in during edit mode should be adjusted when isFixedDecimalEnabled is true.  
Public PropertyHeightGets sets height of Spreadsheet.  
Public PropertyHtmlAttributesSets custom attributes of the div on which the spreadsheet widget will be created.  
Public PropertyIDSets the ID of the Spreadsheet.  
Public PropertyIsEnterKeyNavigationEnabledGets sets a boolean indicating whether the adjacent cell indicated by the enterKeyNavigationDirection should be navigated to when the enter key is pressed.  
Public PropertyIsFixedDecimalEnabledGets sets a boolean indicating if the formula bar is displayed within the Spreadsheet.  
Public PropertyIsFormulaBarVisibleGets sets a boolean indicating if the formula bar is displayed within the Spreadsheet.  
Public PropertyIsInEndModeGets 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.  
Public PropertyIsScrollLockedGets 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.  
Public PropertyIsUndoEnabledGets sets a boolean indicating whether undo is enabled for the control.  
Public PropertyNameBoxWidthGets sets the width of the name box within the formula bar.  
Public PropertySelectionModeGets sets a value indicating how the selection is updated when interacting with the cells via the mouse or keyboard.  
Public PropertyValidationInputMessagePositionReturns or sets the position of the screen tip used to display the input message for the data validation rule associated with the active cell.  
Public PropertyWidthGets sets width of Spreadsheet.  
Public PropertyWorkbookURLReturns or sets the URL of the workbook whose information is displayed in the control.  
Public PropertyZoomLevelGets sets the magnification of the selected worksheets.  
Protected Properties
 NameDescription
Protected PropertyStoreReturn the store with all of the options (Inherited from Infragistics.Web.Mvc.ModelBase)
See Also

View on GitHub