-
dotnet-api
- C1.Web.Mvc Assembly
- C1.Web.Mvc.Finance Assembly
-
C1.Web.Mvc.FlexSheet Assembly
- C1.JsonNet.Converters
-
C1.Web.Mvc.Sheet
-
Classes
- BandedTableSectionStyle
- Border
- BorderCollection
- BoundSheet<T>
- Cell
- CellPosition
- CellStyle
- Column
- ColumnFilterSetting
- ConditionFilterSetting
- DefinedName
- Fill
- FilterSetting
- FlexSheet
- FlexSheetFilter
- FlexSheetHelper
- FlexSheetLoadResponse
- FlexSheetRequestAttribute
- FlexSheetRequestModelBinder
- FlexSheetSaveRequest
- FlexSheetSaveResponse
- Font
- FormulaBar
- FrozenPane
- Range
- Row
- Sheet
- Style
- Table
- TableColumn
- TableSectionStyle
- TableStyle
- TextRun
- UnboundSheet
- ValueFilterSetting
- Workbook
- WorkbookTable
- WorkbookTableBandedStyle
- WorkbookTableBorder
- WorkbookTableColumn
- WorkbookTableCommonStyle
- WorkbookTableStyle
- Worksheet
- Enums
-
Classes
- C1.Web.Mvc.Sheet.Fluent
- C1.Web.Mvc.FlexViewer Assembly
- C1.Web.Mvc.MultiRow Assembly
- C1.Web.Mvc.Olap Assembly
- C1.Web.Mvc.TransposedGrid Assembly
- C1.Web.Mvc.TransposedMultiRow Assembly
C1.Web.Mvc.Sheet.FlexSheet
FlexSheet Class
The FlexSheet control extends the FlexGrid control and provides an Excel-like functionality.
Namespace: C1.Web.Mvc.Sheet
Assembly: C1.Web.Mvc.FlexSheet.dll
Syntax
public class FlexSheet : FlexGridBase<object>, IHtmlString, ITemplateConstructors
| Name | Description |
|---|---|
| FlexSheet(HtmlHelper, string) | Creates one FlexSheet instance. |
Properties
| Name | Description |
|---|---|
| AllowAutoFill | Gets 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. |
| AllowDragging | Gets or sets whether users are allowed to drag rows and/or columns with the mouse. |
| AllowResizing | Gets or sets whether users are allowed to resize rows and/or columns with the mouse. |
| AllowSorting | This property is useless in FlexSheet. |
| AppendedSheets | Gets the FlexSheet appended sheets. |
| AutoGenerateColumns | Gets Sets Auto Generate Columns on FlexSheet |
| CalculationPrecision | Gets or sets the number of digits after the decimal point to round to when calculating formulas. Negative value means that no rounding is performed. |
| CellsTemplate | This property is useless in FlexSheet. |
| ChildItemsPath | This property is useless in FlexSheet. |
| ColumnHeadersTemplate | This property is useless in FlexSheet. |
| Columns | This property is not recommended for FlexSheet. |
| DefinedNames | Gets a collection of the DefinedName objects representing named ranges/expressions defined in the FlexSheet. |
| EnableDragDrop | Gets or sets the value to indicates whether enable drag and drop rows or columns in FlexSheet. |
| EnableFormulas | Gets or sets the value to indicates whether enable formulas in FlexSheet. |
| FilePath | Gets or sets the path of the xlsx file. |
| FileStream | Gets or sets the Stream of the xlsx file. |
| Filter | Gets the filter settings for this FlexSheet. |
| GroupHeaderFormat | This property is useless in FlexSheet. |
| HeadersVisibility | This property is useless in FlexSheet. |
| IsTabHolderVisible | Gets or sets a value indicating whether the TabHolder is visible. |
| ItemFormatter | Gets or sets a formatter function used to customize cells on this grid. |
| ItemsSource | This property is useless in FlexSheet. |
| ItemsSourceId | This property is useless in FlexSheet. |
| KeyActionTab | Gets or sets the action to perform when the TAB key is pressed. |
| LoadActionUrl | Gets and sets the url of load action. |
| OnClientAutoFilled | Occurs after has performed the auto-fill operation. |
| OnClientAutoFilling | Occurs before performing the auto-fill operation. |
| OnClientBeginDroppingRowColumn | Occurs when begin dropping the rows or the columns of the FlexSheet. |
| OnClientColumnChanged | Occurs after inserting or deleting columns. |
| OnClientDraggingRowColumn | Occurs when dragging the rows or the columns of the FlexSheet. |
| OnClientEndDroppingRowColumn | Occurs when end dropping the rows or the columns of the FlexSheet. |
| OnClientLoaded | Occurs after the @see:FlexSheet loads the @see:Workbook instance. |
| 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. |
| OnClientRowChanged | Occurs after inserting or deleting rows. |
| OnClientSelectedSheetChanged | Occurs when current sheet index changed. |
| 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. |
| QuickAutoSize | This property is useless in FlexSheet. |
| RowHeadersTemplate | This property is useless in FlexSheet. |
| SaveActionUrl | Gets and sets the url of save action. |
| SaveContentType | Gets or sets the type of remote saving data. |
| 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. |
| ShowFilterIcons | Gets or sets the visibility of the filter icon. |
| ShowGroups | This property is useless in FlexSheet. |
| ShowMarquee | Gets or sets a value that indicates whether the grid should display a marquee element around the current selection. |
| ShowSelectedHeaders | Gets or sets a value that indicates whether the grid should add class names to indicate selected header cells. |
| ShowSort | This property is useless in FlexSheet. |
| SortRowIndex | This property is useless in FlexSheet. |
| SortingType | This property is useless in FlexSheet. |
| TopLeftCellsTemplate | This property is useless in FlexSheet. |
| TreeIndent | This property is useless in FlexSheet. |
| Workbook | Gets or sets the Workbook model. |
Methods
| Name | Description |
|---|---|
| CreateChildComponents() | Ensure that all child components have been added. |
| RegisterStartupScript(HtmlTextWriter) | Override to render the extender startup scripts. |