C1.Web.Mvc.Sheet Namespace : FlexSheet Class |
The following tables list the members exposed by FlexSheet.
Name | Description | |
---|---|---|
FlexSheet Constructor | Create one FlexSheet instance. |
Name | Description | |
---|---|---|
AllowAddNew | Gets 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>) | |
AllowDelete | Gets 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>) | |
AllowDragging | Overridden. Gets or sets whether users are allowed to drag rows and/or columns with the mouse. | |
AllowMerging | Gets or sets which parts of the grid provide cell merging. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
AllowResizing | Overridden. Gets or sets whether users are allowed to resize rows and/or columns with the mouse. | |
AllowSorting | Overridden. Gets or sets whether users are allowed to sort columns by clicking the column header cells. | |
AppendedSheets | Gets the FlexSheet appended sheets. | |
AutoClipboard | Gets or sets whether the grid should handle clipboard shortcuts. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
AutoGenerateColumns | Overridden. Gets or sets whether the grid should generate columns automatically based on the itemsSource. | |
AutoSizeMode | Overridden. Gets or sets which cells should be taken into account when auto-sizing a row or column. | |
BottomLeftCellsTemplate | Gets the templates applied in bottom left cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
CellsTemplate | Overridden. Gets the templates for the content cells. | |
ChildItemsPath | Overridden. Gets or sets the name of the property used to generate child rows in hierarchical grids. | |
ColumnFootersRowHeaderText | Gets or sets the text for the group row header in the column footers panel. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
ColumnFootersTemplate | Gets the templates applied in column footers cells. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
ColumnHeadersTemplate | Overridden. Gets the templates applied in the column header cells. | |
ColumnLayout | Gets 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>) | |
Columns | Overridden. Gets the grid's column collection. | |
Components | Gets the child components. (Inherited from C1.Web.Mvc.Component) | |
CssClass | Gets or sets the css class of the control. (Inherited from C1.Web.Mvc.Control) | |
CssStyles | Gets the CSS styles. (Inherited from C1.Web.Mvc.Control) | |
DeferResizing | Gets or sets whether row and column resizing should be deferred until. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
Extenders | Gets the extender collection. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
FilePath | Gets or sets the path of the xlsx file. | |
FileStream | Gets or sets the Stream of the xlsx file. | |
FrozenColumns | Gets or sets the number of frozen columns. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
FrozenRows | Gets or sets the number of frozen columns. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
GroupHeaderFormat | Overridden. Gets or sets the format string used to create the group header content. | |
HeadersVisibility | Overridden. Gets or sets a value that determines whether the row and column headers are visible. | |
Height | Gets or sets the height of the control. (Inherited from C1.Web.Mvc.Control) | |
HtmlAttributes | Gets the HTML attributes. (Inherited from C1.Web.Mvc.Control) | |
Id | Gets or sets the component id. (Inherited from C1.Web.Mvc.Component) | |
ImeEnabled | Gets 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>) | |
IsDisabled | Gets or sets a value that determines whether the control is disabled. (Inherited from C1.Web.Mvc.Control) | |
IsReadOnly | Gets or sets whether the user can edit the grid cells by typing into them. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
IsTabHolderVisible | Gets or sets a value indicating whether the TabHolder is visible. | |
IsTemplate | Gets or sets a boolean value which indicates whether transfer this control to template mode. (Inherited from C1.Web.Mvc.Control) | |
ItemFormatter | Overridden. Gets or sets a formatter function used to customize cells on this grid. | |
ItemsSource | Overridden. Gets ItemsSource settings. | |
ItemsSourceId | Overridden. Gets or sets the ItemsSourceId specify which CollectionViewService will be used for this control. | |
LoadActionUrl | Gets and sets the url of load action. | |
OnClientAutoSizedColumn | Occurs 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>) | |
OnClientAutoSizedRow | Occurs 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>) | |
OnClientAutoSizingColumn | Occurs 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>) | |
OnClientAutoSizingRow | Occurs 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>) | |
OnClientBeginningEdit | Occurs before a cell enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientCellEditEnded | Occurs when a cell edit has been committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientCellEditEnding | Occurs when a cell edit is ending. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientColumnChanged | Occurs after inserting or deleting columns. | |
OnClientCopied | Occurs 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>) | |
OnClientCopying | Occurs 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>) | |
OnClientDeletedRow | Occurs after the user has deleted a row by pressing the Delete key. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDeletingRow | Occurs when the user is deleting a selected row by pressing the Delete key (see the allowDelete property). (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDraggedColumn | Occurs when the user finishes dragging a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDraggedRow | Occurs when the user finishes dragging a row. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDraggingColumn | Occurs when the user starts dragging a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDraggingColumnOver | Occurs as the user drags a column to a new position. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDraggingRow | Occurs when the user starts dragging a row. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDraggingRowColumn | Occurs when dragging the rows or the columns of the FlexSheet. | |
OnClientDraggingRowOver | Occurs as the user drags a row to a new position. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientDroppingRowColumn | Occurs when dropping the rows or the columns of the FlexSheet. | |
OnClientFormatItem | Occurs when an element representing a cell has been created. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientGotFocus | Occurs when the control gets the focus. (Inherited from C1.Web.Mvc.Control) | |
OnClientGroupCollapsedChanged | Occurs after a group has been expanded or collapsed. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientGroupCollapsedChanging | Occurs when a group is about to be expanded or collapsed. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientItemsSourceChanged | Occurs after the grid has been bound to a new items source. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientLoaded | Occurs after the @see:FlexSheet loads the @see:Workbook instance. | |
OnClientLoadedRows | Occurs after the grid rows have been bound to the data source. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientLoadingRows | Occurs before the grid rows are bound to the data source. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientLostFocus | Occurs when the control loses the focus. (Inherited from C1.Web.Mvc.Control) | |
OnClientPasted | Occurs 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>) | |
OnClientPastedCell | Occurs after the user has pasted content from the clipboard into a cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientPasting | Occurs 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>) | |
OnClientPastingCell | Occurs when the user is pasting content from the clipboard into a cell. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientPrepareCellForEdit | Occurs when an editor cell is created and before it becomes active. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientPrepareChangingColumn | Occurs before inserting or deleting columns. | |
OnClientPrepareChangingRow | Occurs before inserting or deleting rows. | |
OnClientRemoteLoaded | Occurs after remote loading the data from sever. | |
OnClientRemoteLoading | Occurs before remote loading the data from server. | |
OnClientRemoteSaved | Occurs when saving the file back to sever successfully. | |
OnClientRemoteSaving | Occurs before saving the file back to server. | |
OnClientResizedColumn | Occurs when the user finishes resizing a column. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientResizedRow | Occurs when the user finishes resizing rows. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientResizingColumn | Occurs as columns are resized. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientResizingRow | Occurs as rows are resized. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientRowAdded | Occurs when the user creates a new item by editing the new row template (see the allowAddNew property). (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientRowChanged | Occurs after inserting or deleting rows. | |
OnClientRowEditEnded | Occurs when a row edit has been committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientRowEditEnding | Occurs when a row edit is ending, before the changes are committed or canceled. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientRowEditStarted | Occurs after a row enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientRowEditStarting | Occurs before a row enters edit mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientScrollPositionChanged | Occurs after the control has scrolled. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientSelectedSheetChanged | Occurs when current sheet index changed. | |
OnClientSelectionChanged | Occurs after selection changes. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientSelectionChanging | Occurs before selection changes. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientSheetCleared | Occurs when the FlexSheet is cleared. | |
OnClientSheetVisibleChanged | Occurs after the visible of the sheet in the sheet collection of the FlexSheet has changed. | |
OnClientUnknownFunction | Occurs when the @see:FlexSheet meets the unknown formula. | |
OnClientUpdatedLayout | Occurs after the grid has updated its internal layout. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientUpdatedView | Occurs when the grid finishes creating/updating the elements that make up the current view. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientUpdatingLayout | Occurs before the grid updates its internal layout. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
OnClientUpdatingView | Occurs when the grid starts creating/updating the elements that make up the current view. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
PreserveOutlineState | Gets 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>) | |
PreserveSelectedState | Gets 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>) | |
RowHeadersTemplate | Overridden. Gets the templates applied in row header cells. | |
SaveActionUrl | Gets and sets the url of save action. | |
SaveContentType | Gets or sets the type of remote saving data. | |
ScrollPosition | Gets or sets the position of the grid's scrollbars. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
ScrollToSelection | Gets or sets the value specify whether to scroll the seletion into view. | |
SelectedSheetIndex | Gets or sets the index of the current sheet in the FlexSheet. | |
Selection | Gets or sets the current selection. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
SelectionMode | Gets or sets the current selection mode. (Inherited from C1.Web.Mvc.FlexGridBase<object>) | |
Selector | Gets or sets a value which specifies the selector. (Inherited from C1.Web.Mvc.Control) | |
ShowAlternatingRows | Gets 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>) | |
ShowColumnFooters | Gets 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>) | |
ShowErrors | Gets 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>) | |
ShowFilterIcons | Gets or sets the visibility of the filter icon. | |
ShowGroups | Overridden. Gets or sets whether the grid should insert group rows to delimit data groups. | |
ShowMarquee | Overridden. Gets or sets a value that indicates whether the grid should display a marquee element around the current selection. | |
ShowSelectedHeaders | Overridden. Gets or sets a value that indicates whether the grid should add class names to indicate selected header cells. | |
ShowSort | Overridden. Gets or sets whether the grid should display sort indicators in the column headers. | |
SortRowIndex | Overridden. Gets or sets the index of row in the column header panel that shows and changes the current sort. | |
StickyHeaders | Overridden. Gets or sets a value that determines whether column headers should remain when the user scrolls the window. | |
TemplateBindings | Gets the collection of the template bindings. (Inherited from C1.Web.Mvc.Control) | |
TopLeftCellsTemplate | Overridden. Gets the templates for the topleft cells. | |
TreeIndent | Overridden. Gets or sets the indent used to offset row groups of different levels. | |
UniqueId | Gets a value which represents the unique id for the control. (Inherited from C1.Web.Mvc.Control) | |
ValidateEdits | Gets 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>) | |
Width | Gets or sets the width of the control. (Inherited from C1.Web.Mvc.Control) | |
Workbook | Gets or sets the Workbook model. |
Name | Description | |
---|---|---|
Render | Render the component result to the writer. (Inherited from C1.Web.Mvc.Control) | |
ToHtmlString | Returns an HTML-encoded string. (Inherited from C1.Web.Mvc.Component) |
Name | Description | |
---|---|---|
ToTemplate(IHtmlString) | Render the html string in template mode. |