ComponentOne ASP.NET MVC Controls
FlexSheet Class Members
Properties  Methods 

C1.Web.Mvc.Sheet Namespace : FlexSheet Class

The following tables list the members exposed by FlexSheet.

Public Constructors
 NameDescription
Public ConstructorCreates one FlexSheet instance.  
Top
Public Properties
 NameDescription
Public PropertyGets or sets a value that indicates whether the grid should provide a new row template so users can add items to the source collection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value that indicates whether the grid should delete selected rows when the user presses the Delete key. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets or sets whether users are allowed to drag rows and/or columns with the mouse.  
Public PropertyGets or sets which parts of the grid provide cell merging. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets or sets whether users are allowed to resize rows and/or columns with the mouse.  
Public PropertyOverridden. Gets or sets whether users are allowed to sort columns by clicking the column header cells.  
Public PropertyGets or sets a value that determines the number of regular rows between 'alternating' rows. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets the FlexSheet appended sheets.  
Public PropertyGets or sets whether the grid should handle clipboard shortcuts. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets or sets whether the grid should generate columns automatically based on the itemsSource.  
Public PropertyGets or sets a value that determines whether the grid should automatically scroll its contents while users drag rows or columns into new positions. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value that determines whether the grid should search for cells as the users types into read-only cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets which cells should be taken into account when auto-sizing a row or column. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets the templates applied in bottom left cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets the templates for the content cells.  
Public PropertyOverridden. Gets or sets the name of the property used to generate child rows in hierarchical grids.  
Public PropertyGets or sets a value that determines whether the FlexGrid should clone frozen cells and show them in a separate element to improve perceived performance while scrolling. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the text for the group row header in the column footers panel. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets the templates applied in column footers cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets the templates applied in the column header cells.  
Public PropertyGets or sets a JSON string that defines the current column layout." remarks="The column layout string represents an array with the columns and their properties. It can be used to persist column layouts defined by users so they are preserved across sessions, and can also be used to implement undo/redo functionality in applications that allow users to modify the column layout. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets the grid's column collection.  
Public PropertyGets the child components. (Inherited from C1.Web.Mvc.Component)
Public PropertyGets or sets the css class of the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets the CSS style applied in the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets or sets the default size of columns in the column collection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the default size of rows in the row collection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets whether row and column resizing should be deferred until. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets a collection of the DefinedName objects representing named ranges/expressions defined in the FlexSheet.  
Public PropertyGets or sets the value to indicates whether enable drag and drop rows or columns in FlexSheet.  
Public PropertyGets or sets the value to indicates whether enable formulas in FlexSheet.  
Public PropertyGets the error tooltip of FlexGrid. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets the extender collection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the path of the xlsx file.  
Public PropertyGets or sets the Stream of the xlsx file.  
Public PropertyGets the filter settings for this FlexSheet.  
Public PropertyGets or sets the number of frozen columns. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the number of frozen columns. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets or sets the format string used to create the group header content.  
Public PropertyOverridden. Gets or sets a value that determines whether the row and column headers are visible.  
Public Property (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the height of the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets the HTML attributes. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets or sets the component id. (Inherited from C1.Web.Mvc.Component)
Public PropertyGets or sets a value that determines whether the grid should support Input Method Editors (IME) while not in edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value that determines whether the control is disabled. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets or sets whether the user can edit the grid cells by typing into them. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value indicating whether the TabHolder is visible.  
Public PropertyGets or sets a boolean value which indicates whether transfer this control to template mode. (Inherited from C1.Web.Mvc.Control)
Public PropertyOverridden. Gets or sets a formatter function used to customize cells on this grid.  
Public PropertyOverridden. Gets or sets ItemsSource settings.  
Public PropertyOverridden. Gets or sets the ItemsSourceId specify which CollectionViewService will be used for this control.  
Public PropertyGets or sets a validator function to determine whether cells contain valid data. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the action to perform when the ENTER key is pressed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the action to perform when the TAB key is pressed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets and sets the url of load action.  
Public PropertyOccurs after the user auto-sizes a column by double-clicking the right edge of a column header cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after the user auto-sizes a row by double-clicking the bottom edge of a row header cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs before the user auto-sizes a column by double-clicking the right edge of a column header cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs before the user auto-sizes a row by double-clicking the bottom edge of a row header cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when begin dropping the rows or the columns of the FlexSheet.  
Public PropertyOccurs before a cell enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when a cell edit has been committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when a cell edit is ending. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after inserting or deleting columns.  
Public PropertyOccurs after the user has copied the selection content to the clipboard by pressing one of the clipboard shortcut keys (see the autoClipboard property). (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user is copying the selection content to the clipboard by pressing one of the clipboard shortcut keys (see the autoClipboard property). (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after the user has deleted a row by pressing the Delete key. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user is deleting a selected row by pressing the Delete key (see the allowDelete property). (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user finishes dragging a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user finishes dragging a row. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user starts dragging a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs as the user drags a column to a new position. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user starts dragging a row. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when dragging the rows or the columns of the FlexSheet.  
Public PropertyOccurs as the user drags a row to a new position. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when end dropping the rows or the columns of the FlexSheet.  
Public PropertyOccurs when an element representing a cell has been created. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the control gets the focus. (Inherited from C1.Web.Mvc.Control)
Public PropertyOccurs after a group has been expanded or collapsed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when a group is about to be expanded or collapsed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after the grid has been bound to a new items source. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after the grid has been bound to a new items source. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after the @see:FlexSheet loads the @see:Workbook instance.  
Public PropertyOccurs after the grid rows have been bound to the data source. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs before the grid rows are bound to the data source. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the control loses the focus. (Inherited from C1.Web.Mvc.Control)
Public PropertyOccurs after the user has pasted content from the clipboard by pressing one of the clipboard shortcut keys (see the autoClipboard property). (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after the user has pasted content from the clipboard into a cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user is pasting content from the clipboard by pressing one of the clipboard shortcut keys (see the autoClipboard property). (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user is pasting content from the clipboard into a cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when an editor cell is created and before it becomes active. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs before inserting or deleting columns.  
Public PropertyOccurs before inserting or deleting rows.  
Public PropertyOccurs after the control has refreshed its contents. (Inherited from C1.Web.Mvc.Control)
Public PropertyOccurs when the control is about to refresh its contents. (Inherited from C1.Web.Mvc.Control)
Public PropertyOccurs after remote loading the data from sever.  
Public PropertyOccurs before remote loading the data from server.  
Public PropertyOccurs when saving the file back to sever successfully.  
Public PropertyOccurs before saving the file back to server.  
Public PropertyOccurs when the user finishes resizing a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user finishes resizing rows. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs as columns are resized. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs as rows are resized. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the user creates a new item by editing the new row template (see the allowAddNew property). (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after inserting or deleting rows.  
Public PropertyOccurs when a row edit has been committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when a row edit is ending, before the changes are committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after a row enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs before a row enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs after the control has scrolled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when current sheet index changed.  
Public PropertyOccurs after selection changes. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs before selection changes. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the FlexSheet is cleared.  
Public PropertyOccurs after the visible of the sheet in the sheet collection of the FlexSheet has changed.  
Public PropertyOccurs when the @see:FlexSheet meets the unknown formula.  
Public PropertyOccurs after the grid has updated its internal layout. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the grid finishes creating/updating the elements that make up the current view. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs before the grid updates its internal layout. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOccurs when the grid starts creating/updating the elements that make up the current view. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value that determines whether the grid should preserve the expanded/collapsed state of nodes when the data is refreshed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value that determines whether the grid should preserve the selected state of rows when the data is refreshed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets or sets a value that determines whether the grid should optimize performance over precision when auto-sizing columns.  
Public PropertyGets or sets the name of the property used to create row header cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOverridden. Gets the templates applied in row header cells.  
Public PropertyGets and sets the url of save action.  
Public PropertyGets or sets the type of remote saving data.  
Public PropertyGets or sets the position of the grid's scrollbars. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the value specify whether to scroll the seletion into view.  
Public PropertyGets or sets the index of the current sheet in the FlexSheet.  
Public PropertyGets or sets the current selection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the current selection mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the selector to macth the dom element(s) which the control is attached to. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets or sets a value that determines whether the grid should add the 'wj-alt' class to cells in alternating rows. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a bool value which indicates whether to show a group row to display the aggregates in the column footers panel. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value that indicates whether the grid adds drop-down buttons to the cells in columns that have the ShowDropDown property set to true. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets a value that determines whether the grid should add the 'wj-state-invalid' class to cells that contain validation errors, and tooltips with error descriptions. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the visibility of the filter icon.  
Public PropertyOverridden. Gets or sets whether the grid should insert group rows to delimit data groups.  
Public PropertyOverridden. Gets or sets a value that indicates whether the grid should display a marquee element around the current selection.  
Public PropertyOverridden. Gets or sets a value that indicates whether the grid should add class names to indicate selected header cells.  
Public PropertyOverridden. Gets or sets whether the grid should display sort indicators in the column headers.  
Public PropertyOverridden. Gets or sets the index of row in the column header panel that shows and changes the current sort.  
Public PropertyOverridden. Gets or sets a value that determines whether column headers should remain when the user scrolls the window.  
Public PropertyGets the collection of the template bindings. (Inherited from C1.Web.Mvc.Control)
Public PropertyOverridden. Gets the templates for the topleft cells.  
Public PropertyOverridden. Gets or sets the indent used to offset row groups of different levels.  
Public PropertyGets a value which represents the unique id for the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets or sets a value that determines whether the grid should remain in edit mode when the user tries to commit edits that fail validation. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the minimum number of rows and/or columns required to enable virtualization. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGets or sets the width of the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyGets or sets the Workbook model.  
Top
Public Methods
 NameDescription
Public MethodRender the component result to the writer. (Inherited from C1.Web.Mvc.Control)
Public MethodReturns an HTML-encoded string. (Inherited from C1.Web.Mvc.Component)
Top
Extension Methods
 NameDescription
Public Extension MethodRender the html string in template mode.
Top
See Also

Reference

FlexSheet Class
C1.Web.Mvc.Sheet Namespace