ASP.NET MVC Controls | ComponentOne
C1.Web.Mvc.Sheet Namespace / FlexSheet Class
Properties Methods


In This Topic
    FlexSheet Class Members
    In This Topic

    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 the value to indicates whether enable autofill, the feature to fill cells with data that follows a pattern by dragging the bottom right corner of the cell.  
    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 or sets a value that determines whether extending selections with the mouse or keyboard should change the start (cursor) or the end of the current selection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets the FlexSheet appended sheets.  
    Public PropertyGets or sets the aria label property of cells host. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    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 resize the rows when the data or grid layout change. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    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 or sets a value that determines whether the checkboxes used to edit boolean columns should extend to cover the whole cell width. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets the templates applied in bottom left cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets or sets the number of digits after the decimal point to round to when calculating formulas. Negative value means that no rounding is performed.  
    Public PropertyGets or sets a value that determines whether searches performed while the user types should case-sensitive. (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 or sets a value that indicates how the grid commit empty edits to cell values. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets the child components. (Inherited from C1.Web.Mvc.Component)
    Public PropertyGets or sets copied header cells when copying the content to the clipboard. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    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 the static object that defines the default width for auto-generated grid columns based on their types. (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 or sets a value that determines whether the grid should automatically expand the selection to include cells in merged ranges when copying or pasting content to/from the clipboard. (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 PropertyGets or sets a value that determines the position of group summary row in the group. This property does not work if ChildItemsPath property is set. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets or sets a value that determines whether the row and column headers are focusable. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    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 PropertyOverridden. Gets or sets the action to perform when the TAB key is pressed.  
    Public PropertyGets or sets whether the grid should skip rendering cells that were updated in the last render cycle. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets and sets the url of load action.  
    Public PropertyOccurs after has performed the auto-fill operation.  
    Public PropertyOccurs before performing the auto-fill operation.  
    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 as columns are pinned. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyOccurs as columns are pinning. (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 when pasting, paste all cells or only not empty cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets or sets how the grid pins the column headers by clicking the icons toggles the column's frozen state (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 PropertyGets or sets a value that determines whether the grid should keep whitespace in cells as they appear in the data or whether it should collapse the whitespace into a single space character (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 whether the grid should refresh all cells after a cell is edited. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    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 PropertyGets or sets a value that determines whether the grid should use the column headers as placeholders when editing cells. This property only works with the grid's built-in editor. This property is not useful in IE. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    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 PropertyGets or sets a value that determines whether when copying, skip cells that have been merged. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyOverridden. Gets or sets how the grid sort columns by clicking the column header cells.  
    Public PropertyOverridden. Gets or sets the index of row in the column header panel that shows and changes the current sort.  
    Public PropertyGets or sets a value that determines whether column headers should remain when the user scrolls the window. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
    Public PropertyGets or sets a value of the tabindex attribute associated with the control. (Inherited from C1.Web.Mvc.Control)
    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
    Protected Properties
     NameDescription
    Protected PropertyGets or sets a boolean value indicates whether child components are created. (Inherited from C1.Web.Mvc.Component)
    Protected PropertyGets a boolean value indicates whether current component has the scripts which need to be rendered. (Inherited from C1.Web.Mvc.Component)
    Protected PropertyGets the System.Web.UI.HtmlTextWriterTag value that corresponds to this Web server control. This property is used primarily by control developers. (Inherited from C1.Web.Mvc.Control)
    Protected PropertyGets the url helper. (Inherited from C1.Web.Mvc.Component)
    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
    Protected Methods
     NameDescription
    Protected MethodOverridden. Creates child components.  
    Protected MethodEnsure the child components created. (Inherited from C1.Web.Mvc.Component)
    Protected MethodThis method is performed before rendering. (Inherited from C1.Web.Mvc.Control)
    Protected MethodOverridden. Registers the start-up script.  
    Protected MethodRenders the html attributes of control. (Inherited from C1.Web.Mvc.Control)
    Protected MethodRenders begin tag of control. (Inherited from C1.Web.Mvc.Control)
    Protected MethodRenders content of control. (Inherited from C1.Web.Mvc.Control)
    Protected MethodRenders end tag of control. (Inherited from C1.Web.Mvc.Control)
    Protected MethodRenders the control markup. (Inherited from C1.Web.Mvc.Control)
    Top
    Extension Methods
     NameDescription
    Public Extension MethodRender the html string in template mode.
    Top
    See Also