Version

SpreadsheetWrapper Class Members

The following tables list the members exposed by SpreadsheetWrapper.

Public Constructors
 NameDescription
Public ConstructorSpreadsheetWrapper ConstructorConstructor of the Spreadsheet wrapper.  
Public Properties
 NameDescription
Public PropertyModelA reference to the model SpreadsheetModel for this wrapper.  
Public Methods
 NameDescription
Public MethodActiveCellGets sets the A1 format address of the current active cell within the selected worksheet.  
Public MethodAddClientEventModelWidgetBase.AddClientEvent  
Public MethodAllowAddWorksheetGets sets a boolean indicating whether the spreadsheet allows adding worksheets.  
Public MethodAllowDeleteWorksheetGets sets a boolean indicating whether the spreadsheet allows deleting worksheets.  
Public MethodAreGridlinesVisibleGets sets a boolean indicating if the grid lines are displayed in the selected worksheets.  
Public MethodAreHeadersVisibleGets sets a boolean indicating if the row and column headers are displayed for the selected worksheets.  
Public MethodClientEventsModelWidgetBase.ClientEvents  
Public MethodEnterKeyNavigationDirectionReturns 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 MethodFixedDecimalPlaceCountGets sets the number of decimal places by which a whole number typed in during edit mode should be adjusted when isFixedDecimalEnabled is true.  
Public MethodHeightGets sets height of Spreadsheet.  
Public MethodHtmlAttributesSets custom attributes of the div on which the spreadsheet widget will be created.  
Public MethodIDSets the ID of the Spreadsheet.  
Public MethodIsEnterKeyNavigationEnabledGets sets a boolean indicating whether the adjacent cell indicated by the enterKeyNavigationDirection should be navigated to when the enter key is pressed.  
Public MethodIsFixedDecimalEnabledGets sets a boolean indicating if the formula bar is displayed within the Spreadsheet.  
Public MethodIsFormulaBarVisibleGets sets a boolean indicating if the formula bar is displayed within the Spreadsheet.  
Public MethodIsInEndModeGets 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 MethodIsScrollLockedGets 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 MethodIsUndoEnabledGets sets a boolean indicating whether undo is enabled for the control.  
Public MethodNameBoxWidthGets sets the width of the name box within the formula bar.  
Public MethodRenderRender the spreadsheet widget with the accumulated model changes in the wrapper.  
Public MethodSelectionModeGets sets a value indicating how the selection is updated when interacting with the cells via the mouse or keyboard.  
Public MethodValidationInputMessagePositionReturns 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 MethodWidthGets sets width of Spreadsheet.  
Public MethodWorkbookURLReturns or sets the URL of the workbook whose information is displayed in the control.  
Public MethodZoomLevelGets sets the magnification of the selected worksheets.  
See Also

View on GitHub