FlexSheet Class

The FlexSheet control extends the FlexGrid control and provides an Excel-like functionality.

Inheritance

object

Component

Control

ItemsBoundControl<object>

FlexGridBase<object>

FlexSheet

Implements

IHtmlString

ITemplate

Namespace: C1.Web.Mvc.Sheet

Assembly: C1.Web.Mvc.FlexSheet.dll

Syntax

public class FlexSheet : FlexGridBase<object>, IHtmlString, ITemplate

Public Class FlexSheet
    Inherits FlexGridBase(Of Object)
    Implements IHtmlString, ITemplate

Constructors

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.