ASP.NET MVC Controls
FlexSheet Class Members
Properties  Methods 

The following tables list the members exposed by FlexSheet.

Public Constructors
 NameDescription
Public ConstructorFlexSheet ConstructorCreate one FlexSheet instance.  
Top
Public Properties
 NameDescription
Public PropertyAllowAddNewGets 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 PropertyAllowDeleteGets 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 PropertyAllowDraggingOverridden. Gets or sets whether users are allowed to drag rows and/or columns with the mouse.  
Public PropertyAllowMergingGets or sets which parts of the grid provide cell merging. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyAllowResizingOverridden. Gets or sets whether users are allowed to resize rows and/or columns with the mouse.  
Public PropertyAllowSortingOverridden. Gets or sets whether users are allowed to sort columns by clicking the column header cells.  
Public PropertyAppendedSheetsGets the FlexSheet appended sheets.  
Public PropertyAutoClipboardGets or sets whether the grid should handle clipboard shortcuts. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyAutoGenerateColumnsOverridden. Gets or sets whether the grid should generate columns automatically based on the itemsSource.  
Public PropertyAutoSizeModeOverridden. Gets or sets which cells should be taken into account when auto-sizing a row or column.  
Public PropertyBottomLeftCellsTemplateGets the templates applied in bottom left cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyCellsTemplateOverridden. Gets the templates for the content cells.  
Public PropertyChildItemsPathOverridden. Gets or sets the name of the property used to generate child rows in hierarchical grids.  
Public PropertyColumnFootersRowHeaderTextGets or sets the text for the group row header in the column footers panel. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyColumnFootersTemplateGets the templates applied in column footers cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyColumnHeadersTemplateOverridden. Gets the templates applied in the column header cells.  
Public PropertyColumnLayoutGets 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 PropertyColumnsOverridden. Gets the grid's column collection.  
Public PropertyComponentsGets the child components. (Inherited from C1.Web.Mvc.Component)
Public PropertyCssClassGets or sets the css class of the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyCssStylesGets the CSS styles. (Inherited from C1.Web.Mvc.Control)
Public PropertyDeferResizingGets or sets whether row and column resizing should be deferred until. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyExtendersGets the extender collection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyFilePathGets or sets the path of the xlsx file.  
Public PropertyFileStreamGets or sets the Stream of the xlsx file.  
Public PropertyFrozenColumnsGets or sets the number of frozen columns. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyFrozenRowsGets or sets the number of frozen columns. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyGroupHeaderFormatOverridden. Gets or sets the format string used to create the group header content.  
Public PropertyHeadersVisibilityOverridden. Gets or sets a value that determines whether the row and column headers are visible.  
Public PropertyHeightGets or sets the height of the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyHtmlAttributesGets the HTML attributes. (Inherited from C1.Web.Mvc.Control)
Public PropertyIdGets or sets the component id. (Inherited from C1.Web.Mvc.Component)
Public PropertyImeEnabledGets 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 PropertyIsDisabledGets or sets a value that determines whether the control is disabled. (Inherited from C1.Web.Mvc.Control)
Public PropertyIsReadOnlyGets or sets whether the user can edit the grid cells by typing into them. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyIsTabHolderVisibleGets or sets a value indicating whether the TabHolder is visible.  
Public PropertyIsTemplateGets or sets a boolean value which indicates whether transfer this control to template mode. (Inherited from C1.Web.Mvc.Control)
Public PropertyItemFormatterOverridden. Gets or sets a formatter function used to customize cells on this grid.  
Public PropertyItemsSourceOverridden. Gets ItemsSource settings.  
Public PropertyItemsSourceIdOverridden. Gets or sets the ItemsSourceId specify which CollectionViewService will be used for this control.  
Public PropertyLoadActionUrlGets and sets the url of load action.  
Public PropertyOnClientAutoSizedColumnOccurs 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 PropertyOnClientAutoSizedRowOccurs 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 PropertyOnClientAutoSizingColumnOccurs 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 PropertyOnClientAutoSizingRowOccurs 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 PropertyOnClientBeginningEditOccurs before a cell enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientCellEditEndedOccurs when a cell edit has been committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientCellEditEndingOccurs when a cell edit is ending. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientColumnChangedOccurs after inserting or deleting columns.  
Public PropertyOnClientCopiedOccurs 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 PropertyOnClientCopyingOccurs 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 PropertyOnClientDeletedRowOccurs after the user has deleted a row by pressing the Delete key. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientDeletingRowOccurs 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 PropertyOnClientDraggedColumnOccurs when the user finishes dragging a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientDraggedRowOccurs when the user finishes dragging a row. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientDraggingColumnOccurs when the user starts dragging a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientDraggingColumnOverOccurs as the user drags a column to a new position. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientDraggingRowOccurs when the user starts dragging a row. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientDraggingRowColumnOccurs when dragging the rows or the columns of the FlexSheet.  
Public PropertyOnClientDraggingRowOverOccurs as the user drags a row to a new position. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientDroppingRowColumnOccurs when dropping the rows or the columns of the FlexSheet.  
Public PropertyOnClientFormatItemOccurs when an element representing a cell has been created. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientGotFocusOccurs when the control gets the focus. (Inherited from C1.Web.Mvc.Control)
Public PropertyOnClientGroupCollapsedChangedOccurs after a group has been expanded or collapsed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientGroupCollapsedChangingOccurs when a group is about to be expanded or collapsed. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientItemsSourceChangedOccurs after the grid has been bound to a new items source. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientLoadedOccurs after the @see:FlexSheet loads the @see:Workbook instance.  
Public PropertyOnClientLoadedRowsOccurs after the grid rows have been bound to the data source. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientLoadingRowsOccurs before the grid rows are bound to the data source. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientLostFocusOccurs when the control loses the focus. (Inherited from C1.Web.Mvc.Control)
Public PropertyOnClientPastedOccurs 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 PropertyOnClientPastedCellOccurs after the user has pasted content from the clipboard into a cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientPastingOccurs 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 PropertyOnClientPastingCellOccurs when the user is pasting content from the clipboard into a cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientPrepareCellForEditOccurs when an editor cell is created and before it becomes active. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientPrepareChangingColumnOccurs before inserting or deleting columns.  
Public PropertyOnClientPrepareChangingRowOccurs before inserting or deleting rows.  
Public PropertyOnClientRemoteLoadedOccurs after remote loading the data from sever.  
Public PropertyOnClientRemoteLoadingOccurs before remote loading the data from server.  
Public PropertyOnClientRemoteSavedOccurs when saving the file back to sever successfully.  
Public PropertyOnClientRemoteSavingOccurs before saving the file back to server.  
Public PropertyOnClientResizedColumnOccurs when the user finishes resizing a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientResizedRowOccurs when the user finishes resizing rows. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientResizingColumnOccurs as columns are resized. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientResizingRowOccurs as rows are resized. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientRowAddedOccurs 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 PropertyOnClientRowChangedOccurs after inserting or deleting rows.  
Public PropertyOnClientRowEditEndedOccurs when a row edit has been committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientRowEditEndingOccurs when a row edit is ending, before the changes are committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientRowEditStartedOccurs after a row enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientRowEditStartingOccurs before a row enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientScrollPositionChangedOccurs after the control has scrolled. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientSelectedSheetChangedOccurs when current sheet index changed.  
Public PropertyOnClientSelectionChangedOccurs after selection changes. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientSelectionChangingOccurs before selection changes. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientSheetClearedOccurs when the FlexSheet is cleared.  
Public PropertyOnClientSheetVisibleChangedOccurs after the visible of the sheet in the sheet collection of the FlexSheet has changed.  
Public PropertyOnClientUnknownFunctionOccurs when the @see:FlexSheet meets the unknown formula.  
Public PropertyOnClientUpdatedLayoutOccurs after the grid has updated its internal layout. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientUpdatedViewOccurs when the grid finishes creating/updating the elements that make up the current view. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientUpdatingLayoutOccurs before the grid updates its internal layout. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyOnClientUpdatingViewOccurs when the grid starts creating/updating the elements that make up the current view. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyPreserveOutlineStateGets 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 PropertyPreserveSelectedStateGets 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 PropertyRowHeadersTemplateOverridden. Gets the templates applied in row header cells.  
Public PropertySaveActionUrlGets and sets the url of save action.  
Public PropertySaveContentTypeGets or sets the type of remote saving data.  
Public PropertyScrollPositionGets or sets the position of the grid's scrollbars. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertyScrollToSelectionGets or sets the value specify whether to scroll the seletion into view.  
Public PropertySelectedSheetIndexGets or sets the index of the current sheet in the FlexSheet.  
Public PropertySelectionGets or sets the current selection. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertySelectionModeGets or sets the current selection mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>)
Public PropertySelectorGets or sets a value which specifies the selector. (Inherited from C1.Web.Mvc.Control)
Public PropertyShowAlternatingRowsGets 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 PropertyShowColumnFootersGets 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 PropertyShowErrorsGets 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 PropertyShowFilterIconsGets or sets the visibility of the filter icon.  
Public PropertyShowGroupsOverridden. Gets or sets whether the grid should insert group rows to delimit data groups.  
Public PropertyShowMarqueeOverridden. Gets or sets a value that indicates whether the grid should display a marquee element around the current selection.  
Public PropertyShowSelectedHeadersOverridden. Gets or sets a value that indicates whether the grid should add class names to indicate selected header cells.  
Public PropertyShowSortOverridden. Gets or sets whether the grid should display sort indicators in the column headers.  
Public PropertySortRowIndexOverridden. Gets or sets the index of row in the column header panel that shows and changes the current sort.  
Public PropertyStickyHeadersOverridden. Gets or sets a value that determines whether column headers should remain when the user scrolls the window.  
Public PropertyTemplateBindingsGets the collection of the template bindings. (Inherited from C1.Web.Mvc.Control)
Public PropertyTopLeftCellsTemplateOverridden. Gets the templates for the topleft cells.  
Public PropertyTreeIndentOverridden. Gets or sets the indent used to offset row groups of different levels.  
Public PropertyUniqueIdGets a value which represents the unique id for the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyValidateEditsGets 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 PropertyWidthGets or sets the width of the control. (Inherited from C1.Web.Mvc.Control)
Public PropertyWorkbookGets or sets the Workbook model.  
Top
Public Methods
 NameDescription
Public MethodRenderRender the component result to the writer. (Inherited from C1.Web.Mvc.Control)
Public MethodToHtmlStringReturns an HTML-encoded string. (Inherited from C1.Web.Mvc.Component)
Top
Extension Methods
 NameDescription
Public Extension MethodToTemplate(IHtmlString)Render the html string in template mode.
Top
See Also

Reference

FlexSheet Class
C1.Web.Mvc.Sheet Namespace

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum |  Documentation Feedback