| 名前 | 解説 | |
|---|---|---|
 | FlexSheet コンストラクタ | Creates one FlexSheet instance. |
FlexSheetデータ型で公開されるメンバを以下の表に示します。
パブリック コンストラクタ
パブリック プロパティ
| 名前 | 解説 | |
|---|---|---|
 | 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| 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. |
| AllowDelete | Gets or sets a value that indicates whether the grid should delete selected rows when the user presses the Delete key. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AllowDragging | オーバーライドされます。 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AllowResizing | オーバーライドされます。 Gets or sets whether users are allowed to resize rows and/or columns with the mouse. |
| AllowSorting | オーバーライドされます。 This property is useless in FlexSheet. |
| AlternatingRowStep | Gets or sets a value that determines the number of regular rows between 'alternating' rows. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AnchorCursor | Gets 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AppendedSheets | Gets the FlexSheet appended sheets. |
| AutoClipboard | Gets or sets whether the grid should handle clipboard shortcuts. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AutoGenerateColumns | オーバーライドされます。 Gets Sets Auto Generate Columns on FlexSheet |
| AutoRowHeights | Gets or sets a value that determines whether the grid should automatically resize the rows when the data or grid layout change. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AutoScroll | Gets or sets a value that determines whether the grid should automatically scroll its contents while users drag rows or columns into new positions. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AutoSearch | Gets or sets a value that determines whether the grid should search for cells as the users types into read-only cells. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| AutoSizeMode | Gets or sets which cells should be taken into account when auto-sizing a row or column. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| BigCheckboxes | Gets or sets a value that determines whether the checkboxes used to edit boolean columns should extend to cover the whole cell width. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| BottomLeftCellsTemplate | Gets the templates applied in bottom left cells. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| 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. |
| CaseSensitiveSearch | Gets or sets a value that determines whether searches performed while the user types should case-sensitive. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| CellsTemplate | オーバーライドされます。 This property is useless in FlexSheet. |
| ChildItemsPath | オーバーライドされます。 This property is useless in FlexSheet. |
| CloneFrozenCells | Gets 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| ColumnFootersRowHeaderText | Gets or sets the text for the group row header in the column footers panel. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| ColumnFootersTemplate | Gets the templates applied in column footers cells. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| ColumnHeadersTemplate | オーバーライドされます。 This property is useless in FlexSheet. |
| 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| Columns | オーバーライドされます。 This property is not recommended for FlexSheet. |
| Components | Gets the child components. C1.Web.Mvc.Componentから継承されます。 |
| CopyHeaders | Gets or sets copied header cells when copying the content to the clipboard. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| CssClass | Gets or sets the css class of the control. C1.Web.Mvc.Controlから継承されます。 |
| CssStyles | Gets the CSS style applied in the control. C1.Web.Mvc.Controlから継承されます。 |
| DefaultColumnSize | Gets or sets the default size of columns in the column collection. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| DefaultRowSize | Gets or sets the default size of rows in the row collection. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| DefaultTypeWidth | Gets the static object that defines the default width for auto-generated grid columns based on their types. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| DeferResizing | Gets or sets whether row and column resizing should be deferred until. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| 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. |
| ErrorTip | Gets the error tooltip of FlexGrid. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| ExpandSelectionOnCopyPaste | Gets 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| Extenders | Gets the extender collection. 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. |
| Filter | Gets the filter settings for this FlexSheet. |
| FrozenColumns | Gets or sets the number of frozen columns. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| FrozenRows | Gets or sets the number of frozen columns. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| GroupHeaderFormat | オーバーライドされます。 This property is useless in FlexSheet. |
| HeadersVisibility | オーバーライドされます。 This property is useless in FlexSheet. |
| HeaderTemplate | C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| Height | Gets or sets the height of the control. C1.Web.Mvc.Controlから継承されます。 |
| HtmlAttributes | Gets the HTML attributes. C1.Web.Mvc.Controlから継承されます。 |
| Id | Gets or sets the component id. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| IsDisabled | Gets or sets a value that determines whether the control is disabled. C1.Web.Mvc.Controlから継承されます。 |
| IsReadOnly | Gets or sets whether the user can edit the grid cells by typing into them. 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. C1.Web.Mvc.Controlから継承されます。 |
| 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. |
| ItemValidator | Gets or sets a validator function to determine whether cells contain valid data. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| KeyActionEnter | Gets or sets the action to perform when the ENTER key is pressed. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| KeyActionTab | オーバーライドされます。 Gets or sets the action to perform when the TAB key is pressed. |
| LazyRender | Gets or sets whether the grid should skip rendering cells that were updated in the last render cycle. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| 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. |
| OnClientAutoSizedColumn | Occurs after the user auto-sizes a column by double-clicking the right edge of a column header cell. 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. 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. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientBeginDroppingRowColumn | Occurs when begin dropping the rows or the columns of the FlexSheet. |
| OnClientBeginningEdit | Occurs before a cell enters edit mode. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientCellEditEnded | Occurs when a cell edit has been committed or canceled. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientCellEditEnding | Occurs when a cell edit is ending. 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). 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). C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientDeletedRow | Occurs after the user has deleted a row by pressing the Delete key. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientDeletingRow | Occurs when the user is deleting a selected row by pressing the Delete key (see the allowDelete property). C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientDraggedColumn | Occurs when the user finishes dragging a column. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientDraggedRow | Occurs when the user finishes dragging a row. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientDraggingColumn | Occurs when the user starts dragging a column. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientDraggingColumnOver | Occurs as the user drags a column to a new position. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientDraggingRow | Occurs when the user starts dragging a row. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientEndDroppingRowColumn | Occurs when end dropping the rows or the columns of the FlexSheet. |
| OnClientFormatItem | Occurs when an element representing a cell has been created. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientGotFocus | Occurs when the control gets the focus. C1.Web.Mvc.Controlから継承されます。 |
| OnClientGroupCollapsedChanged | Occurs after a group has been expanded or collapsed. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientGroupCollapsedChanging | Occurs when a group is about to be expanded or collapsed. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientItemsSourceChanged | Occurs after the grid has been bound to a new items source. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientItemsSourceChanging | Occurs after the grid has been bound to a new items source. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientLoadingRows | Occurs before the grid rows are bound to the data source. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientLostFocus | Occurs when the control loses the focus. 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). C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientPastedCell | Occurs after the user has pasted content from the clipboard into a cell. 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). C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientPastingCell | Occurs when the user is pasting content from the clipboard into a cell. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientPinnedColumn | Occurs as columns are pinned. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientPinningColumn | Occurs as columns are pinning. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientPrepareCellForEdit | Occurs when an editor cell is created and before it becomes active. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientPrepareChangingColumn | Occurs before inserting or deleting columns. |
| OnClientPrepareChangingRow | Occurs before inserting or deleting rows. |
| OnClientRefreshed | Occurs after the control has refreshed its contents. C1.Web.Mvc.Controlから継承されます。 |
| OnClientRefreshing | Occurs when the control is about to refresh its contents. C1.Web.Mvc.Controlから継承されます。 |
| 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientResizedRow | Occurs when the user finishes resizing rows. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientResizingColumn | Occurs as columns are resized. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientResizingRow | Occurs as rows are resized. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientRowAdded | Occurs when the user creates a new item by editing the new row template (see the allowAddNew property). C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientRowChanged | Occurs after inserting or deleting rows. |
| OnClientRowEditEnded | Occurs when a row edit has been committed or canceled. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientRowEditEnding | Occurs when a row edit is ending, before the changes are committed or canceled. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientRowEditStarted | Occurs after a row enters edit mode. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientRowEditStarting | Occurs before a row enters edit mode. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientScrollPositionChanged | Occurs after the control has scrolled. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientSelectedSheetChanged | Occurs when current sheet index changed. |
| OnClientSelectionChanged | Occurs after selection changes. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientSelectionChanging | Occurs before selection changes. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientUpdatedView | Occurs when the grid finishes creating/updating the elements that make up the current view. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientUpdatingLayout | Occurs before the grid updates its internal layout. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| OnClientUpdatingView | Occurs when the grid starts creating/updating the elements that make up the current view. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| PinningType | Gets or sets how the grid pins the column headers by clicking the icons toggles the column's frozen state 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. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| PreserveWhiteSpace | Gets 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 C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| QuickAutoSize | オーバーライドされます。 This property is useless in FlexSheet. |
| RefreshOnEdit | Gets or sets whether the grid should refresh all cells after a cell is edited. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| RowHeaderPath | Gets or sets the name of the property used to create row header cells. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| 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. |
| ScrollPosition | Gets or sets the position of the grid's scrollbars. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| SelectionMode | Gets or sets the current selection mode. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| Selector | Gets or sets the selector to macth the dom element(s) which the control is attached to. 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. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| ShowDropDown | Gets 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. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| 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. |
| ShowPlaceholders | Gets 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| 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. |
| SortingType | オーバーライドされます。 This property is useless in FlexSheet. |
| SortRowIndex | オーバーライドされます。 This property is useless in FlexSheet. |
| StickyHeaders | Gets or sets a value that determines whether column headers should remain when the user scrolls the window. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| TabOrder | Gets or sets a value of the tabindex attribute associated with the control. C1.Web.Mvc.Controlから継承されます。 |
| TemplateBindings | Gets the collection of the template bindings. C1.Web.Mvc.Controlから継承されます。 |
| TopLeftCellsTemplate | オーバーライドされます。 This property is useless in FlexSheet. |
| TreeIndent | オーバーライドされます。 This property is useless in FlexSheet. |
| UniqueId | Gets a value which represents the unique id for the control. 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. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| VirtualizationThresholds | Gets or sets the minimum number of rows and/or columns required to enable virtualization. C1.Web.Mvc.FlexGridBase<object>から継承されます。 |
| Width | Gets or sets the width of the control. C1.Web.Mvc.Controlから継承されます。 |
| Workbook | Gets or sets the Workbook model. |
パブリック メソッド
| 名前 | 解説 | |
|---|---|---|
 | Render | C1.Web.Mvc.Controlから継承されます。 |
| WriteTo | Writer the process result of current instance to the writer. C1.Web.Mvc.Componentから継承されます。 |
参照